Transact SQL code to identify queries with highest I/O in SQL server

SQL code to identify the queries and procedures consuming most I/O and with bad performance

What are SQL Query Hints?

SQL server usually selects the best query plan required to execute a T-SQL query. However, there might be cases where … More

Everyone reading this must have come across these datatypes, but have you ever thought what are the differences and advantages … More

By using “Merge”, you can perform insert, delete and update on a table in a single SQL statement. This helps … More

The Soundex code was developed to help negate the effects of all the spelling variations that can occur for similar … More

NULLIF( ) : Returns a null value if the two expressions specified in the function are equal. The syntax used … More

Often it might be necessary to hide the number of records affected by a query. It can be a simple … More

The GUID (uniqueidentifier) data type is one of the most interesting data types available. uniqueidentifier column holds a GUI, a … More

Renaming a database is not done very often. However, I have done it myself many times. this can be done … More

There are different ways of fetching the current time from the sql server. Sql server 2005 provides 3 different functions … More

Very often, it is important to check the last identity value inserted into a table. This can be easily done … More

The first thing that goes through your mind might be ” why cant we SP_SPACEUSED instead ? “. You are … More

Many developers have asked me, if there is any way to check the existence of a string or text with … More

This post discusses about ways to change the system messages with custom messages . This is not widely used, as it … More

I had been seeing lot of SQL best practices posts on the web. I found some points missing in many of these … More

Identity columns automatically inserts value for each record inserted into the table . These columns are commonly used as primary … More

Sometimes it is important to get the owner of each database in a server. You can do this by checking … More

Usually problem occurs when we are trying to build a query dynamically and if the length exceeds 4000 characters ( … More

You might have encounterd the errors related to compatibility while running DMVs and functions on sql server databases. The error … More

You might have faced a challenge to perform some operation on all the tables in a database. For example truncate … More

The developers who work on sql servers, located across the globe, face various issues related to datetime formats used. Some … More