Microsoft SQL Server Tips & Tricks

Tips and Tricks for the SQL Server Enthusiast

NORECOMPUTE : Can lead to SQL server performance degradation!!

ANALYSIS:- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat...

Author: Harsh Chawla Date: 01/10/2012

Procedure Cache-Part II

Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing...

Author: Harsh Chawla Date: 12/12/2011

Procedure cache - Part I

Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing...

Author: Harsh Chawla Date: 12/12/2011

Troubleshooting Kerberos Delegation Using DelegConfig

Gain an expertise in solving the "Kerberos Delegation" issues using one of the useful...

Author: Harsh Chawla Date: 12/12/2011

What's execution log in Reporting services?

Check out our video blog to gain in depth knowledge about importance of "Execution Log" in reporting...

Author: Harsh Chawla Date: 12/07/2011

Transparent Data Encryption (TDE)

Leverage our video blog to empower your knowledge on TDE. Highlights of this video blog :- 1....

Author: Harsh Chawla Date: 11/17/2011

Demystifying SQL server memory concepts video

Leverage our video blog to empower your knowledge on "SQL Memory".This video will help you to gain...

Author: Harsh Chawla Date: 11/16/2011

SQL server service pack installation may fail if your instance name is a Windows reserved word

Okay, so I woke up one morning and decided that this was a good day to patch my SQL Server 2008 R2...

Author: Harsh Chawla Date: 11/02/2011

Multiserver administration

In this video presentation you will learn in depth about Multiserver administration For better...

Author: Harsh Chawla Date: 10/31/2011

SQL Server could not create a subscription for Subscriber 'ServernameInstanceName'.The value for the @sync_method parameter is not valid

Recently we worked on a support case where creation of a Subscription was failing with the following...

Author: Balmukund Date: 10/13/2011

DDL Triggers

Hello Everyone, In this presentation, you will learn about what are DDL triggers and how they could...

Author: Harsh Chawla Date: 10/10/2011

The mystery of incorrect filegroup size

Recently, there was a question that why the SQL Server DMVs were reflecting incorrect information...

Author: Harsh Chawla Date: 09/26/2011

Creating stoplist on database of compatibility 80/90 in SQL server 2008

Introduction: In this blog we will see how to add a stopword in a stoplist and also look at one of...

Author: Harsh Chawla Date: 08/31/2011

Another reason of Index logical fragmentation!

Problem Description: Indexes gets fragmented soon after rebuilding index Detailed description You...

Author: Harsh Chawla Date: 08/30/2011

Implementing SSL encryption for SQL Server in a DNS forwarding environment

Let’s say you have an environment which implements DNS forwarding. In such a setup, the client uses...

Author: Harsh Chawla Date: 08/08/2011

SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers

Recently, I worked on a case with one of my clients wherein SQL Server was encountering several...

Author: Harsh Chawla Date: 08/08/2011

Moving data from the mdf file to the ndf file(s)

SCENARIO: 1)You have an MDF file from a database which has grown up to a size that has almost...

Author: Harsh Chawla Date: 08/02/2011

How to Convert UTC Time to Local Time in SQL

There currently isn’t a way in T-SQL to convert UTC Time to Local time; however this seems to...

Author: Harsh Chawla Date: 07/29/2011

What's Performance Dashboard and how it can help in troublehsooting SQL issues.

In this presentation you learn about: 1. How to install performance dashboard 2. How to use...

Author: Harsh Chawla Date: 07/07/2011

What are SQL server audits - a new feature in SQL server 2008

In this presentation, you will learn about the complete description of the SQL audits , their...

Author: Harsh Chawla Date: 07/06/2011

What are plan guides and how it could help in managing performance of the queries

In this presentation, you will learn about what are the plan guides and how they could help the DBAs...

Author: Harsh Chawla Date: 06/17/2011

Managing SQL resources using resource governer

In this presentation, you will learn about how you could manage SQL resources using resource...

Author: Harsh Chawla Date: 06/16/2011

Whats the backup compression in SQL server 2008 and how it can help to optimize the speed/size of the backup

In this video we will see whats the backup compression in SQL server 2008 and how it can help to...

Author: Harsh Chawla Date: 06/15/2011

Problems may occur when you try to install SQL Server 2008 R2 Shared Features if the %TEMP% folder is Encrypted.

Symptoms: You might see a couple of components from the “shared features” failing with the error...

Author: Balmukund Date: 06/06/2011

What are Virtual log files - VLF in SQL server - video

 In this presentation you will learn : 1. Very basics of transaction logs internal structure i.e....

Author: Harsh Chawla Date: 06/01/2011

Implicit conversions and their implications on the SQL query execution

In this presentation , you will learn about what are implicit conversions. What can be their...

Author: Harsh Chawla Date: 06/01/2011

INF : Restore Database UI fails with error: "Length cannot be less than zero. Parameter name: length"

Recently we came across a situation where one of the customer was trying to restore a Database...

Author: Balmukund Date: 05/31/2011

INF : How does Logical Record Feature Works in Merge Replication

By default, merge replication processes data changes on a row-by-row basis. In many circumstances...

Author: Balmukund Date: 05/31/2011

INF: SQL Server Extended Stored Procedures & behaviour change starting with Windows 2008

Many of you SQL folks out there have extended stored procedures installed and being used in your SQL...

Author: Balmukund Date: 05/24/2011

INF: Hey, my SQL Server Service is not starting – what do I do?

This is one of those challenging situations when customers call us at times. I can understand the...

Author: Balmukund Date: 05/11/2011

Errors Raised with Severity/Level 16 May Cause Transactions into Doomed State

Consider a scenario wherein you are doing some operation which is generating an error with...

Author: Balmukund Date: 05/11/2011

Presentation Material for Webcast on Performance Dashboard

On 4th May 2011 (Day 3), Amit Banerjee presented webcast on “Understanding Performance Bottlenecks...

Author: Balmukund Date: 05/10/2011

On 3rd May 2011 (Day 2), Sudarshan presented webcast on “Optimizing and Tuning Full Text Search for...

Author: Balmukund Date: 05/04/2011

Presentation Material for Webcast on SQL Server Resource Governor

On 2nd May 2011 (Day 1), I presented webcast on “Managing and Optimizing Resources for SQL Server”....

Author: Balmukund Date: 05/04/2011

Service broker concepts and troubleshooting

In this presentation you will learn about what's service broker and it's basic troubleshooting...

Author: Harsh Chawla Date: 05/03/2011

How to configure and monitor log shipping in sql server

In this presentation, you will learn about how to configure and monitor logshipping. Presented by:...

Author: Harsh Chawla Date: 05/03/2011

SQLDIAG: There are no instances of version 10 on this computer

But really SQLDIAG I do, and I am not lying!! I have helped multiple users of SQLDIAG (not SQL...

Author: Balmukund Date: 04/05/2011

INF: How to retrieve data from a large XML string

We encountered an interesting issue some time back. We already had XML data inserted into a SQL...

Author: Balmukund Date: 03/18/2011

SQL server 2008:Declarative Management Framework-DMF

In this presentation you will learn about working of Declarative Management Framework with demo....

Author: Harsh Chawla Date: 02/25/2011

SQL server 2008: Change Data Capture

In this video we are going to present a brief demo of how CDC works and it's functionality....

Author: Harsh Chawla Date: 02/25/2011

SQL server 2008: Extended events

In this video, you will learn about how to extended events are configured and how they work:...

Author: Harsh Chawla Date: 02/25/2011

SQL server 2008 clustering using Hyper-V-Video

In this video you will learn about how to configure SQL 2008 Cluster using hyper-v on windows 2008....

Author: Harsh Chawla Date: 02/25/2011

PRB: SQL Backups to a UNC path fail with OS Error 1 (Incorrect Function)

Symptoms When you try to take a SQL Server database backup to a UNC path (\server\folder), you get...

Author: Balmukund Date: 02/17/2011

SQL Nexus and RML Utilities: A primer on the issues that I have dealt with last year

I have answered multiple queries last year regarding the tools SQL Nexus and RML Utilities via MSDN...

Author: Balmukund Date: 02/07/2011

Unable to read trace definition file Microsoft SQL Server TraceDefinition n.n1.n2.xml

Symptoms When you open SQL Server profiler, and try to start a new  trace (or when try to open...

Author: Nikesh Mhatre Date: 01/14/2011

Case Study: Troubleshooting a Slow Log Shipping Restore job

Scenario Consider a scenario where you have a Log shipping setup with a STANDY secondary database...

Author: Balmukund Date: 01/07/2011

Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths

It's has been couple of years for me working on SQL Server and I keep coming across various SQL...

Author: Balmukund Date: 01/07/2011

Microsoft SQL Server 2005 Service Pack 4 Released!

The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download,...

Author: Balmukund Date: 12/17/2010

SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide

As you might be aware that SQL Server Code-Named “Denali” has introduced a new feature called Always...

Author: Balmukund Date: 12/17/2010

<Previous Next>