To be able to use all the methods and abilities of 2008, you will need to set the compatibility mode to 2008, not 2000. Performance may or may not...

Paul White NZ (5/19/2010)

---

That sort on SchID is an optimisation for sequential I/O.

Look at the loop join after the sort operator...

If you right click on the plan and "Save As" a .sqplan file, you can post this online so that we can see more information. But, you do have an...

I freely admit I'm not smart enough to always figure out or understand why the optimizer did something. All I can say is what I see. The place where the...

J-F Bergeron (5/18/2010)

---

Are those queries on the same server? If no, then I'm guessing 1 of the server needs to have its statistics updated. You can see 1 of the...

The difference I'm seeing is in where the DISTINCT operation is applied. Of those two plans, the faster plan has a HASH aggregate while the other does a completely useless...

I wouldn't be surprised if you see an operator in the execution plan called Key Lookup. If it's there, you're looking at an instance of a covering index and a...

Pretty much. There may be another way around, but I don't know it.

Mike nailed it pretty well. I can't add much.

But I'll say this. Imagine a piece of TSQL code that, let's say, inserts data into three tables. You can put a...

That's a huge topic. I have a chapter in a book I'm writing for Red Gate waiting for tech edits on this exact topic right now.

There are any number...

Copy the data between the databases using... replication or triggers or whatever. Then you only have to give your users access to the database they're supposed to have.

Because there is no data in the temp table when it gets created, there are no stats. Without stats, you get an estimate of 1. You can update the stats...

First, you have define exactly what you mean by auditing. There are different levels of requirements depending on the laws or regulations or business or technical needs that you're attempting...

You can't view the transaction log file, at all, unless you purchase a third party product specifically made for reading the log.

Why do you need to do this? You should...

ASsuming I understand what you're asking, you want to have a single query that will hit the appropriate schema depending on the user that is making the request? The only...