Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2010

Script of the week

Every week I will scour the internet for useful SQL scripts and post my favorite on here.

This weeks comes from :-

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… Read more

0 comments, 288 reads

Posted in on 23 April 2010

SQL Server 2008 R2 reaches RTM

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.

Read more

0 comments, 281 reads

Posted in on 22 April 2010

SQL Server Agent

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 !

Read more

0 comments, 277 reads

Posted in on 20 April 2010

SQL Server 2008 Database Mirroring – Abi Chapagai


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… Read more

0 comments, 1,911 reads

Posted in on 18 April 2010

Difference between log shipping and database mirroring

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… Read more

6 comments, 8,440 reads

Posted in on 18 April 2010