Count(*) or Count(1) ?
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,461 reads
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,461 reads
Do I follow my own advice?
I’ve been asked that at a few of my Modern Resume presentations if I do...
2010-07-27
1,481 reads
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,104 reads
Ran across Pillbox in Government Computing News (GCN), a web app that lets you identify what a pill is based...
2010-07-27
618 reads
One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of...
2010-07-27
1,567 reads
I'M ON A BOAT!
This is just a quick note to say that I’ll be in South Florida this weekend presenting...
2010-07-27
413 reads
I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge....
2010-07-27
672 reads
I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida. I really wanted to go...
2010-07-27
328 reads
I just found out today that I will be one of the speakers at SQL Saturday #51 in Nashville, Tennessee...
2010-07-27
858 reads
While I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not...
2010-07-27
1,053 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...
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
Comments posted to this topic are about the item What happens when we drop...
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