SQL Server

SQL Server Alwayson Interview Questions & Answers

I have published SQL Server Interview Questions and Answers on many topics. Visit attached link to get All SQL Server…

Overview on SQL Server Performance Tuning

SQL Server Performance Tuning is an important subject and it is essential to implement various measures at regular intervals of…

How to Fix SQL Server Installation Error 1639?

Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with…

How to Add a New Database to Always On Availability Group?

Adding or Removing databases from availability group is not day to day task but we need to perform such activities…

Should We Clear Wait Statistics Data from DMV sys.dm_os_wait_stats in SQL Server?

Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends…

Difference between UNION and UNION ALL T-SQL Operators

If you want to combine output from multiple tables or queries into one result set, you can do this using…

What is Instant File Initialization and How to enable it on SQL Server Instance?

Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a…