You're probably looking at the plan cache. All plans in the plan cache are estimated plans. Every query you execute gets an actual execution plan, they have to. Not all...

Yep, I agree with Gianluca, probably statistics.

It's also possible that you're seeing parameter sniffing. You'd want to look at the execution plan of the query to see what it's doing....

If you need to maintain artificial keys between multiple databases I'd suggest one of two approaches, each of which has strengths & weaknesses. First, set up an ID service that...

I would look at getting a license for SQL Server 2008 R2. You can then use multi-server management to put this to work. Otherwise, you need to cobble something together...

Yes, you can run reports while policies are being evaluated but you won't see a complete picture. Out of the box, no, you can not run policies against anything except...

GilaMonster (6/16/2010)

---

Steve-3_5_7_9 (6/16/2010)

---

Actually, this makes a lot of sense. Sometimes it is difficult to terminate someone, especially if they have great performance reviews, so having a NDA on record...

Steve Jones - Editor (6/15/2010)

---

I'd tend to agree with Jack. The abstracts that catch my eye more are ones that have specific details about what is being covered. Rather than...

This is a case where using a cursor makes sense. I load a cursor and then build my backup statements with dynamic sql. That way you can specify location, file...

Yeah, NDA's are easy. It's Non-Compete's that I worry about.

It's a legal compliance within what should be your standards anyway... sign it. No big deal.

You just have to be careful about language. I had a company that wanted me...

Yes, it's absolutely possible that you're seeing contention. That much contention though would be a bit concerning. What is running on the systems that could block a shared lock for...

With just straight TSQL you'll have to backup the databases serially. That's how most everyone I know does it. That's how I do it. It is possible to backup in...

In general, I'd recommend against using dynamic SQL. That said, there are some very good situations where you should use it because it solves problems like dynamic search or other...

Depending on the situation, I believe that table locks could perform better, whether or not you should use them is a second discussion.

But in general, your beliefs about how SQL...

sudhakara (6/14/2010)

---

Thanks for your reply.

Searched on the book but i could not find any chapter related to the data...