A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.
SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution
This blog post is written in response to T-SQL Tuesday hosted by Jorge Segarra. I have been very active using these Merge operations in my development. However, I have found out from my consulting work and friends that these amazing operations are not utilized by them most of the time. Here is my attempt to bring the necessity of using the Merge Operation to surface one more time.
SQL SERVER – Convert IN to EXISTS – Performance Talk
In recent training one of the attendee asked if I can show a simple method to convert IN clause to EXISTS clause so it impacts performance. Here is the simple example.
SQL SERVER – Generate Database Script for SQL Azure
When talking about SQL Azure the common complaint I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure, but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate a script which is compatible with SQL Azure.
SQLAuthority News – SQL Funny Quotes
Here are few SQL Funny Quotes.
Q. What if your Dad loses his car keys?
A. ‘Parent keys not found!’
SQL SERVER – Disabled Index and Update Statistics
When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Let us learn about Disabled Index and Update Statistics.
SQL SERVER – DATE and TIME in SQL Server 2008
I was thinking about DATE and TIME datatypes in SQL Server 2008. I earlier wrote about the about best practices of the same. Recently I had written one of the scripts written for SQL Server 2008 had to run on SQL Server 2005 (don’t ask me why!), I had to convert the DATE and TIME datatypes to DATETIME. Let me run a quick demo for the same.