Viewing 15 posts - 5,266 through 5,280 (of 7,636 total)
You can also check to see which SQL processes are consuming the most CPU:
Select * From
(Select DateDiff(ss, Login_Time, Getdate()) as ConnectTime,
Cast( Cast(CPU as Float)/1000000 as Numeric(12,3)) as CpuSec,
Cast(...
October 15, 2008 at 9:27 am
Basic question, but have you established that it is coming from SQL Server?
In other words, have you used Task Manager, or Process Explorer or some equivalent to look at the...
October 15, 2008 at 8:58 am
jcrawf02 (10/15/2008)
rbarryyoung (10/15/2008)
Sorry, I was using programmer's slang (not even jargon, really).Isn't jargon just a fancy word for slang? 😛
Actually, no, not IMHO. But there are many who disagree...
October 15, 2008 at 8:31 am
It is curious Tracey. I have been using it myself on sevral servers and I have never noticed it shutting down before. Perhaps my SQL Agent Email Alerts...
October 15, 2008 at 8:14 am
Sorry, I was using programmer's slang (not even jargon, really).
October 15, 2008 at 8:10 am
Well, dynamic SQL (like Richard Fryar's solution) cannot be made into a View or even a Table-Valued Function. If, however, you can get away with a static solution, then...
October 15, 2008 at 8:08 am
It's a naturally seductive trap, Jeff. I find myself making the same mistake all the time. 🙂
October 15, 2008 at 8:00 am
OK, I have done some research on thi sand here is what I have found:
TRACEY (10/14/2008)
October 15, 2008 at 7:55 am
a2zwd (10/15/2008)
Hi,Thanks for the replies. I did with global temporary table.
Any how the SP will execute only once and as a job.
So, global temporary table is fair enough.
Well,...
October 15, 2008 at 7:21 am
Nope. Back to the salt mines, dude. Publish or perish.
October 14, 2008 at 11:10 pm
leo.medina (10/14/2008)
We have a criteria (second to the last) to check for this. Is this not correct?
Actually, no.
The problem is that the order of AND sub-clauses in the...
October 14, 2008 at 11:08 pm
Perhaps the problem is that SQL isn't quite Lisp?
Heh. Just kidding 😛
October 14, 2008 at 9:43 pm
Jeff Moden (10/14/2008)
Heh... if you guys keeps it up, I won't have to write the article. 🙂
Ooooh, No, we're not gonna let you off that easily! :laugh:
And let's set some...
October 14, 2008 at 9:29 pm
Perhaps you should tell us your situation with SQL Server 2000 that you hope will be fixed by SQL Server 2008?
October 14, 2008 at 9:10 pm
Viewing 15 posts - 5,266 through 5,280 (of 7,636 total)