Viewing 15 posts - 41,446 through 41,460 (of 49,562 total)
Well, if you do with init, you'll overwrite the old backup and hence break the log chain. Not a good idea.
I just change the backup command so that each...
January 25, 2009 at 10:37 am
No idea. Post the full setup for your test (including table creation, population and the exact queries you used) and I'll check.
Just be careful with using table variables, because they...
January 25, 2009 at 10:34 am
Jeff Moden (1/25/2009)
January 25, 2009 at 10:32 am
msalmaan (1/25/2009)
My dear the question is how come the test environment will have the database size bigger than production environment.
Who knows. Maybe someone created a really large table and then...
January 25, 2009 at 2:39 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/Topic643123-5-1.aspx
January 25, 2009 at 2:37 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/Topic643123-5-1.aspx
January 25, 2009 at 2:37 am
That error indicates that something was using model. Were there any connections or queries to the model database at the time? (including your query that was trying to create the...
January 25, 2009 at 2:32 am
Sankar Reddy (1/24/2009)
Correlated subquery, inner query is executed once for each row from the outer table and this can be expensive on large datasets.
That's only true when the join to...
January 25, 2009 at 2:10 am
msalmaan (1/25/2009)
please.............help me
What do you want help with? I didn't notice a question.
January 25, 2009 at 2:01 am
Jeff Moden (1/24/2009)
A perfect example can be found at the following link..http://www.sqlservercentral.com/Forums/Topic642789-338-1.aspx#bm642945
🙂 I'm busy witting a correction to one of his posts now. "Correlated subquery, inner query is executed...
January 25, 2009 at 1:57 am
Marios Philippopoulos (1/24/2009)
Hopefully, DMVs will be able to capture the remaining info in future versions of SQL Server...
I doubt they'll ever replace SQL trace because the DMVs, like extended events,...
January 24, 2009 at 9:12 am
Jeff Moden (1/24/2009)
January 24, 2009 at 9:10 am
Ed (1/23/2009)
Are either of these useful?
No. The image doesn't contain all the info, there's a lot that's in tooltips and operator properties. The xml (if that's what you saved to...
January 24, 2009 at 1:35 am
Ellen (1/23/2009)
The transaction log backup file is appended to with each log backup, it has grown from around 5 Gb to 8 Gb from Wednesday till today.
That may be the...
January 24, 2009 at 1:21 am
Viewing 15 posts - 41,446 through 41,460 (of 49,562 total)