Fun with Outer Joins
Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.
2014-01-17 (first published: 2012-09-10)
23,274 reads
Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.
2014-01-17 (first published: 2012-09-10)
23,274 reads
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
898 reads
So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an...
2014-01-13 (first published: 2014-01-06)
7,528 reads
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...
2014-01-08
1,403 reads
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...
2014-01-01
633 reads
On the first day after release my developer gave to me
a performance problem on a crucial query
On the second day...
2013-12-24
788 reads
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....
2013-12-23
684 reads
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...
2013-12-19
669 reads
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,523 reads
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....
2013-12-10
853 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers