There is a system procedure named sp_tables which is used to list out the tables available in the CURRENT database of the CURRENT server. But did you know that there exists another system stored procedure that can be used to list out the tables of database available in the linked server?
SQL SERVER – How to Get Updated Link for Code and Database Samples?
Some emails, indeed triggers blog posts such as the one I received the other day about database samples.Â
SQL SERVER – Different Methods to Know COMPATIBILITY LEVEL of a Database
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.
What does Keyword STATS Indicates in Backup Scripts in SQL Server? – Interview Question of the Week #138
Question:Â What does Keyword STATS Indicates in Backup Scripts in SQL Server?
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 – Error: 8509 – Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION)
Have you ever seen an issue related to MS DTC, SQL Server and JDBC XA distributed transactions? A client contacted me for help and he wanted my opinion within one hour. They signed up for my On Demand consulting services and we started looking at the server and application.
SQL SERVER – Wait Stats Collection Scripts for 2016 and Later Versions
Yesterday I posted a blog about a new DMV, which is introduced in SQL Server 2016. You can read the blog post here:Â Get Wait Stats Related to Specific Session ID With sys.dm_exec_session_wait_stats. After reading the blog post, I have received quite a few emails about SQL Server Wait Stats Collection Scripts. One of the question was is my earlier script still valid to collect the SQL Wait Stats for SQL Server 2016 and Later Versions.