Viewing 15 posts - 34,321 through 34,335 (of 49,552 total)
george sibbald (1/30/2010)
they were? People do that?
Sure. The exceptional DBA allowed both people to nominate others and for people to nominate themselves. Lots of people will nominate themselves for things...
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
January 30, 2010 at 5:11 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic856488-146-1.aspx
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
January 30, 2010 at 2:44 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic856488-146-1.aspx
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
January 30, 2010 at 2:44 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic856488-146-1.aspx
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
January 30, 2010 at 2:44 am
Does updating statistics on the table Log_Event help? The estimated rows are 1 and it looks like the type of index that will be susceptible to stale stats
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
January 30, 2010 at 2:37 am
AWE allows SQL to address memory about the 4GB boundary imposed by the 32 bit processor architecture. Hence it's only useful when running 32 bit SQL Server.
These may help
http://msdn.microsoft.com/en-us/library/ms190673.aspx
http://msdn.microsoft.com/en-us/library/aa213764%28SQL.80%29.aspx
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
January 30, 2010 at 2:32 am
Jeff Moden (1/29/2010)
What would really be cool is to see the email or letter from the person(s) that nominated these folks.
I can't speak about the 2008 one (which this...
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
January 30, 2010 at 2:15 am
There's something odd going on with the forum. Suddenly lots of old announcements,podcasts, etc are pitching up in the forums with recent dates. I mean, this announcement dates back to...
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
January 30, 2010 at 2:11 am
It's Hermes (Mercury) one of the greek gods. I believe he was the messenger of the gods
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
January 30, 2010 at 2:02 am
Jeff Moden (1/29/2010)
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
January 30, 2010 at 1:59 am
I suggest you spend some time reading Books Online. There are good sections on restoring when a DB is in full recovery.
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
January 29, 2010 at 2:03 pm
Please run this and post the full and complete output. If you need a fast response (ie faster than 10 hours) I suggest you call MS. They will likely ask...
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
January 29, 2010 at 2:00 pm
rotkehlchen105-kak (1/29/2010)
I don't know why people keep saying that the rollback will resume when restarting the server. That's BS
Nope, it's fact. I can pull error log entries out to show...
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
January 29, 2010 at 12:32 pm
Either restore a backup of master (if you can, no guarantees that it will be possible) or rebuild the master database.
What you can do is rebuild master (to get SQL...
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
January 29, 2010 at 12:27 pm
Is there a question here?
If you're looking for a resolution, there's one in the error message
Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files...
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
January 29, 2010 at 7:38 am
Viewing 15 posts - 34,321 through 34,335 (of 49,552 total)