Be Pithy
I'm tech editing a book, working late as usual, football game on and kids in bed. As I was going...
2007-10-22
1,391 reads
Blog Posts
Requiring Columns Over 900 Bytes to Be Unique
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,450 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,835 reads
SQLSaturday Update - 215 Registered!
We're at 215 registered with 3 weeks to the big day! This week I'll be having the last planning meeting...
2007-10-21
1,459 reads
ZFS & Hard Drive Defects
The most recent ACM Queue Magazine (Vol 5 #6, Sep/Oct 2007) had two really interesting articles. The first was about...
2007-10-21
1,501 reads
Suggestions for PASS Published on SSC
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,349 reads
Suggested Reading: Deadlock Notifications in SQL Server 2005
Here's a good article on setting up Deadlock Notifications in SQL Server 2005 written by Patrick LeBlanc.
2007-10-16
1,483 reads
The Troubleshooting List & Replication Statement Delivery Options
All of these are new articles that have gone up on SSC recently. The troubleshooting one was my attempt to...
2007-10-14
628 reads
Bill Graziano Visits oPASS & JSSUG
Bill Graziano (main man at SQLTeam.com, consultant, and VP of PASS) was in town recently to speak at both the...
2007-10-13
683 reads
Schema as Folder
I'm catching up on my reading today and ran across an article from Kathi Kellenberger called Understanding the Difference between...
2007-10-13
604 reads
Blogs
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...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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