They're cheating.

They're actual questions taken from the exams in violation of the NDA which all exam takers accept. Using them or distributing them can result in your certifications being revoked...

Using something like sp_MS_foreachDB or a custom written cursor to loop over all databases, inserting into a temp table. Then select from a temp table at the end.

Bharatvip (7/15/2015)

---

1. Will bumping mem to 64 or 128 GB help? We know that we don't have many selects or stored procs doing a lot of joins and selects, for...

Using something like sp_MS_foreachDB or a custom written cursor to loop over all databases. sys.partitions and sys.objects are specific to the current DB.

Don't use Task Manager to look at SQL's memory. It often lies.

In this case though it's probably right. 1GB for the buffer pool and 600MB for the non-buffer portion (thread...

Put it in the database. Putting it in your app won't help when other apps, spreadsheets, MS Access, etc are connected to the DB, when the app is changed or...

That counter has has no value at all.

You can have a server under severe memory pressure with that counter still sitting 99%. Ignore it, use other, more useful, counters.

Yes, with a trigger, however running long processes from a trigger is a really bad idea. Probably better to put the report code in a SQL job and in the...

Hehehe. That's the kind of thing that, when I'm optimising procedures, I tend to take out.

No. SQL is a database engine, not a language processor

Are there any tools outside SQL that can be used for...

Yes. It's not related to your question, but it's...

Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....

If you don't know what you want, there's not much chance we're...

Could you be a little clearer as to what you want? If 32k entries all have the same datetime stamp and same load_id, how do you determine the 'first' row?

Or...

In addition, since this is a simplification of the actual problem, it's possible (though impossible to tell for sure) that a temp table isn't necessary at all. Are you able...