Viewing 15 posts - 40,516 through 40,530 (of 49,571 total)
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...
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...
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
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...
March 6, 2009 at 12:59 pm
Investor_Ennui (3/6/2009)
For my purpose, I'm using 2 for Monday, and 3 for Tuesday. Is it possible that the query isn't considering this?
The query's considering exactly what you write and...
March 6, 2009 at 12:44 pm
GSquared (3/6/2009)
We probably need to keep in mind that "MVP" != "Highly knowledgable about T-SQL".
No, but MVP for SQL Server does (or at least should) mean highly knowledgeable...
March 6, 2009 at 12:40 pm
The number of rollover files is one of the optional paramters for sp_trace_create
(From Books Online)
sp_trace_create [ @traceid = ] trace_id OUTPUT
...
March 6, 2009 at 12:31 pm
Mangal9i (3/6/2009)
Talking about execution plan, run both my query and your query and see cost of the query.Its 1% VS 99%.
SQL mis-estimates recursive CTEs very badly. The cost is based...
March 6, 2009 at 12:27 pm
Can you post table structure (as create table), some sample data (formatted as insert statements) and your desired output please. Is hard to test without.
March 6, 2009 at 9:29 am
liam (3/6/2009)
Thanks for the reply. Would DBCC be any use in this situation?
No. Firstly SQL can't start up with a damaged master so there's no way to run checkdb....
March 6, 2009 at 9:21 am
gregory.anderson (3/6/2009)
So...question, in your experiences, what is the confidence rating of these scripts?
Fairly low. The logic that goes into producing the missing index entries is a portion of what...
March 6, 2009 at 9:19 am
Roy Ernest (3/6/2009)
And all of you are trying to raise your post counts.... :hehe:
Indeed. I wonder if I can manage another 20 tonight. :w00t:
March 6, 2009 at 9:05 am
RBarryYoung (3/6/2009)
You know this is the most amazing part to me, how can an MSDN moderator act like this?
Something occurred to me...
How much of that came about because we...
March 6, 2009 at 9:01 am
Samrat Sen (3/6/2009)
Can anyone say whether serialization isolation level is prone to deadlock??
Transactions running under serializable are more likely to deadlock than any other, because of the extend of the...
March 6, 2009 at 8:55 am
Error: 9003, Severity: 20, State: 9.
The log scan number (268:480:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log...
March 6, 2009 at 8:34 am
Viewing 15 posts - 40,516 through 40,530 (of 49,571 total)