Debugging query timeouts by sampling blocking – part 2
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...
2012-03-20 (first published: 2012-03-15)
2,885 reads
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...
2012-03-20 (first published: 2012-03-15)
2,885 reads
I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No,...
2012-03-10
2,104 reads
With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around...
2012-03-05
7,990 reads
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...
2012-02-29 (first published: 2012-02-21)
9,023 reads
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at...
2012-02-14
1,009 reads
The main focus of this blog is to write about SQL Server related stuff – but now and then in the...
2012-02-07
789 reads
Over the next few weeks / months there will be plenty of opportunities to meet the Geniiius family, since we started...
2012-01-31
1,571 reads
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,318 reads
In this weeks blog post we will have a look at how easy it is to combine FileTables and FullText...
2012-01-18 (first published: 2012-01-12)
2,915 reads
I have been working with SQL Server for quite a few years now, and it still happens quite often that...
2012-01-17
6,177 reads
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Comments posted to this topic are about the item 50 Years of Microsoft
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers