"However, would you ever use such a construct in the WHERE clause of a query?"

I would hope not, as this would preclude the use of an index.

For the WHERE, bettter...

Seems a little bizare to me because if for a row in table1, there are 10 rows in Table2 where th join criteria is true, then there will be 10 identical...

create a view from the SQL statement and then execute the view

"Then you can go make a nice big bowl of popcorn, and watch all 3 extended DVD's of The Lord Of The Rings while the 650,000 rows churn "

I ran a quick benchmark and included Sergiy's solution to this problem.

Sergiy.......... CAST( CAST( ( MyTs - 0.5 ) as integer ) as smalldatetime )

PW............... convert(smalldatetime, floor(convert (float,...

FYI, see the article "The Curse and Blessings of Dynamic SQL" by Erland Sommarskog, SQL Server MVP at

http://www.sommarskog.se/dynamic_sql.html

To workaround the the size limitation, one approach is to use views....

Could there be more triggers than your three ?

select T.name as TableName

, TR.name as TriggerName

from sysobjects as T

join sysobjects as TR

on T.id = TR.parent_obj

where TR.type ='TR'

and T.type = 'U'

and T.name...

This may be related to "PRB: A Timeout Occurs When a Database Is Automatically Expanding" at http://www.support.microsoft.com/kb/305635/EN-US/

The workaround is to size of the database data file and transaction log appropriately...

This is a problem in logical database design. In a logical design, surrogate keys (identity) should not be used as they are a physical implimentation.

Business rules:

1. There is a...

Instead of writing your own maps/geography database and application, there are some other alternatives:

1. There are APIs available to the major mapping service including Goggle, MapQuest and Yahoo.

2. ...

When you run the package on machine3, even though the source of the package is on machine7, the package runs on machine3.

Try loging on to machine7 with the...

Please post the SQL statement that you are actually running as the SQL you posted runs with no errors.

Here is guess at the tables

Create table DelReimb

(ClaimIDint not null

,EventIdint not null

)

Create...

If this is an On Line Transaction Processing System (OLTP), then setting the configuration parameter of "max degree of parallelism" to 1 to disable parallelism is not unreasonable.

For a SQL...

The SQL Server documentation, Books OnLine, has an entire section on this topic named "Creating and Using Data Warehouses Overview"

Here is the first page:

Organizations collect data in the normal course...

Triggers become easy to write once the concept is understood. Please open SQL ServerBooks Online and for the index tab, enter "inserted tables". Here is the first paragraph:

"Two...