Moving From MSDN To WordPress :: New Blog URL

“For everything you have missed, you have gained something else, and for everything you gain, you lose something else.” – Ralph Waldo Emerson After witnessing 3 SQL Server releases (Katmai, KJ and Denali “which is yet to be RTMed”) and resolving hundreds of SQL Server issue, I’ve now decide to move ahead to a new…

0

SQL Server 2005 SP4 RTM Release………what it means with RTM or without RTM?

  SQL Server 2005 Service Pack 4 (latest SP in SQL 2005) was publically released on 18-Dec-2010. This time the word RTM suffixed to this patch name. This is 1st time that SQL Release team has added “RTM” to a SQL Service Pack release and to a degree this is created some confusion……..what is means…

3

Using Bulk Logged recovery model for Bulk Operations will Reduce the size of Transaction log backups – Myths & Truths

  It’s has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: "In a log shipping setup, to have smaller size T-log log backups being shipped to secondary,…

0

Create a SQL Server Database on a network shared drive

  Hello All, Sometime back, I have written blog post on ‘Backing-up SQL Server Database on a network shared drive’. This can be found here. I have received numerous queries on an another related topic i.e. ‘How to Create a SQL Server Database on a network shared drive’. It took sometime (a brand new SQL…

3

Index usage by %Like% operator – Query Tuning

Ok, so this one is interesting. I was reading an Internal DL (Distribution Group) post on tuning %Like% operator performance. I find some confusion in various places about index selectivity of ‘%Like%’ operator, and I decided to do few test myself. Hopefully test details below can help a bit: Problem Statement: – While optimizing high…

2

Understanding and Troubleshooting ‘Win2003 PF Usage’ on the server running SQL Server 2000

  I’ve been recently asked to explain the reason of high PF Usage on Windows 2003 server running SQL Server 2000 Enterprise Edition. Problem Statement: – From: OS Task Manager > Performance Tab: High value depicted in “PF Usage” graph. – On stopping SQL Server Service, the graph drops down. So does that mean that…

2