Browse by Tags

SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

Published 22 January 8 7:55 AM | SSQA.net

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that...

Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

Best option to choose when importing data from a text file where heavy inserts and updates are involved!

Published 8 November 7 1:49 AM | SSQA.net

A specific task of importing data from a text file or any data source where heave inserts and updates are involved is quite common scenario in any SQL Server platform. So when you need to perform such actions on regular basis you need what's the best...

Filed under: sql server, ssis, dts, best practices, etl, bcp, data files, integration services

"Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>' is invalid

Published 17 September 7 4:44 AM | SSQA.net

Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ""Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>'...

Filed under: sql server, error, error log, hardware, log file, detach, attach, data files, 9003, mdf

FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005

Published 12 September 7 12:48 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: The ghost row clean-up thread does not remove ghost rows on some data files of...

Filed under: sql server, database, kba, data files, ghost, rows, cleanup