Advent of Code
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice, you call it a “challenge”. This is what the...
2015-12-23
2 reads
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice, you call it a “challenge”. This is what the...
2015-12-23
2 reads
We’ve been using the wrong data types for all the wrong reasons. DBAs, developers, data architects, etc. have all been...
2015-12-21
972 reads
A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...
2015-12-16 (first published: 2015-12-14)
2,481 reads
Data compression is often misunderstood to cost CPU in exchange for smaller size on disk. Somewhat true, but that simple...
2015-12-08
1,114 reads
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,000 reads
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
674 reads
I write on my blog and get a couple comments at best. I talk at conferences and a large part of...
2015-11-06 (first published: 2015-11-02)
640 reads
Extended Events is supposed to be taking over for most of Profiler and server-side tracing functionality, but there were people...
2015-10-26
1,364 reads
There’s a trick to technical interviews. Every question is looking for integrity first, and intelligence and energy second. This is...
2014-05-23 (first published: 2014-05-13)
2,764 reads
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
722 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are...
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...
Hi All, Hi All, I want to convert columns result into rows with comma....