Move a database from one server to another server in SQL Server 2008

There are many ways to move/copy a database from one server to another server using SQL Server Tools.i) Detach the database from the old server and attach it in the new server. This is purely offline operation and it moves the database instead of copying it.Refer http://msdn.microsoft.com/en-us/library/ms190209.aspx : how to use attach/detach database in SQL Server Management…

21

How to un install SQL Server 2005

You can use these docs for uninstalling your 2005 sql instance based on your requirement. Uninstalling an instance of SQL Server 2005 manuallyhttp://support.microsoft.com/?kbid=909967 Windows Installer Clean-Up Toolhttp://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe Uninstall SQL Server Management Studiohttp://support.microsoft.com/default.aspx?scid=kb;EN-US;909953 Using the Add or Remove Programs item in Control Panel to add or remove components for stand-alone installations and clustered installations of SQL…

1

Sparse Columns in SQL Server 2008

Introduction In the real world customer scenarios, the customer data can be of heterogeneous and semi structured stored inside SQL Sever tables. In such tables,  the data  can have different properties applying to different set of subsets of rows. In such cases, SQL Server tables contains columns which are populated with values only for the…

3

Auditing SELECT statements in SQL Server 2008

Prior to SQL Server 2008, the only way to audit the SELECT statements is to use SQL Server Profiler or server side trace. Now using SQL Server 2008 Enterprise, auditing feature is used to audit on SELECT statements. We cannot use triggers as triggers are not fired on SELECT statements. Audit object is used to…

9