Clustered Indexes Have Statistics Too
It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index...
2012-10-22
1,172 reads
Blog Posts
Create Several Shell SSIS Packages In Minutes Using BIML
What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...
2012-10-22 (first published: 2012-10-16)
4,682 reads
Data Flow Optimization - Collapse Sparse Buffers
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT a "try this for all data flow performance...
2012-10-22
84 reads
Data Flow Optimization - Collapse Sparse Buffers
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT...
2012-10-22
1,443 reads
DBA Work Accounting
One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s...
2012-10-22
1,854 reads
Don’t Be That PASS Summit Guy
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,211 reads
Last Weeks Top 10 “Reading” Links #3
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-22
707 reads
Preparing for Certification
One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...
2012-10-22
1,362 reads
Red Gate log shipping
Log shipping is great.
It's basically the act of beginning a restore with no recovery, and then restoring logs (with no...
2012-10-22
2,173 reads
Stockholm in 2013
Come and join me live in Stockholm Sweden early in 2012 where I will be presenting Learning Tree’s2109 SQL Server...
2012-10-22
515 reads
Blogs
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
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...
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