Currys having apostrophe trouble
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
615 reads
Art
Pluralsight = Essential Training
Update: 11th Sep 2016 - See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight...
2014-03-25
1,347 reads
FIGlet SQLCLR ASCII Font Art
If you haven’t heard of the name before, you must have seen what it does at some point. FIGlet which...
2014-02-13
1,739 reads
Basic RegEx in SSMS
Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...
2014-02-04 (first published: 2014-01-27)
6,042 reads
And that is 2013
I’ve been blogging for a couple of years now and although I’ve never been a prolific blogger (and never will!),...
2013-12-23
571 reads
Getting the read/write ratio for a database
EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below...
2013-11-30
4,791 reads
Removing HTML formatting tag - BR - from XML using XQuery
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,954 reads
What to do next certification wise
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
708 reads
Just Wow!! features
Over the years with each release I’m often impressed by some of the features contained in SQL server but every...
2013-08-30
1,326 reads
Crash when inserting to a FileTable with a parallel plan
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the...
2013-07-25
1,363 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers