Fragmentation has nothing to do with whether you get a seek or a scan. A seek requires that you have a where clause, something to search on. If you are...

No, freeproccache is not a substitute for updating statistics, but the stats needed updating when you actually upgraded the database to SQL 2012, i.e. when it was first attached to...

Ed Wagner (3/24/2014)

WOW! Now that's enough to scare anyone. Just think...he has access to the server....

And he sent me a PM asking if I'd assist with getting the system back up and running....

If you've lost the data drive and you have no usable backups, you're pretty...

Please post table definitions, index definitions and execution plan.

It's not something that has 'small' examples. Spend some time reading up on resource governor (Books Online has a fair bit, there's a whitepaper iirc as well), test out in...

You're mixing up ANDs and ORs without having any brackets to specify the precedence of the operators. Unless otherwise specified (by brackets) AND takes precedence over OR

Without brackets, this is...

Because sp_recompile does not cause a recompile (when run against a procedure). It removes the plan entirely from cache so that it has to be compiled from scratch on the...

It'll reset if the plan is removed from cache and compiled again from scratch,...

Just bear in mind that OPTION(RECOMPILE) has other effects as well. It allows 'parameter sniffing' on variables, it can result in a row estimate for table variables which is not...

Not directly.

You can configure Resource Governor and create pools and resource groups and set limits, but it's far from perfect.

Please post table definitions, index definitions and execution plans as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Go to the page on the Microsoft Learning site for the exam, check the skills measured. That's the official list of what they can test you on in that test.

What exactly is the issue?