T-SQL Tuesday #51: Doubledown disaster
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,570 reads
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,570 reads
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...
2014-02-13 (first published: 2014-02-05)
4,546 reads
A little while back I was doing some research into a failed job and ran into a slight problem. The...
2014-02-10
882 reads
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,161 reads
This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...
2014-02-02
1,350 reads
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...
2014-01-29
887 reads
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...
2014-01-23 (first published: 2014-01-20)
3,281 reads
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...
2014-01-22
1,073 reads
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary key?...
2014-01-20 (first published: 2014-01-13)
4,457 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,027 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers