Viewing 15 posts - 42,241 through 42,255 (of 49,571 total)
Osmar Fernandez (12/19/2008)
Still, If I can Access the Store Procedure from Another App (ex: Access) I can push incorrect data or modify data with no integrity.
Which is also the case...
December 20, 2008 at 12:42 am
kathyoshea (12/19/2008)
Is there something in 2005 that won't see the order by?
Order by is only valid in the outermost select statement, ie the one calling the function. If it's any...
December 20, 2008 at 12:38 am
weitzera (12/19/2008)
December 19, 2008 at 2:32 pm
Lynn Pettis (12/19/2008)
December 19, 2008 at 2:20 pm
Paul (12/19/2008)
It works happily for a few hours, then suddenly comes apart in a mass of "System.Data.SqlClient.SqlException, Timeout expired" exceptions
Sounds like the data volumes in prod are causing perf problems....
December 19, 2008 at 2:13 pm
Eric Butler (12/19/2008)
Simple question which I thought would be straight forward.Is it necessary to perform an sp_recompile after performing batch UPDATE STATISTICS operations.
No. A stats update invalidates all plans based...
December 19, 2008 at 1:56 pm
Osmar Fernandez (12/19/2008)
December 19, 2008 at 1:47 pm
Leave it at 0. No real need to fiddle with that.
The main reason to change that is for servers that have multiple instances of SQL on them.
December 19, 2008 at 1:43 pm
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
Viewing 15 posts - 42,241 through 42,255 (of 49,571 total)