Age calculation with SQL Server
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,131 reads
Blog Posts
Are trivial plans cached?
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,239 reads
ASK SQLServerCentral
We've had the ASK SQLServerCentral site up for a couple months now and while I see traffic continuing over there,...
2009-12-08
593 reads
Database Books
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
450 reads
December Patches
I note these for Database Weekly, but I haven’t blogged about them. A mistake on my part.
The December patches from...
2009-12-08
500 reads
Fundamentals of Storage Systems – RAID and Hard Disk Reliability, Under the Covers
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,523 reads
Handling Inconvenient Requests
"You can have everything in life that you want if you will just help enough other people get what they...
2009-12-08
739 reads
Locking & Blocking
On the gridiron, two opposing teams are contending for one very limited resource, the football. One team has it; the...
2009-12-08
521 reads
Microsoft Certified Master: SQL Server 2008 Pre-reading List
Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are...
2009-12-08
1,076 reads
PASS Editorial for December 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-12-08
251 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers