posts - 218, comments - 410, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

October 2008 Blog Posts

PASS Board of Directors Election coming up

The annual elections for the Board of Directors is coming up.  The nomination process is open right now. Serving on the Board is a very rewarding experience.  I've had the chance to meet a number of great people and be part of a fantastic event.  There's more information on the web page I liked to.

posted @ Friday, October 17, 2008 11:55 AM | Feedback (0) | Filed Under [ PASS ]

Capturing the text of a prepared SQL statement run with sp_execute

Many times when running a trace against SQL Server you'll see RPC:Completed events that look like this: exec sp_execute 66,4,4 Unfortunately this statement was the one causing me a performance problem and I had no idea what it was doing.  The 66 is the number of the statement to execute and the two 4's are the parameters passed to the statement.  The 66 is specific to a connection -- meaning the SQL is prepared for only that session.  I talked about the sequence of statements that are part of preparing and un-preparing SQL in Examining SQL Server Trace...

posted @ Friday, October 10, 2008 8:41 AM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Congratulations Derek

I wanted to congratulate Derek Comingore on being named an MVP.  He's a regular blogger here on SQLTeam.com on Business Intelligence topics.  It's great to see community participation acknowledged by Microsoft.

posted @ Thursday, October 02, 2008 7:48 AM | Feedback (1) | Filed Under [ Miscellaneous Site Related ]

Powered by:
Powered By Subtext Powered By ASP.NET