Using Indexing To Solve Blocking and Deadlocking Issues
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...
2019-03-20 (first published: 2019-03-05)
3,045 reads
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...
2019-03-20 (first published: 2019-03-05)
3,045 reads
This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:
Dipping into the Cookie Jar...
2019-03-12
288 reads
This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...
2019-03-12
239 reads
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
245 reads
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
398 reads
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
135 reads
It’s 4am in the morning and my phone starts ringing.
A blury eyed, me picks it up to hear the voice...
2019-02-07
352 reads
We’re pleased to announce the release of the Undercover Catalogue 0.2 and can be downloaded from https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue
The new version brings...
2019-02-04
125 reads
During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...
2019-01-22 (first published: 2019-01-14)
2,065 reads
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
180 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers