GSquared (10/27/2011)

Ninja's_RGR'us (10/26/2011)

How come?? Never bothered to learn...

I am cutting you all the slack there is.

50 000 foot review.

1 - Play with it to learn

2 - Pay someone to learn or do it for you.

To start the...

This is just my guess here as I don't know those internals.

Assuming that the file's definition don't change, I wouldn't expect the server to overwrite anything. I mean soemthing...

george sibbald (10/26/2011)

if you restore the backup to somewhere with contiguous space, the data file will be contiguous.

So the fragmentation of the file after restore depends on the free space...

2 options

#1 Pre aggregate your data in a derived table and left join the main query to that.

#2 (My current favorite) is to use an outer apply.

In my environement the...

To me DTA is more dangerous than anything else. You must REALLY understand tuning to use it without danger. And once you're that good you just don't need...

99% fragmentation is meaningless on 25 pages.

Run the same query with 1000 pages minimum and see what transpires.

This is what I use to auto-fix fragmentation.

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

Here's how I tuned the fill...

Might be easier to do full backup weekly and the log backup after each load.

For the same 50 GB 1 give you 5 days while the other one possibly gives...

In house app or 3rd party?

Case will short-circuit. So with the current code should be faster.

However if you were to write

if

else if

else if...

It should be equal.

I see.

I've worked with mixed environements in the past and I can say it was a pita.

I wouldn't recommend it just because it feels funny, however fully retesting your systems...

True more than funny ;-).

Which one?

Well that's pretty much the conclusion they had (in case you didn't read that one) => http://www.sqlskills.com/BLOGS/PAUL/post/Page-Life-Expectancy-isnt-what-you-think.aspx

As Gail said then, good idea to change that error message. And then bill the vendor for your time ;-).