Viewing 15 posts - 41,461 through 41,475 (of 49,571 total)
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
ashepard (1/23/2009)
So does that mean the disk should be formatted for 8k sector size?
No.
There's lots of info on IO config for SQL. Google should find them for...
January 24, 2009 at 1:20 am
Is there any blocking?
Has the volumes of data changed?
Are your indexes defragmented and your stats up to date?
January 24, 2009 at 1:18 am
Ed (1/23/2009)
Thanks for your help. I'm using Toad for SQL Server, so hopefully this is the format you're looking for.
No. I was looking for the exec plan that management...
January 23, 2009 at 2:38 pm
kwiggans (1/23/2009)
January 23, 2009 at 2:27 pm
Marios Philippopoulos (1/23/2009)
There is a risk that the data from the DMV dm_exec_query_stats is regularly flushed from memory if there is memory pressure in your system.
There's a couple other...
January 23, 2009 at 2:23 pm
KATHLEEN Y ZHANG (1/23/2009)
I hope running trace as a background job is much less intrusive.
It is. Grant explained why - http://scarydba.wordpress.com/2008/12/18/profiler-research/
January 23, 2009 at 2:14 pm
Viewing 15 posts - 41,461 through 41,475 (of 49,571 total)