Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
468 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
100 reads
On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,411 reads
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
147 reads
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
502 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)
4,125 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,007 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,715 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,465 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)
5,397 reads
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers