One of the most popular questions I received during my SQL Server Performance Tuning Practical Workshop is how users can run sets of procedure when their SQL Server starts automatically. Today, let us see a simple tutorial to run stored procedure at server startup.
SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives
Looking at the way SQL has evolved, there are changes coming up in SQL Server 2017 which would help it run on Windows and Linux platforms. Let us learn about dm_os_enumerate_fixed_drives.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
Question: How to Create Temp Table From Stored Procedure?
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns
Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored procedure sp_special_columns customers today.
SQL SERVER – System Procedure to List Out Table From Linked Server
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?
How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135
Question: How to Show Results of sp_spaceused in a Single Result?
Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the syntax. Remembering basic syntax should be a good idea, but it should not be the sole requirement of the hiring a good candidate. I believe I am a good DBA but trust me personally I do not remember all the syntax.
SQL SERVER – How to See Scripts Executing in sp_executesql?
Question: How to See Scripts Executing in sp_executesql?