Tuning Tip: Identifying Overlapping Statistics
Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When...
2010-09-08
2,039 reads
Blog Posts
At The End of the IO Road With C#
Previously I’ve written about doing fun IO stuff in C#. I found out that some of my old tricks still...
2010-09-07
1,879 reads
Auto Close – SQL Server
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
2,996 reads
Book Review: Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the United States
Another choice brought about by wandering the local library, Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the...
2010-09-07
591 reads
Links From Twitter
Normally, I try to stick to posting technical info or community stuff on the blog, but there were a couple...
2010-09-07
569 reads
More Notes on Live Meeting Presentations
Yesterday I did another presentation via Live Meeting, some thoughts from that effort:
Perf VC team did a great job making...
2010-09-07
431 reads
Please don’t Tweet this, but…
This is reprinted from my editorial in Database Weekly.
During some recent conversations, I’ve noticed an increasing tendency for people to...
2010-09-07
552 reads
Reminder: Introduction to Statistics Presentation Today at Noon
I’ll be doing a presentation titled Introduction to Statistics in SQL Server today (Sep 7, 2010) at noon for the...
2010-09-07
224 reads
Slide Deck for Introduction to Statistics
Here is the slide from the presentation today for the PASS Performance Tuning Virtual Chapter. Thanks to all those that...
2010-09-07
495 reads
Tagxedo
I found this while looking for a quick way to throw some words into a slide, was thinking something along...
2010-09-07
597 reads
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers