I find it interesting you think people want more control over tuning. If we wanted more control wouldn't the standard response to someone adding an index hint to a...

Eric M Russell (6/9/2011)

---

Instead of scheduling things like backups and index maintenace plans by default, we could perhaps have a feature like the old MS Word Clippy that pops up...

Alan Vogan (6/9/2011)

---

It would be nice if when other products (Cognos, Blackberries, etc.) go through set-up that they be required to make some default decisions as to how they will...

This is a fairly straight forward query so it's not getting held up on a joined table which was my first guess. And it's not doing any functions on...

If the way the application connects doesn't support encryption then you'll have problems.

Can you post the table definition and the query that's doing the delete? A copy of the actual execution plan may also be handy.

I think it would be hard to add some of this stuff and do it well. How do you know where to back the data up to? If...

Thanks.

What's the process for that? ...

Good question. It made me think about what log shipping does and how it works.

I'm pretty sure he didn't ride horses down to Florida which is where I...

wware (6/7/2011)

---

cfradenburg (6/7/2011)

---

I see your post regarding 1 batch vs. 3 batches, but I don't see an answer about why SSMS suggests a syntax problem with the "50" by giving...

Funny how dozens...

dmoldovan (6/7/2011)

---

And I have one more question - why do you ask about "the output of this batch"? As far as I can see there are 3 batches, separated by...

shannonjk (6/6/2011)

---

One thing I do notice though, is that it still takes a run of a query for it to (warm up). For instance if I run a query once...