Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some...
2010-02-23
787 reads
SQL RNNR
I’m givin’ ‘er all she’s got!
Or am I?
As I proceed down the path on a consolidation project, I have taken time to pause and ponder...
2010-02-21
663 reads
May I help you?
With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games. Those were the greatest winter...
2010-02-18
823 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,320 reads
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my...
2010-02-16
872 reads
PayPeriod II
I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...
2010-02-14
794 reads
Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
880 reads
Log is Filling Up
Today I ran across Paul Randal’s latest post showing how to find open transactions and such. This is a nice...
2010-02-05
527 reads
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-02
1,701 reads
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
9 reads
Blogs
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...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
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...
The String Distance I
Comments posted to this topic are about the item The String Distance I
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