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)
440 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,321 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,171 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,104 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,931 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
473 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
876 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
706 reads
If you want to run SSIS packages in Azure Data Factory, you need the...
Recently there was a thread on Twitter which established that a lot of IT...
When you run a query twice, and get dramatically different run times, your first...
Comments posted to this topic are about the item Statistics Profile Results
we have created Data warehouse server and planning to create Databases, Schema and users....
I have a stored procedure that is called multiple times to get all the...
Ask SSC