A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,099 reads
How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
315 reads
Missing European PASS (Updated)
As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US...
2010-04-19
464 reads
Missing European PASS
As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US...
2010-04-19
873 reads
SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)
Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this...
2010-04-19
1,091 reads
Powershell Script for Verifying Space
First let me say, I know my Powershell skills are sub-par. I’m working on it. Slowly but surely. That said,...
2010-04-19
1,214 reads
SQLSaturday #39 in NYC - Countdown - Event Preview!
Happy Monday, everyone! The internet is a buzz! I have never seen so much energy and enthusiasm as SQLSaturdays, and...
2010-04-19
1,049 reads
Reminder – SQLSaturday #38 in Jacksonville on May 8th, 2010
I hear that registration is over 350 so far, with seats still available – but register soon! I’m driving up with...
2010-04-19
511 reads
Just one mirror
You can only have one mirror of a SQL Server database in SQL Server 2005/2008. I researched that last year...
2010-04-19
648 reads
Pride of Idea Ownership
I’ve had this on my list to write about for a while, just didn’t have a great example until this...
2010-04-19
505 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers