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)
446 reads
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,323 reads
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,183 reads
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,109 reads
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)
15,975 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
475 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
148 reads
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
888 reads
‘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
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
708 reads
Introduction I recently got a call from our DBA telling me that the CPU...
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Comments posted to this topic are about the item Growing and Changing
Comments posted to this topic are about the item Azure Stretch Database, Part I:...
Comments posted to this topic are about the item Minimalistic SELECT
Ask SSC