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?
Here is the question asked in my yesterday’s Comprehensive Database Performance Health Check about rows sampled from sys.dm_db_stats_properties.
Today we will be discussing how to list Total Data Pages In Memory Buffer Pool with the help of sys.dm_os_buffer_descriptors.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.
I have already blogged about validating positive integer numbers in this post (SQL SERVER – UDF – Validate Natural Integer Function).
In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.