More On Overlapping Statistics
In my last post I provided a script to identify overlapping statistics but realized afterwards that I left out a...
2010-09-09
899 reads
Blog Posts
PASS SQLRally – Session/Speaker Selection
Hopefully by now you’ve heard about the PASS SQLRally event that will be held in Orlando, May 11-13. Andy Warren,...
2010-09-09
526 reads
Retiree Association Firmly Onboard with My Repetitive Criticism of Quebec’s Deposit and Investment Fund: Mille fois Bravo l’AQRP ! :)
Just a bit of follow up here, to start closing the loop, regarding my multiple written outbursts regarding the institutionalised...
2010-09-09
2,050 reads
SQL Server - Dedicated Administrator Connection (DAC)
This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is...
2010-09-09
8,229 reads
SQLRally Meeting Minutes
The starting point for a good meeting is an agenda and minutes. It took us a bit to catch up,...
2010-09-09
678 reads
The Perfect SQL Server DBA / Developer Role
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve...
2010-09-09
350 reads
T-SQL - Is Saving Space Worth It?
I ran across this blog post on Joe Celko’s Restaurant Seat Assignment Problem that found a way to implement the...
2010-09-09
302 reads
Voting Theory
I was enjoyed the Sunday newspaper (on Sunday!) and ran across this column about various voting systems and that made...
2010-09-09
427 reads
A week far away...24 HOP!
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
639 reads
Common SQL Server Mistakes – GUID as a Clustered PK
I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work...
2010-09-08
1,472 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers