Viewing 15 posts - 40,486 through 40,500 (of 49,552 total)
grngarlapati (3/7/2009)
Thanq john actually i am sarching for any buit in function or view for this any ways thnq for the reply
The views that John used in his query...
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
March 8, 2009 at 1:58 am
Jeff Moden (3/7/2009)
Consider the OP in the following... Lynn may have competition for saint-hood... 🙂http://www.sqlservercentral.com/Forums/Topic670491-338-1.aspx
Mike is one of those people on my blacklist, due to his repeated demonstrations that he...
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
March 8, 2009 at 1:48 am
musheik (3/8/2009)
like we have in oracle ( cursor...
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
March 8, 2009 at 1:48 am
Steve Jones - Editor (3/7/2009)
Surprisingly there isn't a lot of poking fun in the MVP forums, except at each other.
Of course not. That kind of behaviour would be unthinkable for...
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
March 7, 2009 at 12:47 pm
David O (3/7/2009)
That said, I have successfully used the advice I gave. I think caveats were clear and appropriate. I stand by post.
I'm sure you...
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
March 7, 2009 at 11:21 am
Thanks Paul
Paul Randal (3/7/2009)
PS I'll turn this into a blog post
Awesome. I look forward to it.
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
March 7, 2009 at 10:04 am
t.walker (3/6/2009)
I really support that idea. I think a more private invited members forum would enable me to speak more freely/
Just one question. How would you determine who's allowed in...
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
March 7, 2009 at 1:01 am
David O (3/6/2009)
6. If the database comes on line, detach it.7. Delete the log file
Sorry for been blunt, but that is very, very bad advice when it comes...
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
March 7, 2009 at 12:51 am
chrisau168 (3/6/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
March 6, 2009 at 2:28 pm
However the article does not over the case of the corrupt log, which I think is what we have here.
I'm gonna leave this one for Paul Randal, I know he'll...
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
March 6, 2009 at 2:26 pm
Grant Fritchey (3/6/2009)
Remember, don't feed the trolls.
Indeed. He thinks we hate him, let's not prove him right.
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
March 6, 2009 at 2:23 pm
Sql Student (3/6/2009)
Is there a reason why this is happening?
Because the restore was with NORECOVERY.
The database won't be available until do a restore WITH RECOVERY and that must be...
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
March 6, 2009 at 1:20 pm
Mangal9i (3/6/2009)
That was Actaul evexution plan and not estimated, though most of the time they both are same.
Doesn't matter. The only difference between those two are that the actual has...
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
March 6, 2009 at 1:17 pm
Restore the full, the latest differential and then all the transaction log backups since the last diff (if you have log backups) in sequence
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
March 6, 2009 at 1:01 pm
From Books online
[ @filecount = ] 'max_rollover_files'
Specifies the maximum number or trace files to be maintained with the same base filename. max_rollover_files is int, greater than one. This parameter...
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
March 6, 2009 at 12:59 pm
Viewing 15 posts - 40,486 through 40,500 (of 49,552 total)