Monthly Archives: July 2015

ETL 2 million rows – Comparison of BULK INSERT, BCP, OLEDB, ADO NET, OPEN ROWSET, SQL Server Destination task

By | July 21, 2015

A quick video comparing the performance of different ETL options when importing 2 million rows into a database. All tasks use the BULK Logged Options where possible. ETl method performance Have you seen this link on the ETL world record using SSIS? https://msdn.microsoft.com/en-us/library/dd537533.aspx Summary Method Time Bulk Insert 28 sec DFT OLEDB – 500 1:13… Read More »

Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy

By | July 19, 2015

I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only real social media I follow is LinkedIn and that’s because it is mostly a Professional network. But more importantly, the reason why I don’t have a massive… Read More »

You can now create nonclustered indexes on the Clustered Columnstore index

By | July 16, 2015

This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that Clustered Columnstore index doesn’t allow other indexes to be create on the table. This is true and false. Let me explain. If your using SSMS to create… Read More »

SQL 2016- Live Query Stats

By | July 16, 2015

I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 there is a feature called Live Query Stats being introduced. As its name suggests it provides details on the actual tasks being executed in real time. What… Read More »

SQL 2016- Activity monitor – Active Expensive Queries

By | July 13, 2015

Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. However I would still hope that everybody is familiar with using sys.dm_exec_requests Plenty of new option popping up all over Management Studio get exploring.

SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered

By | July 13, 2015

So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the Non clustered Columnstore index was introduced but was severely handicapped by the fact that once implemented the table was read only. In SQL 2014 the Clustered Columnstore… Read More »

Fill Factor and Page split demonstrated

By | July 13, 2015

Recently on one of the popular SQL Forums I read a post by a DBA who seemed experienced but still had a poor understanding of fill factor and why it is important for SQL server. I’ve been asked this questions a number of times during trainings so here is a video hoping to show some… Read More »