Viewing 15 posts - 2,791 through 2,805 (of 8,416 total)
David Benoit (8/13/2010)
Out of curiosity what makes you think this is a WOW configuration even though he stated that both Windows and SQL Server were 64-Bit?
SQL Server x86 gets a...
August 13, 2010 at 6:46 am
Mark_Pratt (8/13/2010)
August 13, 2010 at 6:27 am
SureshS_DBA (8/13/2010)
So is there a way to see the actual statement which is open when there are other statements which have been run after the open transaction for given spid?
No....
August 13, 2010 at 5:34 am
David,
This is a neat way of capturing that information:
select name,
value,
value_in_use
from ...
August 13, 2010 at 5:28 am
The shrink routine is pretty simple - essentially, it just moves whole pages from the end of the file toward the beginning, to free up space at the end of...
August 13, 2010 at 4:58 am
TDP (8/12/2010)
August 13, 2010 at 2:35 am
CirquedeSQLeil (8/12/2010)
August 12, 2010 at 10:20 am
Gianluca Sartori (8/12/2010)
It could get even more confusing, if you like:/snip/
Nice, isn't it?
Very nice. Hadn't seen that one before. There's so much weirdness around temporary tables...
USE tempdb;
GO
CREATE ...
August 12, 2010 at 10:05 am
GilaMonster (8/12/2010)
Dave Ballantyne (8/12/2010)
August 12, 2010 at 9:46 am
David Benoit (8/12/2010)
Paul White NZ (8/12/2010)
You can name constraints on # and ## temporary tables, but it is a pretty bad idea.
I haven't had a need to do this (or...
August 12, 2010 at 9:41 am
Brandie Tarvin (8/12/2010)
Paul White NZ (8/12/2010)
Dave Ballantyne (8/12/2010)
So if you want to use an index you generally have to use a hint.
What sort of hint did you have in mind?...
August 12, 2010 at 8:20 am
GilaMonster (8/12/2010)
Dave Ballantyne (8/12/2010)
August 12, 2010 at 7:19 am
Dave Ballantyne (8/12/2010)
Remember that the optimizer uses statistics to decide to use an index.
Statistics are just one element in the decision-making process. Finding an efficient access path is another....
August 12, 2010 at 7:15 am
Steve Jones - Editor (8/11/2010)
One a side note, I thought this was interesting: http://sqlblog.com/blogs/linchi_shea/archive/2010/08/11/performance-impact-forget-about-sets-and-focus-on-loops.aspx
Linchi always posts good stuff. He's absolutely right too: all non-parallel query plan iterators process one...
August 11, 2010 at 9:33 pm
iqtedar (8/11/2010)
thanks Paul and Gail.Based on your statements it makes me believe that irrespective of the value of MAXDOP, Cost threshold will always play a role?
Yes, I think you've got...
August 11, 2010 at 8:52 pm
Viewing 15 posts - 2,791 through 2,805 (of 8,416 total)