Last week a good friend of mine (Parth Shah) asked me a very interesting question that he wants to capture TRUNCATE and DELETE statements being fired on a database with very minimal overhead on the system. When performance is the Continue Reading..
Microsoft Excel is a very powerful tool, using excel we can connect to all most all known data sources available and create a report easily. In this post, we will learn how to connect to a SQL Server database from Continue Reading..
What is the difference between temp table and global temp table and table variable and CTE in SQL Server ? It is a very commonly asked interview question and you must know the differences between them to use the appropriate method while writing SQL Continue Reading..
The real power of XML in SQL Server lies in its so-called xquery FLWOR expressions. I personally love to play with XML in SQL Server because it’s so powerful and easy to integrate. FLWOR is the acronym for for, let, where, order Continue Reading..
For a developer it is very important to get familiar and proficient in the error handling part; no matter in which language you code, better error handling always gives flexibility to your code. You should always consider implementing error handling methods Continue Reading..
SQLIO is not a part of SQL Server package despite its name, it is a tool provided by Microsoft which can be used to determine the I/O capacity or benchmark a given disk subsystem. Benefit of SQLIO is that, it Continue Reading..
As a DBA, we spend a lot of time investigating and maintaining the database performance parameters like new index creation, index rebuild on basis of fragmentation level, statistics update etc. but what about a HEAP table, how will we handle the fragmentation Continue Reading..
We know sp_execute , sp_executesql and exec are three different approaches to execute dynamic T-SQL queries or statements. Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime. It gives more flexibility when you don’t know the parameters Continue Reading..
OPTIMIZE FOR is a query hint introduced in SQL Server 2005 version and supported in all editions of SQL Server. This query hint can be applied to all DML operations like SELECT, INSERT, UPDATE, DELETE AND MERGE. The OPTIMIZE FOR Continue Reading..
Change tracking was introduced in SQL Server 2008 and is similar to Change data capture but differences are, it works in synchronous process, does not require SQL agent to be running, it’s lighter than CDC. Prerequisites: You must first enable Continue Reading..