Viewing 15 posts - 61 through 75 (of 716 total)
David Burrows (4/12/2011)
However, I think the following is a bit easier to follow
CASE WHEN [DESC] LIKE '[0-9][0-9][0-9][0-9][0-9][0-9]%' THEN
True, I was just following his example, and the thread is called...
April 12, 2011 at 10:07 am
Hugo Kornelis (4/12/2011)
April 12, 2011 at 10:02 am
Nice question, thanks! This is also a nice feature, though it is best if you don't have corrupt pages that need fixing. 😉
April 12, 2011 at 9:59 am
thamatrix1436 (4/11/2011)
Very odd. Got an error trying to do the conversion...Conversion failed when converting date and/or time from character string.
And thats w/ and w/o the PatIndex in the WHERE clause.
Not...
April 11, 2011 at 5:50 pm
thamatrix1436 (4/11/2011)
April 11, 2011 at 3:58 pm
Are you sure memory is the problem? When the performance is bad have you checked the CPU usage and disk I/O? It is only one application that is slow, or...
April 11, 2011 at 1:21 pm
gheinze (4/10/2011)
With "Windows Dynamic Cache Service" will I solve this issue?
The "Windows Dynamic Cache Service" should solve the problem, if the problem is the memory being used by the cache.
If...
April 11, 2011 at 12:26 pm
Jeff Moden (4/11/2011)
Note to self... always assume that something changed without my knowledge and look for it right up front.
I had assumed something changed and started looking on the Oracle...
April 11, 2011 at 10:11 am
Jeff Moden (4/10/2011)
April 10, 2011 at 11:42 pm
That could be your problem you can read about it in these links:
http://blogs.msdn.com/b/ntdebugging/archive/2007/11/27/too-much-cache.aspx
http://blogs.msdn.com/b/ntdebugging/archive/2009/02/06/microsoft-windows-dynamic-cache-service.aspx
Of course, this is usually only a problem when someone has used the Windows Explorer to copy files...
April 8, 2011 at 4:14 pm
Justin-281851 (4/8/2011)
Msg 102, Level 15,...
April 8, 2011 at 4:03 pm
If your databases are in the FULL recovery mode, and you have done at least one full backup, your log files would grow and grow and grow until the disk...
April 8, 2011 at 3:56 pm
Stephen_W_Dodd (4/8/2011)
Is the 'point' column an integer or a decimal field? (I think we should all get an extra .5 point for the aggrevation :-P)
As far as I know it...
April 8, 2011 at 2:51 pm
Your welcome, and thanks for letting me know that it helped.
April 8, 2011 at 1:35 pm
Viewing 15 posts - 61 through 75 (of 716 total)