How Stale Are My Statistics?
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
2010-11-05
11,876 reads
A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,039 reads
Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
880 reads
An Invitation To Come To My PASS Summit Session On Blogging And Speaking
On Wednesday morning at 10:15 AM during the 2010 PASS Summit next week I'm presenting "Getting Started In Blogging And...
2010-11-04
717 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
598 reads
Ascending Mount BI Stack: Basecamp
Not quite Mount Doom but...
As some of you may know, I’ve recently transitioned over from the fabulous life of being...
2010-11-04
611 reads
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,164 reads
What’s in a Full Backup?
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it...
2010-11-04
690 reads
SQLServerPedia Award Nomination
I thought this week was going to be pretty low key. SQL Saturday 58 has wrapped up. The PASS Summit...
2010-11-04
985 reads
Slides and Example Code for SQL Lunch #42 - Auditing Database Permission in SQL Server
As promised, here are the slides and sample code from my SQL Lunch presentation today. Thanks for all who came...
2010-11-04
690 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers