Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.
SQLAuthority News – Author Visit – SQL Server 2008 R2Â Launch
June 11, 2010 was a wonderful day because I attended the very first SQL Server 2008 R2 Launch event held by Microsoft at Mumbai. I traveled to Mumbai from my home town, Ahmedabad. The event was located at one of the best hotels in Mumbai,”The Leela”. SQL Server R2 Launch…
Read MoreSQL SERVER – What is Denali?
I see following question quite common on Twitter or in my email box. “What is Denali?” Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Microsoft released its first version of SQL Server. It was…
Read MoreSQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE
Earlier I wrote blog post SQL SERVER – Difference Between GETDATE and SYSDATETIME which inspired me to write SQL SERVER – Difference Between DATETIME and DATETIME2. Now earlier two blog post inspired me to write this blog post (and 4 emails and 3 reads from readers). I previously populated DATETIME…
Read MoreSQL SERVER – Difference Between DATETIME and DATETIME2
Yesterday I have written a very quick blog post on SQL SERVER – Difference Between GETDATE and SYSDATETIME and I got tremendous response for the same. I suggest you read that blog post before continuing with this blog post today. I had asked people to honestly take part and share…
Read MoreSQL SERVER – Difference Between GETDATE and SYSDATETIME
Sometime something so simple skips our mind. I never knew the difference between GETDATE and SYSDATETIME. I just ran simple query as following and realized the difference. SELECT GETDATE() fn_GetDate, SYSDATETIME() fn_SysDateTime In case of GETDATE the precision is till miliseconds and in case of SYSDATETIME the precision is till…
Read More
SQL SERVER – Fastest Way to Restore Database
A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.