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
914 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
434 reads
Connection String Settings: Timeouts and Pooling
If you are having SQL Server Database connection issues, I reckon they could be due to one of two connection...
2010-09-09
26,706 reads
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
530 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,054 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
358 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,242 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
682 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
309 reads
Some Moderately Big Iron on x64
Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM....
2010-09-08
1,006 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers