Viewing 15 posts - 7,816 through 7,830 (of 8,416 total)
kladibeeto (6/6/2009)
This applies to both SQL 2000 and SQL 2005 I test it.
Yes but the links I posted are 2005-specific. That's why it pays to post in the correct...
June 6, 2009 at 8:16 pm
Yes this was a poor QOD, for all the reasons stated so far.
June 6, 2009 at 9:54 am
GilaMonster (6/6/2009)
Paul White (6/6/2009)
June 6, 2009 at 9:40 am
GilaMonster (6/6/2009)
Jeff Moden (6/6/2009)
Gail's BOL link doesn't work for me when I paste it into the help URL field. I'm still using 2k5 if that matters.
That link's from the...
June 6, 2009 at 9:37 am
Jeff Moden (6/6/2009)
Paul White (6/6/2009)
June 6, 2009 at 9:27 am
Alvin Ramard (6/6/2009)
Paul White (6/6/2009)
..... 'if you use undocumented features your wife will leave you' ......
FYI, wives come with undocumented features too.
ROFL!!!
I live in hope of a QFE...
June 6, 2009 at 9:20 am
FreeHansje (6/6/2009)
June 6, 2009 at 9:18 am
Jeff Moden (6/6/2009)
June 6, 2009 at 8:52 am
GilaMonster (6/6/2009)
...stuff I agree with entirely...
Nice post Gail. I think BOL could definitely benefit from some clarification so anything you can help along there would be all good.
June 6, 2009 at 8:44 am
For completeness:
The recovery model can affect performance particularly if the transaction log file(s) are set to auto-grow from a small size and in small increments. The frequent file growths...
June 6, 2009 at 8:34 am
Cool!
BTW that's pretty much where my expertise with reals and floats ends - I think I have a fair grasp of how they are implemented, and some of their strengths...
June 6, 2009 at 7:56 am
I see mjarsaniya has posted a very apologetic reply.
Good on him/her. It would have been easy to take the solution and run.
Nice to see.
June 6, 2009 at 7:48 am
Regarding the update of the table variable.
Let me start by saying that the poster's comments grated with me too...especially considering the first post was incomplete and contained errors.
Having said all...
June 6, 2009 at 7:43 am
mjarsaniya (6/6/2009)
yes but you have created table t not @t....I have problem with table variable @t.......
table variable can't be updated as shown by me or u.
Hi,
t is an alias for...
June 6, 2009 at 6:09 am
The entry in BOL has always been badly worded and confusing, at least to me.
It goes on to say: "SQL Server treats n as one of two possible values. If...
June 6, 2009 at 5:36 am
Viewing 15 posts - 7,816 through 7,830 (of 8,416 total)