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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
8 years ago