What is Parameter Sniffing in simple words?
I have been asked recently what is parameter sniffing in an interview. Well, we all know how Optimizer in SQL
Category: ARTICLES
How to transfer logins and passwords between instances of SQL Server?
There are many ways to transfer logins between instances under the same domain like 1. Scripting out logins 2. Logins
How to delete multiple logins from SQL Server (Sp_DropLogins )
I have been asked several times to delete multiple logins in a day in my environment then initially I was
Script to find the fragmentation level of specific table and its indexes in SQL Server
This script is very useful when you have large tables and queries against those table usually runs slow then you
Track DML Changes Using after Trigger for Update, Delete and Insert rows- Capture Changed data rows using T-sql
Track DML Changes Using after Trigger for Update, Delete and Insert rows There is out lot many options to track
Compare Two Tables Using T-SQL or Command Line Utility (tablediff.exe)
There is out too many ways to compare two tables in SQL server but I prefer to do this task
ColumnStore Indexes in SQL Server 2011, Code Named “Denali”
This new type of Index is introduced with new upcoming 2011 version of SQL Server. This new index improves the
New Features in SQL Server 2011 or Code Named “DENALI” CTP1
Microsoft SQL Server Code-Named “Denali”, this release increases the power and productivity of architects, developers, and administrators who design, develop,
Database Comparision- Schema Compare, Data Compare,synchronization and validation
Have you ever given a task to do validate two databases on different servers or on the same server? Usually
Activity monitor, Script to find Head blocker- SQL Server 2005, 2008 and later
This is very handy useful script in production environment. Even the activity monitor does the same but when there is
