SQL In The Wild

On table variable row estimations

• by Gail Shaw

• SQL In The Wild

At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into...

2020-12-23 (first published: 2020-12-15)

275 reads

Pluralsight Free April

• by Gail Shaw

• SQL In The Wild

It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...

2020-04-16 (first published: 2020-04-07)

453 reads

A rant about presentations

• by Gail Shaw

• SQL In The Wild

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,331 reads

Revisiting catch-all queries

• by Gail Shaw

• SQL In The Wild

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,344 reads

Obsessing over query operator costs

• by Gail Shaw

• SQL In The Wild

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,118 reads

Books of 2016

• by Gail Shaw

• SQL In The Wild

I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...

2017-01-03

488 reads

Books of 2016

• by Gail Shaw

• SQL In The Wild

I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...

2017-01-03

151 reads

What is a SARGable predicate?

• by Gail Shaw

• SQL In The Wild

‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...

2016-09-13

1,118 reads

What is a SARGable predicate?

• by Gail Shaw

• SQL In The Wild

‘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

SQL Server 2016 features: R services

• by Gail Shaw

• SQL In The Wild

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

710 reads