Similar articles
Journey to SQL Authority with Pinal Dave
SQL SERVER – Demo Script – Keeping CPU Busy
Recently face very interesting situation, during presentations at event, I was asked very famous questions: “My CPU is very high all the time, how can I reduce it?” This is very interestin...
Journey to SQL Authority with Pinal Dave
SQL SERVER – Download Logical Query Processing Poster
Earlier this year, I had written article on SQL SERVER – Logical Query Processing Phases – Order of Statement Execution and I had asked one question to readers. I got very good response for this quest...
DotNetShoutout - Latest published stories
New LOGICAL functions in SQL Server Denali
IFF Function If you are an old Access or Excel “developer” you know this one. This is not a function I have been missing before I read about it today. If you, like me, is so tired of writing CASE stat...
DotNetShoutout - Latest published stories
SQL Server: High Logical Reads for Strange Worktable
Few days back, on production database server, I found that logical reads value for a specific store procedure is much high then our expectations (benchmarks). I simply took the execution statement and...