SQL Server Interview: Use xp_msver to get more information of Server Version

If you are SQL DBA and if you faced any SQL DBA interview in your career, I am 99% sure that Interviewer had asked this question like “How to get the SQL Server version information.” Most of you guys are thinking a common answer like answer is: "SELECT @@VERSION" Yes, this is a correct answer, […]

March 24, 2017 SQL Server, SQL Server Interview

March 23, 2017

SQL Server: xp_cmdshell and BCP to export table data in a Text File

March 22, 2017 2

SQL Server: MEDIAPASSWORD – password to your Database Backup file

March 21, 2017

SQL Server: Change the default path of Backup directory and Log files

March 20, 2017 1

SQL Server: Various options to Drop a user Database

March 19, 2017 2

SQL Server: SET NOEXEC ON prevent the accidently execution of entire SQL script

March 18, 2017

SQL Server Interview: Difference between Filtered Index and Table Partition

March 17, 2017

SQL Server: Indexed View acquires a Lock on Data

March 16, 2017 2

SQL Server Interview: The Indexed View – Frequently asked questions

March 15, 2017 3

SQL Server: SET STATISTICS IO and SET STATISTICS TIME measure the Query Performance

Older posts Newer posts

About Me!