Question: How to Find the IP Address of All SQL Server Connection?
I had recently received this question during a recent consultation.
SQL SERVER – Restore Database With Just Log File
Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news. It is not possible.
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 – Total Number of Partitions Created by Partition Function
The next task for us was to find out how many partitions so far has been created by the same partition function. Let us learn about that today.Â
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.