Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2010

SQL Bits 7 – Registration is Open !

Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!

This year its in York (Sept 30th till October 2nd).

SQLBits is the largest SQL Server conference held in Europe, and well worth attending !

After the success of last years event in my home country, this year… Read more

0 comments, 622 reads

Posted in DatabaseExpertise.com on 29 July 2010

Log Shipping By Abi Chapagai (Revised)

 Log Shipping  By Abi  Chapagai (Revised)

In SQL Server, transaction log provides an ability to recover a database to a point in time. Log shipping is a process of copying the transaction log back up from a source server to a destination server and restore on the destination server.  The… Read more

2 comments, 1,214 reads

Posted in DatabaseExpertise.com on 29 July 2010

SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai

Introduction 

Replication is the process of copying data between two databases on the same server or different servers on the same database. This is one of the methods to maintain the redundant database site for disaster recovery purpose.  Replication methodology maintains copies of main database from the primary server on… Read more

3 comments, 25,427 reads

Posted in DatabaseExpertise.com on 28 July 2010

Curb those Cursors !

With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority of cases).

The SQL optimiser struggles when dealing with cursor ridden statements, when a FETCH command is executed, its moreorless the same as an extra SELECT command being executed.

Sometimes… Read more

5 comments, 293 reads

Posted in DatabaseExpertise.com on 15 July 2010

“One of the Pack to Top Dog”

My first guest editorial published !

http://www.sqlservercentral.com/articles/Editorial/70725/

Would appreciate any comments you have.

Read more

0 comments, 208 reads

Posted in DatabaseExpertise.com on 15 July 2010

Enabling Memory Support for over 4GB of Physical Memory

This is something we had to do again recently and its improved our performance and query speeds on one particular system. This information is readily available from various sources and blogs, I just wanted to re-blog and ensure we’re all aware of the benefits gained from using AWE !

Enabling… Read more

1 comments, 444 reads

Posted in DatabaseExpertise.com on 12 July 2010

Mix & Match – Day 4

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

0 comments, 143 reads

Posted in DatabaseExpertise.com on 12 July 2010

Mix & Match – Day 3

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

0 comments, 149 reads

Posted in DatabaseExpertise.com on 8 July 2010

Mix & Match – Day 2

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

0 comments, 172 reads

Posted in DatabaseExpertise.com on 6 July 2010

Bin the unwanted to reap the rewards !

Looking through some of my databases this past week, theres a lot of data there which over time has become redundant and rarely (if ever) used.

So I thought why don’t I just bin it ? I got backups, I could even ship it out to an archived version of… Read more

0 comments, 139 reads

Posted in DatabaseExpertise.com on 4 July 2010

Mix & Match – Day 1

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another. 

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

0 comments, 180 reads

Posted in DatabaseExpertise.com on 4 July 2010