This is a very minor quibble, but presenting procs and functions like these in the correct case, ie. sp_MSforeachdb instead of sp_msforeachdb, will help maintain the sanity of those poor...

Linked servers can do horrible, horrible things for performance beyond simple network latency (statistics issues, forced RBAR). But sometimes you're stuck with them, so you have to deal...

Anyway, the...

Interesting stuff. I did some playing around and on my heap table (which just has 1 record, and four columns) it has a rowmodctr of 137. It didn't...

I agree, the primary factor here (given the limited information we have) is AGs in synchronous. If you don't require automatic failover or zero potential data loss I would...

It's a bit manual but if you are talking about the rightclick on db, Tasks, Generate Scripts option, you can go through that and select everything in the schema, in...

You'll always get 0 rows returned with that...seems like you are implying an OR or IN operator. The column...

Jacek Falkiewicz (10/20/2014)

The point is, what produce more page swaps: reorganize or rebuild?

According to Microsoft "Reorganizing...

I'm not sure what problem you would have doing that. The setting is an instance, not database level setting...when you restore the database backup that came from a "mixed...

How realtime do the reports have to be? Offloading the reporting to another (Standard Ed.) server, with automated nightly restores, or perhaps log-shipping with readable secondaries, might be a...

You might also consider trying it with compat level 120, but running the query with OPTION (QUERYTRACEON 9481) which forces it (even in 120 level) to use the old CE....

Thanks for the idea! I tried 1MB and...

FYI, backups failing again today with full stack dump any time one is invoked, by native tools or LiteSpeed.

We're already enmeshed in a never-ending ticket with MS Premier...

I'm running into this as well, will be trying CU3 just in case, but I don't see anything listed on the pages for CU1/2/3 that seem to match. Strange,...

Out of curiosity I peered at the guts of that system sp, you might be able to do something like this to make it simpler:

select u.name as LinkedServer, t.name as...

Depending on your specific requirements...I would start with sp_helplinkedsrvlogin, maybe if you need to filter for something, push it into a temp table and then select out only the stuff...