Rollback TRUNCATE TABLE statement

Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...

Blocking in SQL Server by SPID -2 (Orphan distributed transactions)

Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...

Jump start your SQL 2012 Certification for FREE

Hey all you proactive SQL junkies, want to jump start your SQL 2012 Certification? Or are you just here because...

How to Find Bad Page Splits

http://www.flickr.com/photos/brickapolis/5474835288/

I was working with a friend last week, doing SQL related teaching and tune ups.  Earlier this week I had...

Learn to Use Books Online

One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...

The first record on data page.

TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...

Recovering from out-of-disk space conditions for tempdb

Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...

SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password

What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...

What's new in Reporting Services 2012 Free Webinar

We are starting our free monthly webinars with 'What's new in Reporting Services 2012' on Wednesday August 8, 2012 at 12...

SQL Server - Oracle Architectural comparison

This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...