If the table itself is less than 8 pages (an extent) by default it will stay in mixed extents. See this BOL Page for how how SQL Server ...

I was assuming it was on a single server. If it requires a linked server I'd go with a solution in SSIS.

If an index is small it can be in mixed extents which means you'll have some fragmentation.

Along with Luis and Ed I can't find anything obvious in your query that would cause there to be different rows to be returned based on the addition of an...

I agree with Gaz.

The only other option might be to restore the database on another server and then shrink the database file.

I know you marked Ed's answer as correct, and I agree it is. I'd just like to add that I consider service packs a code change so any testing...

I'd recommend a database project for each database that includes agent jobs that apply to that database. Then you can have all of this in Source Control as well.

When was the last time statistics were updated? Sounds like a bad plan cached on the secondary.

There isn't anyway that I'm aware of to limit the view in SSMS.

Based on contacts from recruiters I don't see SQL Server slowing down in my area of the world (New England).

I'll agree with others that MS has to be careful to...

You would have to do this in derived column component after the merge join if you were to do it in SSIS. I'd suggest leaving it in SQL Server,...

From a financial standpoint I'd say go with clock speed because SQL Server is licensed per core, so you're going to save like $50,000 by going with 16 vs 24....

So I tried setting up a test environment using the files you attached, but there is a reference to BoxDosageMapping and V in CheckBoxAvailability and your test setup doesn't include...

Thanks all. I didn't mention me because it is much easier to keep the MVP award than to get it the first time.

It is still a great honor to...

To...