As this is a RANKING problem, any solution will require that the rows be ordered and some alternative are:

1. Code your own ranking but this is not a good...

That is because tables do not have fill factors, only indexes and each index can have a different fill factor.

If you want to rebuild all indexes on a table with...

Jeff, regarding the benchmark method you are using, found a curious situation.

If this SQL is run, statistics time reports duration and cpu of of zero:

set statistics time on

insert into #SalesOrder

SELECT...

The only other example that I have is when one drive of a RAID array goes bad and the hardware operator pulls a good drive instead of the bad drive,...

I've experienced data corruption 5 times so far this year for about 350 SQL Servers. In all cases, the corruption was caused by bad disk drive drivers, SAN drivers...

Occasionally, the SQL Server agent get a error and no jobs will run. Check the Agent log, either by looking at the file SQLAGENT.OUT or using Enterprise Manager...

Google publishes there solution.

"Bigtable: A Distributed Storage System for Structured Data"

http://labs.google.com/papers/bigtable.html

Bigtable is a distributed storage system for managing structured data that is designed to scale to a very large size:...

When a where clause has any function using column values as parameters, a comparison of the returned values to a constant disallows the usage of any indexing unless the table...

As the query optimizer cannot know the value for declared variables, try re-writting into a single SQL statement such as:

Select prodid,prodnum,code

From dbo.vwactivity

Where (Code=1054

and Data1 =...

GSquared:

Thanks for your benchmark but what I hae found is that when you run the benchmark from twice as many clients as there a CPUs on the database server, the...

The original benchmark is not available but was C++, SQL Server 2000 and various other components that were on a physically isolated network without any routers. The schema was...

From your post, the method that you suggested is to let Product table handle the trigger. It means when a row is inserted in to SALEITEM table, the SALEITEM_tUpdate will...

From Jeff Modem:

Yes,...

The recovery mode of a db can be changed at any time but when changing from simple, the new mode does not take real effect until after a full database...

The Knowledge base article on "How to transfer logins and passwords between instances of SQL Server" has been updated and now includes how tos for different versions of SQL Server.

http://support.microsoft.com/kb/246133