Satnam Singh, Author at SQLServerGeeks

SQL Server SUSPECT Mode – Recovering a SQL Server 2000 Database

December 17, 2012September 15, 2014 - by Satnam Singh - 10 Comments.

Recently one of our Staging Database Server hosted in the United States of America suddenly got Rebooted after which one of the database named ABC hosted on the server went into …

SQL Server

My Sincere Thanks to www.sqlservergeeks.com

October 31, 2012August 28, 2014 - by Satnam Singh - 2 Comments.

Hi Everybody, I hope you all are doing well. I would like to thank Amit Bansal, Sarabpreet Singh, entire staff at www.sqlservergeeks.com, my fellow SQL Server Professionals who have given their …

SQL Server

SQL Server – Understanding Various Types of Restores in SQL Server – Volume 1

September 20, 2012August 28, 2014 - by Satnam Singh - 5 Comments.

Performing a Database Backup is a part of DBA’s life. Backups are taken to ensure that in case of any emergencies Recovery is possible. When we talk about Recovery it means …

SQL Server

SQL Server: A DBA’s Approach To Setup Transactional Replication – 4 NonStop Days At Office

August 27, 2012August 28, 2014 - by Satnam Singh - 1 Comment

Recently, we need to perform a HotFix promotion on our Production environment. In HotFix promotion, the vendor who has developed the application has done some major enhancements to fix the bugs on the Application as …

SQL Server

SQL Server: Understanding SQL Server Performance Tuning – Why DateAdd is performing too slow.

July 20, 2012August 28, 2014 - by Satnam Singh - 8 Comments.

Writing a proper T-SQL query which doesn’t have any bad impact on the server should be ideally a job of a good developer. But Many a times, the developers don’t focus …

SQL Server

SQL Server: Somebody Has Manually Performed a DML Operation on the Subscriber – What to do next.

July 17, 2012August 28, 2014 - by Satnam Singh - 3 Comments.

In a Replicated environment, it is possible that someone or the other at some point of time by mistake performs a DML operation against the Replicated Database on the subscriber.In a …

SQL Server

SQL Server – Controlling Growth of a Distribution Database

July 7, 2012August 28, 2014 - by Satnam Singh - 2 Comments.

I was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database …

SQL Server

SQL Server Transactional Replication – Deep Dive

July 4, 2012November 29, 2014 - by Satnam Singh - 3 Comments.

As a Database Administrator, we all are normally involved in Setting up SQL Server Transactional Replication on our environment.Apart from setting up Transactional Replication, performing a proper maintainence of the same …

SQL Server

SQL Server: Why is NTEXT so bad to give a PAIN.

July 3, 2012August 28, 2014 - by Satnam Singh - 4 Comments.

Whenever, we talk about Performance Tuning in an SQL Server environment, not necessary always due to bad indexes,statistics or perhaps due to poor query structure the query is behaving badly, in …

SQL Server

Designing a Backup Plan (SQL Server)

June 20, 2012September 16, 2014 - by Satnam Singh - 3 Comments.

Recently, we had a brand new Production server hosted on a Windows 2003 Cluster along with SQL Server 2005 with Service Pack 3. This was an OLTP system hosted in a …