I think all you can do is set your recovery model to bulk logged and try to proactively prevent fragmentation.

(Those operations are eligible for minimal logging.)

Sorry

This is very similar, if not identical to a sql challenge posted a while back. check out the discussion related to it, I think you'll find some good tips:

a) Hire an intern or use rentacoder to retype it.

b) copy the content into textpad, and write a regular expression find and replace to put create before table, etc.

c) use...

I think what you're looking for is:

;WITH recGroups AS (

SELECT DeviceEsn,

Location,

recTime,

MIN(RecTime) OVER (PARTITION BY DeviceEsn) as minRecTime,

MAX(RecTime) OVER (PARTITION BY DeviceEsn) as maxRecTime

FROM #IdTable

WHERE IdNumber = 1

)

SELECT mn.deviceEsn,

mn.location AS enterLocation,

mx.location...

IN IE, the default behavior is to hide the true error. You'll get better information if you go to "internet options" in the tools menu, click on the advanced...

I agree with GSquared. Actually, this is a case where I would make very sure that the actual business requirement is the same as what you have on paper....

I think more clarification is required...

Are you looking for help writing code to generate your triggers or are you looking for how to write the triggers themselves?

If it's the triggers,...

One point: Celko's noticed that your grouping set is almost assured to be distinct, so the max(id) for each set should be the max for the table. This seems...

The SQLCat team has published a top 10 list of best practices for building-a-large-scale-relational-data-warehouse in which they recommend against checking foreign keys on large fact tables. (recommendation 4, last point)

They...

Pete,

No, by approximate, it is not meant that no finite numbers are representable, for example 1, .9, .1, and .005 are representable just fine. It is just an acknowledgment...

you have to love when the system is designed in such a way that you can guess the correct answer without knowing anything just by which name makes sense... ...

Noone can answer this question as-is.

check out http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Probably have more luck in the administration forum.

Unfortunately in SSRS 2005 this is not an option. You can set the formatting of many of the elements, but you cannot format parts of a single element differently.

If...

You can also use the same data source for both the default and available values.