Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
SQL SERVER – What is Spinlock?
After reading both the blog post, I got another question from my client on What is Spinlock? Let us discuss today What is Spinlock.
SQL SERVER – What is Latch?
Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch?
SQL SERVER – Having Two Identity Columns for A Single Table
In yesterday’s session, a DBA asked an interesting question that if it is possible to have two identity columns for a single table. Yes and No.
SQL SERVER – Killing DBCC SHRINKFILE Process – Is it Safe?
Shrinking the data file is a very bad thing and you can read it. Now let us learn about if Killing DBCC SHRINKFILE Process is safe or not?
SQL SERVER – Rows Sampled – sys.dm_db_stats_properties
Here is the question asked in my yesterday’s Comprehensive Database Performance Health Check about rows sampled from sys.dm_db_stats_properties.
SQL SERVER – Statistics Modification Counter – sys.dm_db_stats_properties
Let us learn about it in today’s blog post about the Statistics Modification Counter. The answers to this question is also very simple.