In reply to Jeff Moden's question: Under the "union all" solution, there are no "parameter", just SQL Statements that are sent to the server in the normal manner as a...

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...