Use Compression to Combine Data Quality and Performance
We’ve been using the wrong data types for all the wrong reasons. DBAs, developers, data architects, etc. have all been...
2015-12-21
974 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
974 reads
What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...
2015-12-28 (first published: 2015-12-16)
3,510 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,119 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,002 reads
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
675 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,377 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
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
Comments posted to this topic are about the item What happens when we drop...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers