Viewing 15 posts - 38,041 through 38,055 (of 49,571 total)
nscott (6/30/2009)
However, now I have an issue with the specific update query I'm running. Not sure if I should create a new post.
Please do, as this has nothing to...
June 30, 2009 at 10:09 am
A permanently running server-side trace.
June 30, 2009 at 9:50 am
Lynn Pettis (6/30/2009)
I don't feel like checking, was AWE enabled?
Yes. At least, it was enabled in the config that he posted, can't tell if /PAE was in the...
June 30, 2009 at 9:48 am
MichaelJasson (6/30/2009)
There is one requirement that I have to edit boot.ini file and make /3GB switch on in Vista:doze:.
Why do you want to do that?
June 30, 2009 at 9:13 am
Paul White (6/30/2009)
Lynn Pettis (6/30/2009)
If all three instances try to go to max memory levels, then yes it is more than the physical memory in the server.
Good post. Just...
June 30, 2009 at 9:09 am
Paul White (6/30/2009)
Ah yes - SQL 2K on Itanium. Never tried it myself, but you hear stories...
Been there, done that, would rather jump off the Space Needle than do...
June 30, 2009 at 8:58 am
How often are you doing log backups? What's the max amount of data that's allowed in the case of a disaster?
Oh, you are doing this testing on a test server?...
June 30, 2009 at 8:53 am
S Hodkinson (6/30/2009)
The routine full database and transaction log backup should happen in the early hours of the morning....
WITH STOPAT = 'June 30, 2009 14:35 PM', RECOVERY
If the tran log...
June 30, 2009 at 8:15 am
Please check Books Online for syntax and keywords.
No recovery should be one word - WITH NORECOVERY. I assume you're restoring from a backup device. If som the name must conform...
June 30, 2009 at 8:11 am
Lynn Pettis (6/30/2009)
hi_abhay78. In a follow on post he disclosed he worked for PSS regarding SQL Server for 2.5 years.
Interesting. I missed that. I wonder what region and what...
June 30, 2009 at 7:56 am
Lynn Pettis (6/30/2009)
GilaMonster (6/30/2009)
June 30, 2009 at 7:30 am
David Burrows (6/30/2009)
There is a member with the name 'Anonymous'
Yeah, but I don't think it's that. If you check the screen shot, there's no profile details, the name is not...
June 30, 2009 at 7:29 am
I don't think anyone's doing it intentionally. If they are, it's really silly, sending a message to someone asking for help and leaving no way for them to return said...
June 30, 2009 at 7:00 am
Steve Jones - Editor (6/30/2009)
Sorry, Gail. Rebuilt laptop on the road, no VPN, but I shall look into it.
No rush. Can wait til you're home. Just way puzzling
Perhaps it is...
June 30, 2009 at 6:44 am
GDI Lord (6/30/2009)
I'm surprised that the column order of an index makes a difference!
SQL can only seek on a left-based subset of the index key
Think of the local phone...
June 30, 2009 at 6:18 am
Viewing 15 posts - 38,041 through 38,055 (of 49,571 total)