Finding top 10 large tables in each database in an instance of SQL server
It is a good practice to find and monitor your large SQL server tables, we may surprise in some cases where our
Tag: SQL Server
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
What “Open Table “in SQL Server 2005 replaced with in SQL Server 2008? How to change this Edit top 200 to edit all?
Today, a customer asked me how to open a table in SQL Server 2008 to edit the rows in
