Viewing 15 posts - 46,321 through 46,335 (of 49,571 total)
Profiler's not usually that heavy on a server, but it is a small load. Perhaps you could use server-side traces instead (Profiler will generate the scripts for you. Stick into...
June 3, 2008 at 12:14 am
Select ... into only creates and populates the table.
If you want indexes, constraints, primary key, triggers or anything else from the original table, you'll have to script them from...
June 3, 2008 at 12:11 am
Please don't cross post. You have an active topic for this question already.
No replies to this thread please. Direct replies to:
June 3, 2008 at 12:09 am
Can you post the execution plan please, along with the table and index definitions? If you've ghanged the view please post the revised code.
June 3, 2008 at 12:06 am
It should be an either-or.
As soon as you enable /3GB, you're restricting the kernal to only 1 GB of memory. That's all it gets to run the core of the...
June 3, 2008 at 12:05 am
Profiler is not available for express.
You can get SQL Developer edition for around $50 which includes all the enterprise features, including profiler, and will install fine on XP.
June 2, 2008 at 8:06 am
avipenina (6/1/2008)
should i enable the...
June 2, 2008 at 7:37 am
Dunno.
Reading over the article it looks like he's mostly taking about the locked pages property than anything else.
See his clarification:
June 2, 2008 at 7:21 am
Wilfred van Dijk (6/2/2008)
If you don't...
June 2, 2008 at 7:00 am
Please don't cross post. It just wastes people's time.
Replies to the following thread please:
June 2, 2008 at 6:44 am
Distinct means that SQL will eliminate duplicate rows from the result set. If you don't have duplicate rows (which in your case you won't because of the group by) you...
June 2, 2008 at 6:38 am
In 2005 you can save the exec plans in xml formal (.sqlplan). you can open a sqlplan file in management studio to see the whole graphical plan.
June 2, 2008 at 5:16 am
Please don't cross post. It just fragments replies and wastes people's time.
No replies to this thread please. Direct replies to:
June 2, 2008 at 5:14 am
Could you post the execution plans please. (in xml format)
Without that, we're guessing at best.
Also helpful would be the table and index definitions.
June 2, 2008 at 5:11 am
Run profiler against the server for a couple hours during your high CPU time. Events to monitor:
- Stored Procedures: RPC completed
- T-SQL:Batch Completed
The default columns should be good enough. Make...
June 2, 2008 at 5:05 am
Viewing 15 posts - 46,321 through 46,335 (of 49,571 total)