Viewing 15 posts - 18,601 through 18,615 (of 22,214 total)
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...
January 27, 2009 at 12:39 pm
Marios Philippopoulos (1/27/2009)
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...
January 27, 2009 at 11:48 am
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].
January 27, 2009 at 11:29 am
Lynn Pettis (1/27/2009)
January 27, 2009 at 10:02 am
Steve Jones - Editor (1/27/2009)
Lynn has a good point. Writing coherently, even giving someone a hint on...
January 27, 2009 at 9:59 am
We just need another 60 posts to break 1000. Come on people.
January 27, 2009 at 9:22 am
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...
January 27, 2009 at 6:08 am
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.
January 27, 2009 at 5:32 am
Jeff Moden (1/26/2009)
Grant Fritchey (1/26/2009)
Two possible answers, both will work:TOP
ROW_NUMBER
Simple MAX would do it...
Simple isn't nearly as much fun. Small data set, ROW_NUMBER may perform better.
January 26, 2009 at 9:21 pm
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...
January 26, 2009 at 6:45 pm
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...
January 26, 2009 at 10:30 am
Good or bad, as long as stuff isn't plagiarized.
January 26, 2009 at 9:43 am
In my experience, it depends on the number of rows. Opening XML is somewhat expensive inside SQL Server. I've found that if I'm moving fewer than ~100 rows (and yes,...
January 26, 2009 at 7:09 am
Risking a pork chop, I'm going to disagree with Jeff on this.
You should look at option 1, but as was mentioned before, create a schema for the views. Also, I'd...
January 26, 2009 at 7:03 am
Viewing 15 posts - 18,601 through 18,615 (of 22,214 total)