Backup/Restore vs Detach & Attach

You want to move a database from one server to another. There are two options to do that.

1) Detach/Attach: To...

Reading SQL Error log

SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...

ALTER TABLE - Adding Column - Column Order Impact

Most of us would have altered a table structre by adding a column to the table. When an ALTER table...

Altering Table structure - SSMS - Timeout Expired

Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...

Database Owner - Error Message

Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.

You...

I am back

I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...

Finding last database growth date and time

A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...

Server Side trace

Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...

Perfmon counters list - Quest poster

Stumbled upon this PDF from quest which lists the important Perfmon counters and their acceptable values. A must print and...

Lock escalation : SQL Server 2008

Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...