Viewing 15 posts - 766 through 780 (of 8,415 total)
jcb (2/13/2012)
implicit outter joins are no more in SQL 2012?:w00t:
Yes:
http://msdn.microsoft.com/en-us/library/ms144262(v=sql.110).aspx
And a good thing too.
February 13, 2012 at 11:27 am
L' Eomot Inversé (2/13/2012)
But that's a pretty content-free explanation!
My recollection is that it is the process that has generated least log that is selected as the victim.
February 13, 2012 at 11:23 am
Replying to the article: the horrible *= and =* syntax is finally dead in SQL Server 2012 (no 80 compatibility). Semicolons are generally a good thing, but I don't...
February 13, 2012 at 10:40 am
cengland0 (2/13/2012)
February 13, 2012 at 7:26 am
cengland0 (2/13/2012)
February 13, 2012 at 7:20 am
cengland0 (2/13/2012)
What other ways can you change the entire contents of a table and still have the reports available without dirty data?
Aside from the VIEW suggestion, similar alternatives include using...
February 13, 2012 at 6:34 am
Hugo Kornelis (2/13/2012)
I didn't check it, but I fully expect an ALTER VIEW statement to require an exclusive schema lock.
This is true, but it's not really a problem - the...
February 13, 2012 at 6:28 am
Good question, no complaints from me 🙂
February 13, 2012 at 1:37 am
Koen Verbeeck (2/9/2012)
SQL Kiwi (2/9/2012)
There's really no need to use this any more anyway - we have XML PATH and CLR.
That is a bit of the problem.
XML PATH and CLR...
February 9, 2012 at 3:21 am
Samuel Vella (2/9/2012)
CELKO (2/8/2012)
your mindset is still stuck in procedural languages.
A huge assumption and very condescending! (You can insert your own words of choice to give that sentence some...
February 9, 2012 at 2:38 am
Koen Verbeeck (2/9/2012)
February 9, 2012 at 1:31 am
AAYakovenko (2/8/2012)
I want to know the reason for this behavior stranngo.
Let me try to explain again. Using variable concatenation in this way was a quirk of (much) older versions...
February 9, 2012 at 1:21 am
drew.allen (2/8/2012)
I don't see it. As far as I can tell these two queries produce exactly the same results and the execution plans are almost identical.
I read your original...
February 8, 2012 at 9:37 am
Evil Kraig F (2/7/2012)
CELKO (2/7/2012)
This is minimal polite behavior on a SQL forum.
Seriously? Would you like to be the pot, or the kettle, for the remainder of that...
February 8, 2012 at 8:57 am
Mark-101232 (2/8/2012)
Documented herehttp://msdn.microsoft.com/en-US/library/ms177523(v=sql.90).aspx
In the section "Using UPDATE with the FROM Clause"
John might also like to read the BOL entry below which documents some of the cases where a syntactically correct...
February 8, 2012 at 8:50 am
Viewing 15 posts - 766 through 780 (of 8,415 total)