Every week I will scour the internet for useful SQL scripts and post my favorite on here. This weeks comes from SQLServerCentral.com :- Select * Into [New Table Name] From [Table to be copied] Where 1=2 Here you can copy a table structure, without the data, into a new table - all in one line of code !! (1=2 is the condition for not copying data). Thanks to Kaifi...

On April 21 Microsoft announced SQL Server 2008 R2 has been released to manufacturing. The downloads on Technet/MSDN on May 3. International downloads on May 13. You can read about the changes in R2 on the Microsoft SQL Server site.

Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU utilisation to be more effective and efficient). Also, if feasible, restart the SQL Server service once a month !

 Introduction In any distributed environment, database synchronization between two different locations or different servers’ is very essential for mission critical applications. For any reason, if the database server failed, these mission critical applications should point to the database as quickly as possible without loss of committed data. In real time...

Compiled by Abi Chapagai (April 2010) Implementation of High Availability depends in the need of the business. Each of the technologies has advantages and disadvantages and sometime the situation comes where there cannot be any choice between them. I have recently implemented log shipping and database mirroring and would like to address difference between them. Both...