Viewing 15 posts - 166 through 180 (of 242 total)
Alan Spillert (4/20/2009)
Is there something in SQL Server that could cause this ? or am I missing something in my application?Thank you,
Alan
It's most likely that you are missing something...
April 21, 2009 at 7:19 am
You have to be careful if this is a mainenance plan
I have seen this a few times and it has often been that the attempt to backup occurs before the...
April 21, 2009 at 7:11 am
I might have misunderstood what you are trying to do, but have you looked up OPENXML in Books OnLine?
This enables you to open an XML document into a table structured...
April 20, 2009 at 6:10 am
Thanks very much to both of you for your assistance.
April 20, 2009 at 5:55 am
Thanks Gail, very useful, particularly how table variables are actually held and the kb article which explains where the 'extra' reads can come from.
I'm clear on the difference between logical...
April 20, 2009 at 4:56 am
Thanks for that Paul, much appreciated.
The problem I have though is that the profiler is my preferred tool for analysing performance. I can rationlise what the CPU and Write counters...
April 20, 2009 at 4:19 am
btb1977 (4/15/2009)
Tim Walker (4/15/2009)
If you have an upgrade from 2000 to 2005 you may well have some compilation differences.
One good way to detect this...
April 16, 2009 at 1:43 am
Yep, statistics are vital.
If you update them automatically, you might get a performance hit on the processes that force the update.
If you do it manually, you need to pick a...
April 15, 2009 at 4:45 pm
Hang on. Can I start from scratch...
If you have an upgrade from 2000 to 2005 you may well have some compilation differences.
One good way to detect this (after implementation) is...
April 15, 2009 at 4:29 pm
Carol Adams (4/15/2009)
April 15, 2009 at 4:08 pm
Morris_Lewis (4/8/2009)
April 8, 2009 at 8:10 am
Sorry just reread your previous posts and you are expanding by 100MB. Why not change this to 99MB so it can't regrow to exactly the same size? This eliminates the...
April 8, 2009 at 8:05 am
You can find out when it expanded by looking in the ..\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory. By default SQL creates trace files in there and one of the things traced is...
April 8, 2009 at 8:02 am
Just installed Diskeeper 2009 Server 13.0.842.0 .
This was supposed to resolve the matter but in fact SQL Server hung with CPU at 100% after only three hours. A few minutes...
April 8, 2009 at 6:36 am
ben.rosato (4/7/2009)
fhanlon (4/7/2009)
Check if there is anything in the SQL log at the time that might help. (maybe a restore job??)
Nope, nothing of the sort.
So, these data...
April 7, 2009 at 4:16 pm
Viewing 15 posts - 166 through 180 (of 242 total)