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…
Gail Shaw
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….
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…
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about…
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about…
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…
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…
SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen…
SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen…
Boundless Opportunities
There has never been more reasons or better opportunities to learn new skills. Gail Shaw shares her favorite online video training resources sites, what’s on her current learning list and why.
Blogs
CISA Accredited Trainer!
By Brian Kelley
My certification came in! I’m now accredited to provide training for the Certified Information...
Correlated Subqueries vs Derived Tables
By Bert Wagner
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...
Video – Creating Azure SQL Database
By Arun Sirpal
A quick 2 minute upload (with sound, my voice) showing you how easy it...
Forums
Troubleshooting with. wait stats (last 2 weeks included)
I’m troubleshooting a slow SQL Server. Our server team is adamant it doesn’t need...
grant user read only whole server
Hello — I should know this… but is there any way to grant a...
Query to Find Mismatches
New user with what should be an easy question. I have two tables; both...
Ask SSC