Gail may have already spotted the problem. If you're just running the SELECT and there's no filter on the data, it's doing a scan of all data across all the...

That is honestly a huge topic. It's not one that you're going to get good guidance on from responses on a blog. As a starting point you could look at...

It's possible that if you're running REINDEX or other defrag routines that the new indexes could be affecting the log size. Other than that, no, I can't think of a...

GilaMonster (6/18/2010)

---

Lynn Pettis (6/17/2010)

---

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or just ignore...

PradeepVallabh (6/16/2010)

---

One more question...I have a query with high number of statement executions but i believe the query is not stored in cache....How do i make sure that query is...

Well, that really depends on a lot of factors. I'll say this, queries...

Gianluca Sartori (6/16/2010)

---

Do we work for the...

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...