Viewing 15 posts - 38,026 through 38,040 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 7:56 am
Lynn Pettis (6/30/2009)
GilaMonster (6/30/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 6:18 am
Ok, those worked properly.
This is seriously weird.
Edit: Anyone else seeing this? (I've already passed it on to Steve)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 6:12 am
S Hodkinson (6/30/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 6:08 am
Can someone send me a PM please. There looks like there's something buggy, every PM I've received in the last week has been from 'Anonymous' and has no profile associated.
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 6:06 am
Paul White (6/30/2009)
PS I have yet to come across a system that ended up needing the -g switch
I have. Previous company we had one server that was used for a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 5:58 am
Viewing 15 posts - 38,026 through 38,040 (of 49,552 total)