I have published SQL Server Interview Questions and Answers on many topics. Visit attached link to get All SQL Server Interview Question and Answers published on this website on different topics. Here, I am going to publish SQL Server Alwayson...
SQL Server Performance Tuning is an important subject and it is essential to implement various measures at regular intervals of time to optimize the scalability and performance of the Server. There are multiple areas which we analyze to understand a...
Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with the error 1639. I have given below the details of this error code. Product: Microsoft SQL Server Browser – Update...
Adding or Removing databases from availability group is not day to day task but we need to perform such activities whenever it required. You can read attached article to learn how to remove database from availability group. Here, I will...
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 on case to case. Ideally, you should not clear your wait statistics data frequently. Best way is Do Not clear wait...
If you want to combine output from multiple tables or queries into one result set, you can do this using an operator known as UNION. A UNION is used to extract rows based on some conditions specified whereas UNION ALL...
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a SQL Server database. Have you ever thought how SQL Server initialized its database files during space allocation? General way to...
