The Scientific Method: a call to action
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
2019-09-09 (first published: 2015-05-25)
513 reads
Gail Shaw
The Number that shouldn't be a number
Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2018-12-13 (first published: 2015-02-02)
464 reads
A rant about presentations
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,326 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
3,208 reads
Obsessing over query operator costs
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.
The...
2018-02-22 (first published: 2018-02-13)
2,115 reads
Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,062 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
481 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
149 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
898 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
158 reads
Blogs
Understanding Azure Geo-Redundant Storage
By John
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...
Prompt in ADS
By Steve Jones
Ever since VS Code and Azure Data Studio came out, people have been asking...
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention...
Forums
Xquery help please (XML into SQL table)
Hi everyone, any help with the below would be appreciated - see sample data...
Restart cumulative totals to 0 at the change of subsets in a sql table.
I have a dataset that I want to track the number of cars, trucks,...
Azure DB newbie trying to locate existing Azure DBs
Hello, I've been tasked with trying to learn more about existing Azure DBs that...
Ask SSC