Amit (7/29/2009)

---

With my comment to "Both work equally fast" i meant with considering the equal table structure as well as data in the table for both the cases i.e....

SARG meaning Search ARGument. It refers to a where clause expression that SQL can use as part of an index seek. There are lots of things that could make an...

What's there to elaborate? SQL runs on Windows Operating system only. It is not possible to install it on any version of *nix.

Elliott's talking about virtualisation,...

Are there any .ndf files for that database? How big's the log file (.ldf)?

Specify the COLLATE clause, either on the select or on the definition of the table.

Without seeing at least the form of the function in question, I can't really be more...

Plus when you shrink you're fragmenting all of your indexes. If you don't rebuild, you're likely to get poor performance. If you do rebuild, the DB's going to grow as...

I bought a office chair from a second-hand office supplier about 8 years ago. Other than the seat getting a little hard (I bought a cushion) and my cats using...

Not update statistics. The counts in sysindexes are not statistics based, they come from the storage engine. You...

It comes from neither statistics nor an actual count. A look at the definition of sp_spaceused shows that the row count is calculated from sys.dm_dm_partition_stats.

It's probably the same as sys.partitions,...

The count in sysindexes can be wrong and should never be considered anything other than an approximate value

Since you're on 2005, try using the row count in sys.partitions. It's also...

*sigh* *twitch*

http://www.sqlservercentral.com/Forums/FindPost761393.aspx

Me too.

If you know it's not the right way to ask, why are you...

No they don't. Count(column) can in some cases be as fast as count(*), it can also be significantly slower.

http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.aspx