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,263 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
896 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,463 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,399 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
631 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
786 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
681 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
664 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,520 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
850 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
FinOps - the new name for performance tuning
Comments posted to this topic are about the item FinOps - the new name...
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers