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)
524 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)
468 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,327 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,231 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,116 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,094 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
482 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
920 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
AWS RDS SQL Server Announcements - 2020
1. Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts...
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This...
I Presented with Live Captioning and Sign Language Interpreters
I had the pleasure of presenting a full-day pre-conference session on the Friday before...
Forums
https://www.thenutracafe.com/vi/testoherb/
Nh?ng nhóm tình yêu Nam tang cu?ng r?t nhi?u mà h? s? d?t d?u...
New user wants to create test DB, which menu option?
I'm new to SQL Server and using V18.4. I want to create a new...
tempdb shrinking
Hi, Need some quick help here. I am unable to shrink tempdb files. There...
Ask SSC