COMPATIBILITY LEVEL in SQL Server indicates the version of SQL Server with which the database is to be made compatible. Whenever you create a new database, compatibility level is set to that database. Sometimes you may need to change this so that some code will work.
SQL SERVER – Alternative to DBCC INPUTBUFFER – sys.dm_exec_input_buffer
DBCC INPUTBUFFER has been one of the most popular commands to display the last statement sent from a client to an instance of Microsoft SQL Server. We all have been using it for quite a while. However, this DBCC command showed very little information and DBA always wanted to see more details. In SQL Server 2016 we have a new Dynamic Management Function (DMV) sys.dm_exec_input_buffer which provides many additional details as well.
SQL SERVER – How to Rename Extention of MDF File? – A Simple Tutorial
The other day while working with a customer during SQL Server Performance Tuning Practical Workshop, I noticed an MDF file with very strange extensions. When I asked the DBA why they have such a large data file with extension PDF (instead of common MDF file extension), he replied that honestly they have no idea who to rename a data file extension. They had once tried earlier, but that has sent their database into recovery and they had to revert that back immediately.
SQL SERVER – How to Install SQL Server Management Studio (SSMS) From Command Line?
SQL Server Management Studio (SSMS) has been removed from the product release cycle. Now SSMS is shipped as a free tool and doesn’t need to have set up media to install. Earlier I wrote a blog which you can read below.
SQL SERVER – How to Migrate Master Database to New Location?
One of my clients contacted me for On-Demand support with an interesting situation. Their goal was to move ALL databases from C drive to the E drive. They told me that they have done ALTER for all databases (user and system) but it is not working in the master database.
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
SQL Server Management Studio – New Feature – Object Explorer Query Tracking
A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard. In this blog post we will learn about the brand new feature called Object Explorer Query Tracking.Â