Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 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… Read more

0 comments, 161 reads

Posted in DatabaseExpertise.com 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, 152 reads

Posted in DatabaseExpertise.com 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, 165 reads

Posted in DatabaseExpertise.com on 20 April 2010

SQL Server 2008 Database Mirroring – Abi Chapagai

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

0 comments, 1,366 reads

Posted in DatabaseExpertise.com 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, 2,019 reads

Posted in DatabaseExpertise.com on 18 April 2010