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,

  READ ARTICLE
1201 words ()
by Dean Savović | 10:25 am

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.

  READ ARTICLE
156 words ()
by Dean Savović | 8:28 am

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.

  READ ARTICLE
85 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

  READ ARTICLE
88 words ()
by Dean Savović | 8:20 am

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?

  READ ARTICLE
143 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

  READ ARTICLE
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

  READ ARTICLE
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

  READ ARTICLE
60 words ()
by Dean Savović | 8:31 am

My New Website

New Website I have “finished” a new website for my friend using WordPress. Site is still roh-bau but you can check it out on www.kontakt-europa.hr. Site is about friend’s electro like business. Business supports

  READ ARTICLE
127 words ()
by Dean Savović | 8:49 pm

Hello World!

Welcome! This is my first blog post. More to come soon.

  READ ARTICLE
11 words ()