Increasing deadlocks with NoLock
One of my personal pet issues is with inappropriate use of the NOLOCK hint (and read uncommitted) . Don't get me...
2010-04-23
746 reads
Dave Ballantyne
Cross Apply Ambiguity
Cross apply (and outer apply) are a very welcome addition to the TSQL language. However, today after a few hours...
2010-03-26
1,921 reads
Output = MAXDOP 1
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example...
2010-03-04
557 reads
Cleaning up sys.dm_exec_cached_plans
Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...
2010-01-27
1,123 reads
Microsoft – Follow best practices – Part 2
In addition to my previous post, another best practice is to not use NOLOCK and READ UNCOMMITTED transaction isolation level.
Here’s...
2010-01-25
545 reads
Microsoft – Follow best practices!
Best practice is to use parametrized queries to enable plan reuse. Will someone please tell Microsoft this.
Presently dm_exec_cached_plans on...
2010-01-22
1,011 reads
Age calculation with SQL Server
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,129 reads
Phil Factor Speed Phreak SQL Challenge Number 3
The latest Phil Factor challenge is now active here . The prize has now been increased to $100...(read more)
2009-12-04
427 reads
My first useful powershell script – capturing performance counters
After playing around with powershell a bit, I managed to do something quite useful. There are a multitude of ways...
2009-11-30
1,764 reads
Blogs
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers