Viewing 15 posts - 991 through 1,005 (of 7,636 total)
mick L (2/15/2010)
Apologies. As my question follows the context of this existing thread, I assumed that appending to the thread would be preferable to proliferating similar threads. ...
Nope, proliferating...
February 15, 2010 at 10:01 am
Ummm, why is every query that you post completely different?
Is this even still the same problem? If it is not, then you you start a new thread...
February 15, 2010 at 9:35 am
Here's an example using the [ code="xml" ] tag. If you want to see exactly how it is done, just hit the "Quote" button over my post:
<TABLES>
<TABLE_CATALOG>NewTest1</TABLE_CATALOG>
...
February 15, 2010 at 9:27 am
mick L (2/15/2010)
Say I have products,...
February 15, 2010 at 9:20 am
Can you give us some sample data (as Insert statements, please), and expected output from that data? That would help a lot.
February 14, 2010 at 11:57 pm
Paul White (2/13/2010)
RBarryYoung (2/13/2010)
Right you are, Paul. Thanks for the correction.
Not really a correction, more of a slight expansion of your point. You're very welcome in any case...
February 14, 2010 at 11:47 pm
Alvin Ramard (2/13/2010)
RBarryYoung (2/13/2010)
Alvin Ramard (2/12/2010)
Paul White (2/12/2010)
Way too much detail Barry :sick: 😀... and no pictures, PLEASE!!
So video is OK? :-D:-P
Sure. Send it to Steve to...
February 14, 2010 at 11:38 pm
D.Oc (2/13/2010)
RBarryYoung (2/12/2010)
GSquared (2/12/2010)
WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]
I'm not sure that's the tag you wanted, Wayne.
Dictionary definition: physic noun: ...
February 13, 2010 at 10:12 am
Alvin Ramard (2/12/2010)
Paul White (2/12/2010)
Way too much detail Barry :sick: 😀... and no pictures, PLEASE!!
So video is OK? :-D:-P
February 13, 2010 at 10:08 am
Paul White (2/13/2010)
RBarryYoung (2/10/2010)
I believe that SET ROWCOUNT is deprecated in SQL 2005 and up.
Yes, for data modification only. See http://msdn.microsoft.com/en-us/library/ms187043.aspx, the important part is reproduced below:
Using SET ROWCOUNT...
February 13, 2010 at 10:01 am
GSquared (2/12/2010)
WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]
I'm not sure that's the tag you wanted, Wayne.
Dictionary definition: physic noun: a purging...
February 12, 2010 at 9:17 pm
TRUSTWORTHY is a Database setting, not a user or login privilege. You set it like this:
ALTER DATABASE SET TRUSTWORTHY ON
You should beware however because TRUSTWORTHY...
February 12, 2010 at 9:10 pm
Good stuff ALZ, I think that should satisfy my recommendation to improve the discrimination of the Update index.
February 12, 2010 at 8:56 pm
Thanks Lynn. as for the SB stuff, I am OK with it if Gail does not mind...
February 11, 2010 at 10:06 pm
sarigulyavuz (2/11/2010)
...if you look execution plan there are a lot of "index update" and "table spool" what does it mean?
"index update" means exactly what it says, it's is updating one...
February 11, 2010 at 2:36 pm
Viewing 15 posts - 991 through 1,005 (of 7,636 total)