Viewing 15 posts - 46,081 through 46,095 (of 49,571 total)
Nisha (6/26/2008)
June 26, 2008 at 11:58 pm
TheSQLGuru (6/26/2008)
2) Page Life expectancy is too low. Need more RAM.
Except that he's on 2000 Standard edition and has 2GB allocated to SQL already.
4) Latch waits pretty high. ...
June 26, 2008 at 1:55 pm
rbarryyoung (6/26/2008)
mithun gite (6/26/2008)
Respected Mr. Gail shaw & RBarryYoung, ...Gail is probably too polite to point it out, but I think that you meant to say "Ms. Gail Shaw".
I'm used...
June 26, 2008 at 1:42 pm
The 2005 optimiser is quite different to the 2000 one and often produces different plans.
One very quick thing to check first. Did you update statistics after restoring the 2000 database...
June 26, 2008 at 1:27 pm
Find what is making them run long and fix it.
Seriously now. First you need to identify why the query is running slow. Is there blocking? Are there excessively long waits?...
June 26, 2008 at 1:29 am
Excellent.
If you find there is data you can't recreate, post again here and I'll try and help you salvage as much as possible from the DB.
You may also want to...
June 26, 2008 at 1:03 am
Have you seen the case statement before?
select datepart(ww, created_date) as week, count(*) as count,
CASE created_as
WHEN 'true' THEN 'Some String Here'
...
June 26, 2008 at 12:48 am
No.
The point of having a transaction log alone on a drive is so that the disk's write head is always (*) in position to write, since a log is written...
June 25, 2008 at 11:54 am
I'm not sure how to recover from that problem without loosing some data.
If you try to set the database into emergency mode, can you view the tables? Can you...
June 25, 2008 at 11:35 am
Glad to help.
Now plase make sure that all of your databases, including the system ones (master, model, msdb) get regularly backed up.
June 25, 2008 at 11:17 am
Leslieo (6/25/2008)
At any rate, I've found the Head First C# book to be worthwhile for training, though you'll need the C# doorstop reference to go with it.
I've used the Java...
June 25, 2008 at 11:06 am
2005.
SQL 2000 standard supported max 2 GB, regardless of the setting of the /3GB switch or AWE
June 25, 2008 at 7:58 am
The stuff I gave tyou is to see why the tran log can't be truncated. Once we know that, fixing is usually isn't hard.
Auto commit is the SQL default. Unless...
June 25, 2008 at 7:44 am
If it's a 2005 database rather don't enable torn page detection. Enable page checksum. It's a more accurate way of detecting damage to pages.
You want some form of page protection...
June 25, 2008 at 7:38 am
Ok, there are other ways of doing that then reading the tran log (which is messy)
Have a look at the sys.databases view. There's a column called log_reuse_wait_desc. It lists the...
June 25, 2008 at 7:28 am
Viewing 15 posts - 46,081 through 46,095 (of 49,571 total)