Often when conducting trainings I ask my participants not to take my word for it but try things out for themselves. I was asked a question about the […]
Stress testing disk subsystems – SQLIOSIM
A client of ours recently bought a brand new set of disks and wanted to know best practices around tempdb optimizations during the discussion we were trying to […]
IS IT POSSIBLE? Bulk operations in Full recovery model
Here is the reason I am writing this post As per the above entry from MSDN, there cannot be any minimally logged operations in full recovery mode, which […]
Uninstalling SQL Server
I just realized today that I had the CTP for sql 2014 still installed on my laptop today. While trying to uninstall it from control panel (time period […]
Clustered Index vs Unique Non Clustered Index, which is better performance while still maintaining integrity of the data?
At a training recently we were talking about improving ETL performance for a process that loads about 3 million rows. While the answer is typically to load the […]
Video on how to use Schema Compare Option available in SSDT
In this video we cover how to use the Schema compare option within MS SQL Server Data Tools the Visual Studio IDE that comes as the replacement for […]
Performance Tuning CPU issues in MS SQL Server – Indexes
In this video we cover how the correct use of Indexes can help elimintae CPU bottlenecks , we cover how to identify CPU issues and a few different […]
Which is better Delayed Durability or Optimistic Concurrency
A brand new video covering the performance impact of delayed Durability vs Optimistic Concurrency. Which is better? While both have different behavior and purpose; when it comes down […]
Using MS SQL Server to work with assemblies (CLR)
A brand new video uploaded on YouTube on how to use CLR assemblies in MS SQL Server. Please share and like and we look forward to comments. https://www.youtube.com/watch?v=5sOlIIC-UXg […]
Which is better Count (*) or Count (id)?
While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so […]