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,589 reads
SQLStudies
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
634 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
788 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
684 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
670 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,523 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
856 reads
Undocumented functionality in FORMATMESSAGE
I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is...
2013-12-09
1,496 reads
Insert into a table using only default values
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value...
2013-12-04
1,092 reads
Why do DBAs like to say “It Depends” so much?
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice...
2013-12-02
649 reads
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers