Collation Conflicts
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,739 reads
The DBA Who Came In From The Cold
Happy New Year 2015
I know it’s late but I’ve been away, I hope you all had a good Christmas and New Year.
I...
2015-01-05
651 reads
Book Review – SQL Server Internals: In-Memory OLTP by Kalen Delaney
The new SQL Server 2014 feature In-Memory OLTP (code-named “Hekaton”) has been attracting a lot of interest since its release,...
2014-12-09
1,798 reads
Video – Identifying large queries using Extended Events
A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...
2014-12-11 (first published: 2014-12-05)
2,368 reads
Blogging for a year!
I’m actually quite proud of the fact that I’ve now been doing this for a year now (and that I’m...
2014-11-07
453 reads
Cardinality Estimation in SQL Server
Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for...
2014-11-04
1,302 reads
Identifying large queries using Extended Events
Following on from my last blog post I now want to run through how to identify large queries using Extended...
2014-10-06 (first published: 2014-10-01)
12,224 reads
Identifying large queries using Server Side Traces
Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).
I know...
2014-09-17 (first published: 2014-09-11)
7,874 reads
The Art of Performance Tuning
Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play....
2014-09-04 (first published: 2014-08-28)
8,790 reads
Website Pulse
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working...
2014-07-31
1,186 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