SQL Server 2012 IIF Statement
SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of… Read More »SQL Server 2012 IIF Statement
SteveStedman
SQL Server Waits
The Waits Types page has been updated on the T-SQL Wiki.
The wait type documentation works will with the Database Health Reports historic wait time monitoring (Free download). Below is a screenshot of the Historic Waits Query Advisor in the Database Health Reports project.
Here is the current list of waits that have documentation available.
SQL Server Memory Hog Query
The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the… Read More »SQL Server Memory Hog Query
Shrinking a Log File on a Test or Development Server
On my computer I run SQL Server 2012, and I use a number of test or development databases. I don’t run backups on these because… Read More »Shrinking a Log File on a Test or Development Server
Over 400 downloads of the database health reports.
Today, the Database Health Reports had its 400th download. I would like to say thank you to everyone who is using the product, and an extra thank… Read More »Over 400 downloads of the database health reports.
Database Health Reports – Beta 5 Released Today.
The Database Health Reports application provided free of charge to the SQL Server community. Enjoy! Today I released Beta 5 of the Database Health Reports. Beta 5… Read More »Database Health Reports – Beta 5 Released Today.
3 Steps to Work More Efficiently in SSMS.
Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were… Read More »3 Steps to Work More Efficiently in SSMS.
Over 300 Dowloads of the Database Health Reports
Today, the Database Health Reports had its 300th dowload. I would like to say thank you to everyone who is using the product, and an… Read More »Over 300 Dowloads of the Database Health Reports
SQL Saturday Presentation
I am at SQL Saturday in Vancouver BC today. Here is the download of my presentation. Download zip file. Here is the presentation outline. OVER… Read More »SQL Saturday Presentation
VARCHAR diff function
Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers. Since then I have used it… Read More »VARCHAR diff function