Viewing 15 posts - 541 through 555 (of 7,636 total)
RBarryYoung (4/10/2010)
(Heisenbergian sarcasm mode on)How have I missed this ontological wonder of a thread ... ?
(Heisenbergian sarcasm mode off)
Or is is epistemological? I always get them mixed up...
April 10, 2010 at 9:45 am
Someone please tell me that this is not how Paul knocked out 3000 points in one month. I had ***-umed he was just racking up all of the QotDs...
April 10, 2010 at 9:43 am
(Heisenbergian sarcasm mode on)
How have I missed this ontological wonder of a thread ... ?
(Heisenbergian sarcasm mode off)
April 10, 2010 at 9:41 am
Paul White NZ (4/9/2010)
Dave Ballantyne (4/9/2010)
HmmmRemoving the Ip calculation and just setting it to zero , brings the run time crashing down to 600 - 700 ms..
The in-line version ends...
April 9, 2010 at 1:28 pm
Tom.Thomson (4/8/2010)
Hugo Kornelis (4/8/2010)
CirquedeSQLeil (4/8/2010)Is 0/0 = 1 or is 0/0 an error?
To that question, my answer is a clear and resounding "yes"! 😛
And mine is a resounding "sometimes"! Unless...
April 8, 2010 at 10:05 pm
Disk queue lengths aren't measured or reported in percents? Busy% and Idle% are, but not queue lengths, so I can't tell what your actual queue lengths were?
April 8, 2010 at 3:21 pm
hmink 90250 (4/8/2010)
April 8, 2010 at 1:42 pm
hmink 90250 (4/8/2010)
April 8, 2010 at 1:23 pm
There's a lot of options and different ways to handle this in Excel, or in conjunction with both Excel and SQL Server. For instance many folks find that using...
April 8, 2010 at 1:19 pm
Excel has much better formatting capabilities than SQL Server, so you should probably be looking at this as an Excel reporting problem.
April 8, 2010 at 1:07 pm
If you uninstall SQL Server, that should remove it.
I am not sure if there is any other supported way to do this, why do you think that you need to...
April 8, 2010 at 1:00 pm
Add the command "EXEC(@sql_query);" right before your send_dbmail. Then make sure that the job step is logging all of its output to a table or file and run it...
April 8, 2010 at 12:53 pm
RBarryYoung (4/8/2010)
Tom.Thomson (4/8/2010)
RBarryYoung (4/7/2010)
Paul White NZ (4/7/2010)
RBarryYoung (4/7/2010)
Yup, AFAIK SQRT, LOG and maybe POWER are the only things that return this error.
Ooo - I had never tried POWER. Have...
April 8, 2010 at 12:39 pm
CirquedeSQLeil (4/8/2010)
RBarryYoung (4/8/2010)
Tom.Thomson (4/8/2010)
RBarryYoung (4/7/2010)
Paul White NZ (4/7/2010)
RBarryYoung (4/7/2010)
Yup, AFAIK SQRT, LOG and maybe POWER are the only things that return this error.
Ooo - I had never tried POWER. ...
April 8, 2010 at 12:35 pm
Viewing 15 posts - 541 through 555 (of 7,636 total)