It’s All in the Name, Index Naming Conventions
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,703 reads
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,703 reads
In this post we will pick up where we left off in Part 1, if you haven’t read that please...
2017-12-29 (first published: 2017-12-13)
1,709 reads
One of the hardest things you can do as a blogger is to come up with a post topic. Do...
2017-12-20
335 reads
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....
2017-11-29
1,287 reads
This week is Thanksgiving in the United States, so I thought it fitting to write a quick blog on what...
2017-11-22
405 reads
What is the GO statement and why is it so important to use? When do I have to use it?...
2017-11-15
865 reads
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
739 reads
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
1,768 reads
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
733 reads
Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a...
2017-10-18
441 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