and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
146 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Does an index scan always read the entire index?
No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...
2016-01-26
488 reads
Natively compiled user-defined functions
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation,...
2016-01-19 (first published: 2016-01-12)
3,909 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,002 reads
Book Review 2015
It’s been a few years since I wrote a review of books I’ve read, so this isn’t going to list...
2016-01-15 (first published: 2016-01-05)
1,712 reads
When naming transactions causes an error
For the last part of the series on transactions, I’m going to look at a problem that I ran across...
2015-12-21 (first published: 2015-12-15)
2,336 reads
Why would you want to name a transaction?
Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...
2015-12-04 (first published: 2015-12-01)
4,620 reads
Savepoints and conditional transactions
This is the second in a short series on transactions. In the previous part I discussed nested transactions and showed...
2015-11-20 (first published: 2015-11-17)
3,042 reads
A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
638 reads
Of clustered indexes and ordering
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,811 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...