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 – 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.
MongoDB Atlas Pricing
Many have signed up for my course on Foundations of Document Databases with MongoDB. Today we are going to talk about MongoDB Atlas Pricing.
SQL SERVER – Total Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors
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.