SQL In The Wild

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,323 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,182 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,109 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

475 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

148 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

886 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

708 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

214 reads

Upcoming conferences

• by Gail Shaw

• SQL In The Wild

It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...

2016-04-26

856 reads