Lately I worked with a customer to help tune his query involving multi-statement table valued function. When using table valued functions, you should be aware of a couple of things First, there are two type of table valued functions which are inline...

I was posed a good question today about how the wait_info* event works in SQL Server 2008. The easiest way for me to answer the question was to prove the behavior. using WAITFOR DELAY it shows the behavior nicely. From: Robert Dorr Sent: Wednesday, October...

Back in a post from May ( http://blogs.msdn.com/b/psssql/archive/2010/05/30/don-t-touch-that-schema.aspx ), I reported that SSRS referenced fields by index instead of by name in code for performance benefits.  As a follow up to that, I decided to...

We recently worked with a customer who reported his update to a linked server table runs very slow. This only happens when he doesn’t specify the character parameter length in the .NET code. This actually brings up plan cache issue as well. So this...