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...
2016-09-13
1,748 reads
Blog Posts
World is changing so DBA should
I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...
2016-09-13
387 reads
24 Hours of SQLPASS
Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time,...
2016-09-12
380 reads
Azure Cognitive Services API’s with SQL Server 2016 CLR
[read this post on Mr. Fox SQL blog] Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that have the ability to do some truly amazing...
2016-09-12
33 reads
Never miss a Great Value IT Training Deal Again
As regular readers of the blog will be aware, over the summer of 2016 here at gethynellis.com we have teamed...
2016-09-12
358 reads
Query Performance Insight
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
770 reads
Query Store, Force Plan and “Better” Plans
I am endlessly fascinated by how the Query Store works. I love teaching it at every opportunity too. Plus, almost...
2016-09-12 (first published: 2016-09-06)
1,353 reads
SQL Server Interview Questions And Answers
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
62 reads
SQL Server Interview Questions And Answers
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
254 reads
SQL Server 2016 In-Memory OLTP and After Trigger Support
SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project...
2016-09-12
771 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers