An Alternative to SELECT COUNT(*) for Better Performance
Sometimes rapid code development doesn't always produce the most efficient code. Take the age old line of code SELECT COUNT(*)...
2013-05-07
5,273 reads
Sometimes rapid code development doesn't always produce the most efficient code. Take the age old line of code SELECT COUNT(*)...
2013-05-07
5,273 reads
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,265 reads
Database mirroring has been around since SQL Server 2005, and it's turned out to be an excellent step up from...
2013-03-26
2,442 reads
T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup...
2013-03-15 (first published: 2013-03-12)
2,886 reads
Just for the record, this happens to be one of my favorite interview questions to ask candidates.
At some point in...
2013-03-05
2,318 reads
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,440 reads
Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. Basically it shows you...
2013-02-14 (first published: 2013-02-05)
5,446 reads
T-SQL Tuesday - This month's party is hosted by Wayne Sheffield (blog|twitter), and the topic is about Powershell and how to use...
2013-02-12
8,110 reads
I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but...
2013-02-04 (first published: 2013-01-29)
8,349 reads
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,300 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...