Here's a utility that you can use to quickly find which columns have mismatched data types across tables in a SQL Server 2008 or SQL Server 2005 database. Correcting these columns can improve performance and data integrity.
SQL Server Management Studio (SSMS) lacks an easy-to-use tool to get detailed data about partitioned tables. To fill this gap, a reader has created two tools. One provides the data in a results grid, whereas the other provides the data in a report.
You can use the TOP clause to limit the transaction size, but there's a trick to using it: You need to keep track of which rows have already been updated so that you don’t update them a second time. Here's how to keep track of the rows.
It used to be difficult to answer questions such as "When was the last time this job was run?" and "What jobs will be affected if we bring down the system for maintenance?" With the cspJobMonitor procedure that's no longer the case.
If you often need to display the current date in different formats, you know that it can take a lot of code and effort. The FormatDate function changes that. By providing just two parameters, you can display any date in the format you need.
Important post migration tasks are outlined in part III of this series on the steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or migration....More
Here's Part II of an overview of actual steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or migration. Part II covers preparing databases for migration, 13 migration steps, and failback tips....More
Get an overview of actual steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or migration. Part I addresses guiding principles, acceptance testing, and your communication plan....More