Troubleshooting and Experience

We had a discussion on some of the performance warnings in VSTF like using LIKE(with %) operator. I was just going through multiple options on how to avoid LIKE clause from the query and improve performance as well. Generally when we use LIKE operator...

The Below script would provide us​ the space used by write only indexes. The usage stats from the indexes is pretty easy to get from ‘ sys.dm_db_index_usage_stats ’ and if you join the DMV ‘ sys.dm_db_partition_stats ’ onto that...

Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or maybe even worse you are doing multiple self joins. This is where you will start smiling. Let's test this functionality, how it is simple and...

Error handling is now easier with the introduction of the THROW command in SQL Server 2011. Legacy method (SQL 2005 onwards) In previous versions, RAISERROR was used to show an error message. RAISERROR requires a proper message number to be shown when...

These features ( http://technet.microsoft.com/en-us/library/ms143729(SQL.110).aspx ) are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

Microsoft SQL Server 2012 Release Candidate 0 (RC 0) introduces 14 new built-in functions. These functions ease the path of migration for information workers by emulating functionality that is found in the expression languages of many desktop applications...

Microsoft SQL Server is a relational database server , developed by Microsoft : It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running...

A very common problem that has plagued both the DBAs and developers for a long time is migrating databases to different SQL Server instances for application development and testing purposes OR for various failover conditions. Databases are not really...

Introduction SQL Server 2008 R2 Parallel Data Warehouse (PDW) is a highly scalable appliance for enterprise data warehousing. The PDW works by using Massively Parallel Processing Software and Appliance hardware to control several physical servers each...

As the tempdb database is the common global resource for all the operations going on in SQL Server, so the DBA has to be bit cautious about the use of it. Because any unexpected operations by the applications running under the SQL Server instance or any...

SQL Server introduced four different ranking functions either to rank records in a result-set or to rank records within groups of records of a result-set. With this inclusion we are no longer required to write several lines of code to get ranking. It...

If you have multiple servers and want to capture the space availability to plan for future, then this tool can be used collect those information. This tool will only run in Windows OS and a SQL server installed in one of the machine to store the...

Problem: Having a SQL Agent Job, which executes a Stored prcedure to connect to a remote SQL server via linked server and extract/manupulate the data. The SP runs successfully in SSMS but get failed, if run through an agent Job. NOTE: A Windows...

Careful with Replication type "Updatable Subscriptions for Transactional Replication" when your application does not use column names in INSERT and SELECT statements and has database triggers NOTE:This feature will be removed in a future version of...