SQL Server General DBA

Unable to install Service Pack 1 for SQL Server 2005 version.

SQL Server 2005 has many key new features including a production-ready version of database mirroring from Service Pack1 installation, in which the primary production server is mirrored at all times by a standby server. “This allows for automated, seamless failover between primary and standby server, if the primary server needs to come down”.  SP1 also includes […]

How to get resource usage of an executing query in SQL Server without using SYSMON/PERFMON utility?

Perfmon/Sysmon utility is a handy utility for Database Administrators to invoke for data to be collected on system resources usage. The logging function of this tool is useful for logging details that can be used for further analysis from the trace. The SQL Server Develoment team has made a major contribution to combining this facility with […]

Can I downgrade my SQL Server databases to an earlier version?

No, at least not using sp_detach_db, sp_attached_db; or backup and restore. But you can recreate the database schema in a database on a different version of the database and then use DTS or SSIS to move the data.

Why do I get an unordered resultset, although my table has a clustered index?

Although the presence of a clustered index often seems to produce an ordered resultset, there is no guarantee that this will work in all cases. If you execute a SELECT statement without an explicit ORDER BY, SQL Server will try to return the information in the fastest possible way. This might be or might be […]

Should we automatically reboot our SQL Servers on a weekly basis?

Question There’s a debate going on within our company about whether or not we should automatically reboot our SQL Servers on a weekly basis. We are not experiencing any current problems, but some people are saying that by regularly rebooting, we will prevent future issues. Will doing so help performance or reliability of SQL Server? […]

How do you get rid of users that are already in the database on the backup server when a restore starts?

QuestionI’m trying to implement log shipping as described in your log shipping article, with a few slight modifications. The question I have is how do you get rid of users that are already in the database on the backup server when a restore starts? If someone is using the read-only capabilities when the restore starts, […]

Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?

Here’s the script I use to move logins, along with the script I use to resynch login IDs and database user IDs after moving the logins. I did not write either one, but I have made some modifications to both of them for my own purposes. I would give credit to the original authors of […]

Import Data Using SSIS from an Excel Workbook which has Dynamic Sheets Using SSIS

Importing data from Excel is a simple task if you are using SSIS. You can accomplish this by simply drag and dropping few controls and you are done. But what if your excel workbook has dynamic sheets, which means you will not know the sheet name. Excel Sheet Let us assume we need to import […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |