by Dean Savović | 2:01 pm

Parameter Sniffing on SQL Server

Parameter sniffing is a great feature of SQL Server that helps execute queries with less CPU and memory consumption, but sometimes can go bad on us. Meaning our queries can take longer execution times,

1201 words ()
by Dean Savović | 1:41 pm

SQL Saturday, Banja Luka, Bosnia and Herzegovina

SQL Saturday, 09.09.2017, Banja Luka I will be presenting two sessions at SQL Saturday in Banja Luka, Bosnia and Herzegovina. First session is Query Store and Query Optimization and second session is Cardinality Estimator

88 words ()
by Dean Savović | 12:21 am

SQL Server Management Studio 17.0

SQL Server Management Studio 17.0 is out. Download it and check it out. It officially supports SQL Server 2008 – 2017 (Linux version included). Here are the most important improvements: Over 100 connect issues

142 words ()
by Dean Savović | 5:41 pm

SQL Server 2017

SQL Server 2017 Previously called SQL Server vNext is now called SQL Server 2017! Anticipated release is Mid-2017. Some of the new features include: Resumable online index rebuild Graph database capabilities to model many-to-many

49 words ()
by Dean Savović | 11:03 am

Cardinality Estimator

Here is a good reference to look at when having problems with cardinality estimation. You can also see differences between SQL Server 2012 and 2014 and usage scenarios of various trace flags. Also, finally

60 words ()