Tales of a DBA fed up with NOLOCK. Part 1
Nov 12, 2014
Dear Diary,
They asked for help again. Every now and again everything slows down and they see a lot...
2015-02-26 (first published: 2015-02-16)
8,756 reads
Nov 12, 2014
Dear Diary,
They asked for help again. Every now and again everything slows down and they see a lot...
2015-02-26 (first published: 2015-02-16)
8,756 reads
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was...
2015-02-12
912 reads
So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...
2015-02-19 (first published: 2015-02-10)
7,217 reads
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...
2015-02-16 (first published: 2015-02-05)
6,277 reads
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
918 reads
Back in December I had the thought that it would be fun to do an email interview with someone. As...
2015-02-06 (first published: 2015-01-28)
6,812 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,293 reads
Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it...
2015-01-21
1,919 reads
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,389 reads
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL...
2015-01-22 (first published: 2015-01-15)
8,572 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