See Joe Celko's article "Happier marriages through math"

at http://www.dbmsmag.com/9808d06.html

This is also known as the bin packing problem.

PS.

"A Relational Model of Data Large Shared Data Banks" can be found at: http://www.cs.wisc.edu/~nil/764/root/1_codd70.pdf

This...

Look in Books OnLine for function fn_trace_gettable

Example usage:

SELECT *

INTO temp_trc

FROM ::fn_trace_gettable('c:\my_trace.trc', default)

The first restriction is "WHERE User.UserID = 49"

But "User" is a reserved word and the table name is "userS"

Rename the table and then create a view named as old table name. Be sure to include the "with VIEW_METADATA" option so that the application cannot see the underlying...

1. Start a database backup.

2. While the backup is running, if you are replacing a database on the target server, generate a script from the target server with...

Just for future reference is resolving network timeouts, keep us posted on whether just the NIC need to be set or if the switchs and routers also need to be...

Glad to help and thanks for the links.

Wikipedia has another category titled "Operations for domain computations" which includes Aggregation and Extend, so I guess those should be excluded.

Codd also suggested...

"generates a timeout and stops"

Is the hardware HP NICs and Cisco Routers ?

There seems to be a problem with this hardware combination communicating the appropiate speed and duplex when under...

The solution may be to use an AFTER trigger and join to the underlying table.

Although a trigger cannot reference a LOB in the inserted tables, a trigger can reference a...

Here is my list of the eight relational operators.

What is the difference between this list and yours ?

1. Project - Subset of attributes

2. Extend - Add a attribute

3. Restrict...

By containment do you mean division ?

The classic example of division is "What pilots can fly all planes in the hanger?"

There is also a "even" division: "What pilots can fly...

This is a known problem since December 1, 2003 and there is no fix, just workarounds.

PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work Because of Sparsely Populated Text, Ntext,...

For return codes that are generated by SQL server, a zero means success and anything else means a failure. At one time, there was some meaning to the value of...

"These Selects on the TradeDaily and Starmine_Gbl_Daily Tables are also slow

SELECT DISTINCT td FROM pemaster.dbo.tradedaily --(50 Million Records)

SELECT DISTINCT as_of_date FROM pemaster.dbo.starmine_gbl_daily --(44 Million Records)

"

What does "slow" mean ?

Please post...

As you have discovered, using elapsed time as a comparison criteria is un-relialable. This can be due to network workload, other SQL running on the server, virus scanning,...