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,626 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
795 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
691 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
676 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,528 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,520 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,112 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
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Bank BCA KCU BCA KCU Jayapura telp 0817 844 112
WhatsApp CS,0817844112 Komp. Pertokoan Jayapura, Jl. Pacific Permai Jl. Dr. Sam Ratulangi No.31 Blok...
Bank BCA KCU Tanjung Pandan telp 0817 844 112
WhatsApp CS,0817844112 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten Belitung,...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers