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
–DB Blog
I have been asked recently what is parameter sniffing in an interview. Well, we all know how Optimizer in SQL
There are many ways to transfer logins between instances under the same domain like 1. Scripting out logins 2. Logins
I have been asked several times to delete multiple logins in a day in my environment then initially I was
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 There is out lot many options to track
There is out too many ways to compare two tables in SQL server but I prefer to do this task
This new type of Index is introduced with new upcoming 2011 version of SQL Server. This new index improves the
Microsoft SQL Server Code-Named “Denali”, this release increases the power and productivity of architects, developers, and administrators who design, develop,
Have you ever given a task to do validate two databases on different servers or on the same server? Usually
This is very handy useful script in production environment. Even the activity monitor does the same but when there is
You must be logged in to post a comment.