Sqlserverplanet - sqlserverplanet.com
General Information:
Latest News:
Find Disk IO Statistics DMV 14 Jul 2013 | 11:15 pm
This gem of a query has been indispensable in determining IO latency for our servers. The benefit of this is not having to rely on perfmon to interpret the latency (which can be a crapshoot). Here, SQ...
SQL Planet Article Contest 27 Feb 2013 | 10:37 am
As of this article there are only 17 days left in the SQL Planet article contest. Your current chances of winning are very good based upon the number of submissions we’ve received – (given you have a ...
Top 3 SQL Errors That Will Leave Your Users Stranded 22 Feb 2013 | 12:00 am
Over the years I’ve ran across certain situations that cause errors in SQL that error out the calling application if they are not correctly trapped. As unsuspecting as these can be, you end up learnin...
SQL Server Database Optimization Guide 6 Feb 2013 | 02:15 pm
In the troubleshooting guide we went over the different physical bottlenecks that can cause SQL Server slowness and showed how to identify them. In this guide, we’ll drill down one step deeper to help...
Comparing EXISTS vs LEFT JOIN WHERE NOT NULL 27 Dec 2012 | 01:50 am
Two of the most common ways to check for the existence of records is to use a WHERE EXISTS or to perform a LEFT JOIN WHERE values are NOT NULL. My personal choice is usually to use the EXISTS method w...
Yet Another Temp Tables Vs Table Variables Article 9 Dec 2012 | 02:30 pm
The debate whether to use temp tables or table variables is an old debate that goes back since they were first introduced. The real answer to knowing the difference lies in what is going on under the ...
The Difference Between UNION and UNION ALL 5 Dec 2012 | 03:25 am
If you’re like me, after using UNION for many years you may have stumbled upon the UNION ALL and thought, what the heck is the difference? Well it’s pretty simple. UNION gives you the unique results f...
Using WITH (NOLOCK) 30 Nov 2012 | 11:56 am
The WITH (nolock) hint is an explicit command directed at a specific table or view used to set the transaction isolation level against the table or tables within a view for a specific query. Once issu...
Detecting Row Level Changes 17 Nov 2012 | 05:02 am
A common situation in a data warehouse is the requirement to detect changes in data in order to track delta changes. The traditional methods of verifying the value of each field against a change table...
How to order numeric values in a varchar field 2 Nov 2012 | 10:00 am
If you have ever tried to order numerical values in a varchar field you’ll know that the sort doesn’t occur numerically as it would if the datatype were numeric. In other words, the values of 1 and 10...
