Category: General DBA
How do I get the taskpad view in SQL Server Management Studio as it was in SQL Server 2000 version?
Unable to install Service Pack 1 for SQL Server 2005 version.
DTS package error "Cannot find specified package in the storage location specified".
How to get resource usage of an executing query in SQL Server without using SYSMON/PERFMON utility?
Should we automatically reboot our SQL Servers on a weekly basis?
How do you get rid of users that are already in the database on the backup server when a restore starts?
Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?
Can I downgrade my SQL Server databases to an earlier version?
Why do I get an unordered resultset, although my table has a clustered index?