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,267 reads
Kenneth Fisher
sp_SrvPermissions & sp_DBPermissions V4.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
897 reads
Transactions: Rolling back a transaction inside a stored procedure.
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,474 reads
Transactions: What are they?
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,400 reads
Happy new year!
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
632 reads
The 12 days after release
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
787 reads
SSMS Shortcuts and more
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....
2013-12-23
682 reads
Transactions: Rolling back part of a transaction.
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...
2013-12-19
666 reads
Transactions: Rolling back a nested transaction
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,521 reads
T-SQL Tuesday #49: Wait for it
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
851 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers