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,124 reads
Dave Ballantynes blog
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
546 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,130 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
428 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,765 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
Memes and Humor: Lightening Up Open Source AI News
This delightful corner of our community celebrates the lighter, funnier side of artificial intelligence,...
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers