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,
KulenDayz is as one of a kind conference! Their style is different; this is a community conference and they are trying to keep talks out of standard conference rooms and speakers out of suits and skirts.
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
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
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
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