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
745 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,917 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
544 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,010 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,763 reads
Blogs
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
A Note and a Message: T-SQL Tuesday #193
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
Forums
What is the PRODUCT
Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers