SQL Server Administration

How to Recover or Repair Suspect Database in SQL Server

Suspect database in SQL Server is not very common issue but there are times we face it because of various…

How to get Last Restore Time of your database?

Database Backup and restores are common task for any database administrator.  We generally do lot of restore operations to fulfill…

How to find Total no of Traces Running on your Database Instance?

Suppose you want to find out how many traces are running on your SQL Server database instance? If you don't…

How to Move Table to Another Filegroup?

Suppose we had a database that has grown very large in size and located on the D drive that had…