One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.
List All Sessions – SQL in Sixty Seconds #148
One of the most frequent questions which I receive from my client is about activity going inside SQL Server and how to list all sessions.
SQL SERVER – Attach an In-Memory Database with T-SQL
My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.
SQL SERVER – Attach a Database with T-SQL
One of my clients reached out to me asking for help in attaching the database files to the server. Let us see today we can attach a database with T-SQL.
SQL SERVER – Inserting sp_who2 Into a Table
I should also have included the script for method 1 discussed in the blog post. Let us learn a method of inserting sp_who2 into a table.
SQL SERVER – Representing sp_who2 with DMVs
During the recent Performance Check, I had a very interesting situation where my client wanted to capture the details of the sp_who2 in a table with DMVs.
Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.