Viewing 15 posts - 42,241 through 42,255 (of 49,563 total)
Yup, though you're probably better off using perfmon than task manager for anything other than a casual check.
And before you ask, there's no 'normal' value. It's completely dependant on your...
December 19, 2008 at 9:24 am
m3n@ce (12/19/2008)
Do I need to do a tail end backup of the transaction log before I do the restore?
Since you're not planning to restore the logs (why?) no need. Just...
December 19, 2008 at 9:18 am
sudarram (12/19/2008)
A single SPID has 1714526 Cpu.Was this a normal one?
Who knows? That's just saying how much CPU time that spid has used since it started. Without knowing what it's...
December 19, 2008 at 9:12 am
ibnzakariyyahh (12/19/2008)
i think my boss just want to punish me for this kind of assignment.
I wish I got this kind of punishment. This is dead simple and very quick.
You haven't...
December 19, 2008 at 9:11 am
sudarram (12/19/2008)
HiI'm new to SQLSERVER.What should be the Normal CPU Utilization of SQLSERVER?
Depends what the server's doing. That's kinda like asking "How long is a piece of...
December 19, 2008 at 9:08 am
Matt Miller (12/19/2008)
I'm the new kid on the block at my job this year, so I get to "keep the lights on"...
Bummer. Hope nothing breaks.
This is the first...
December 19, 2008 at 8:50 am
I'm not going to ask too much. I'd love a machine with a user interface somewhere between the one in Minority Report and the one in Quantum of Solace.
December 19, 2008 at 8:38 am
Robert Frasca (12/19/2008)
I found heap, clustered, non-clustered, and XML as the only valid "types".
Heap, no. It doesn't have the b-tree structure, it's not an index.
Don't forget spatial indexes on...
December 19, 2008 at 8:32 am
Grant Fritchey (12/19/2008)
I want to try this on my own, but I'm a bit busy. Has anyone tried querying sys.dm_exec_query_plan?
Plans are there. Fairly easy to identify too, the objectid in...
December 19, 2008 at 8:28 am
Domagoj Orec (12/19/2008)
I wonder what happens with 50+ year olds in IT, how they cope with learning new things?
My colleague's around that age and he runs rings around me...
December 19, 2008 at 8:20 am
A hardcoded password is a bad idea, for this reason and others.
You can put the password in the app.config file (encrypted) and have it different on dev and prod. Preferably...
December 19, 2008 at 8:18 am
Please don't repost a question that people are working on. It just leads to redundant replies and means people will waste their time answering questions that have already been answered.
Please...
December 19, 2008 at 8:16 am
Your original question asked how to copy a database.
Do you need to copy an entire database or a single table within a database?
If the latter, is there a linked...
December 19, 2008 at 7:59 am
Peso (12/19/2008)
Not even with SQL Profiler?You can get every statement within the function there.
True, though that's a hellishly painful way to get execution plans.
I need to check and see if...
December 19, 2008 at 7:35 am
ddorfman (12/19/2008)
ThanksHow to i get the actual execution plan of running just a TVF
You don't. 🙁
Take the contents of the function, put in management studio, declare variables in place...
December 19, 2008 at 7:14 am
Viewing 15 posts - 42,241 through 42,255 (of 49,563 total)