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,
READ ARTICLE
Reading CSV file within Select Statement
I didn’t know this so I want to share with the public. I had a requirement that required me to read from CSV file and update the database table with data from the file.
Presenting at KulenDayz, Osijek, Croatia
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, 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
Query Store and Linked Server
On my Query Store presentation on Windays 2017 conference I had a interesting question I decided to write a blog about. The question was where is the query stored when query uses linked server?
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
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
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
