It's a pretty low act. I know that when I'm writing I'm scared to death I might string three or four words together in exactly the same way as someone...

Lynn Pettis (1/27/2009)

---

Thank you, this makes me feel really good. I'll try to get the execution plans for and post them here. It may a few days, as...

Uh... Wow... Over-achieve much?

I feel a bit stupid to be commenting on this. I don't have much experience with partitioning beyond reading up on the theory and a few discussions....

The single thread on the user app is because the tool using Profiler for the playback. Profiler isn't smart enough to spawn a different process for each SPID as it...

Marios Philippopoulos (1/27/2009)

---

Restoring the system dbs...

What does that entail? Is it done transparently by the tool or is there anything manual that needs to be done?

When I read about a...

Yeah, I used it at a lab at the Microsoft Technology Center to test the upgrade of one of our databases. I blogged about it here[/url].

Lynn Pettis (1/27/2009)

---

How about the OP's that post their 300 line unformatted SQL code and expect you to figure out what is going on in the code? Yes, there...

Steve Jones - Editor (1/27/2009)

---

Grant, that was a cheap post, course, I probably have a few as well.

Lynn has a good point. Writing coherently, even giving someone a hint on...

We just need another 60 posts to break 1000. Come on people.

That's an estimated execution plan. Can you post the actual execution plan? It's especially important to see the estimated vs. actual rows.

On first blush, you might want to put an...

Yeah, please post the execution plan.

Why would you do this in the GROUP BY clause?

convert(varchar(5),batch.NUM_ORDEM)

I suspect that's going to force a table scan.

Simple isn't nearly as much fun. Small data set, ROW_NUMBER may perform better.

Some operations percentage complete can be obtained through sys.dm_exec_requests. Not everything supplies information to this query, so it really depends on what you're running. But, for example a backup or...

Two possible answers, both will work:

TOP

ROW_NUMBER

DBA just doesn't really have "entry level" positions as such. Most of the people I know that are DBA's came out of a different discipline, usually development or systems. So...