Troubleshooting and Experience

LIKE vs PATINDEX

We had a discussion on some of the performance warnings in VSTF like using LIKE(with %) operator. I...

Author: Deepak Biswal Date: 07/25/2012

How much space are you wasting?

The Below script would provide us​ the space used by write only indexes. The usage stats from the...

Author: Deepak Biswal Date: 06/29/2012

LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3

Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row,...

Author: Deepak Biswal Date: 06/29/2012

THROW in Error Handling - Denali

​Error handling is now easier with the introduction of the THROW command in SQL Server 2011. Legacy...

Author: Deepak Biswal Date: 06/29/2012

Deprecated Database Engine Features in SQL Server 2012

​These features (https://technet.microsoft.com/en-us/library/ms143729(SQL.110).aspx) are scheduled to...

Author: Deepak Biswal Date: 06/29/2012

14 New Functions and 1 Changed Function in Denali

Microsoft SQL Server 2012 Release Candidate 0 (RC 0) introduces 14 new built-in functions. These...

Author: Deepak Biswal Date: 06/29/2012

Dude! What is Microsoft SQL Server ?

Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software...

Author: Deepak Biswal Date: 06/29/2012

SQL Server 2012 – New Features – Contained Databases

A very common problem that has plagued both the DBAs and developers for a long time is migrating...

Author: Deepak Biswal Date: 06/29/2012

Monitoring tempdb Transactions and Space usage

As the tempdb database is the common global resource for all the operations going on in SQL Server,...

Author: Deepak Biswal Date: 04/13/2010

Ranking Functions in SQL Server

SQL Server introduced four different ranking functions either to rank records in a result-set or to...

Author: Deepak Biswal Date: 03/24/2010

Storage Reporting Tool

If you have multiple servers and want to capture the space availability to plan for future, then...

Author: Deepak Biswal Date: 03/02/2010

Job Fails on Linked Server - Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)

Problem: Having a SQL Agent Job, which executes a Stored prcedure to connect to a remote SQL server...

Author: Deepak Biswal Date: 03/02/2010

Issues with Updatable Subscriptions for Transactional Replication

Careful with Replication type "Updatable Subscriptions for Transactional Replication" when your...

Author: Deepak Biswal Date: 03/02/2010