SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...
2011-09-15
13,135 reads
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...
2011-09-15
13,135 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-09-14
580 reads
It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...
2011-09-14
2,304 reads
I wanted to write this because lately I say “I don’t know” a couple times a day to my client/boss....
2011-09-14
622 reads
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,590 reads
With a late cancellation with one of our speakers a hole was opened on our speaker lineup. I reached out...
2011-09-14
422 reads
There's nothing more I love than free food and SQL Server, no joke. I take my free food and SQL...
2011-09-14
522 reads
With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as...
2011-09-14
1,713 reads
SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...
2011-09-14
728 reads
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,628 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers