Installation and configuration

Rakesh Patil

SQL Server installation and upgrade troubleshooting interview questions

September 21, 2018 by

1. Can a Service Pack or Cumulative Update be uninstalled to roll back in case of failures?

We cannot uninstall a service pack or Cumulative Update on SQL Server 2005 or lower.

Starting with SQL Server 2008, we can uninstall a service pack or Cumulative Update from control panel Add or remove programs a view installed updates window.

Read more »
Marko Zivkovic

OpenQueryStore for SQL Server – Installation and configuration

January 24, 2018 by

The OpenQueryStore is an Open source implementation of the popular Query store functionality introduced in SQL Server 2016 CTP2. The OpenQueryStore was first introduced in June 2017. Its main contributors are William Durkin and Enrico van de Laar

The OpenQueryStore collects query runtime execution statistics, wait statistics information against a specific database. This information helps identifying performance problems and troubleshooting by quickly finding performance differences.

The main difference between the OpenQueryStore and the Query store feature is that the OpenQueryStore supports SQL Server 2005 to SQL Server 2014 while Query Store supports only SQL Server 2016 and higher. Also, the OpenQueryStore is open-source which means that the OpenQueryStore code can be changed whenever you like.

Read more »