THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Sign in
|
Join
|
Help
in
Andrew Kelly
(Entire Site)
Search
Home
Blogs
Forums
Roller
Downloads
Opml
Andrew Kelly
Browse by Tags
All Tags
»
Documentation
»
Delevoper
(RSS)
Tips & Tricks
Exists Vs. Count(*) - The battle never ends...
I am still amazed at how many of the database applications written today still disregard some basic rules of thumb when it comes to accessing the data. One in particular is the use of COUNT(*) to check to see if there are any rows that
Read More...
Posted
Saturday, December 15, 2007 9:27 PM
by
Andrew Kelly
|
14 Comments
Filed under:
Documentation
,
Delevoper
,
Tips & Tricks
This Blog
Home
Links
Syndication
RSS 2.0
Atom 1.0
Recent Posts
New England SQL Users Group & Craig Freedman
OT - Where is the gas cap?
When a Function is indeed a Constant
When GETDATE() is not a constant
Getting back to the basics with I/O
Tags
Backup
Best Paractices
Bugs
DBA
DBCC
Delevoper
Documentation
I/O
Maintenance
Performance
Storage
Tips & Tricks
Trace Flag
Trivia
TSQL
User Groups
Archives
May 2008 (1)
April 2008 (1)
March 2008 (1)
February 2008 (1)
January 2008 (1)
December 2007 (2)
October 2007 (1)
September 2007 (3)
August 2007 (1)
July 2007 (1)
March 2007 (1)
November 2006 (2)
July 2006 (1)
©2006-2008 SQLblog.com
TM
Brought to you by
Peter DeBetta
& Adam Machanic
Privacy Statement