Troubleshooting and Experience
LIKE vs PATINDEX
We had a discussion on some of the performance warnings in VSTF like using LIKE(with %) operator. I...
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...
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,...
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...
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...
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...
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...
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...
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,...
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...
Date: 03/24/2010
Storage Reporting Tool
If you have multiple servers and want to capture the space availability to plan for future, then...
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...
Date: 03/02/2010
Issues with Updatable Subscriptions for Transactional Replication
Careful with Replication type "Updatable Subscriptions for Transactional Replication" when your...
Date: 03/02/2010