Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
12,391 reads
Blog Posts
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-23
1,322 reads
Plagiarism Again
Update: The problem posts have been removed from the SQLTechConsulting site.
I ran across a note from Brent Ozar (blog | Twitter)...
2010-03-23
1,793 reads
SQL Saturday #39 New York
New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...
2010-03-23
553 reads
Virtual Presentation : Index Statistics
I just gave a virtual presentation, courtesy of Pass and the appdev group. The recorded presentation is available here:
Recorded Presentation
A...
2010-03-23
629 reads
Access Analysis Services via T-SQL?
It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database...
2010-03-22
860 reads
Be Responsible in your blogging and posting
I have been awarded the MVP award from Microsoft a few years in a row and it’s an honor, but...
2010-03-22
670 reads
Don't Throw Something New In At Production Deployment
This post comes from a conversation I had with a developer last week as well as my experiences over the...
2010-03-22
1,806 reads
Free Events – It’s All About Expectations
Isn’t free enough? If you go to a free event do you have a right to complain? Or, if you...
2010-03-22
976 reads
More Thoughts on Certification
After a great response to my last post on Certification, I need to post my thoughts on 70-450 PRO: Designing,...
2010-03-22
577 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