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

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…

SQL 2016- Live Query Stats

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…

SQL 2016- Activity monitor – Active Expensive Queries

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.

Fill Factor and Page split demonstrated

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…

OStress.exe – use it if you aren’t already

I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. Most time developers and testers use a test harness for automating this kind of activity or use a load testing tool. I however am not a tester…