Viewing 15 posts - 1,486 through 1,500 (of 8,416 total)
SQLSeTTeR (11/14/2011)
November 15, 2011 at 6:03 am
GSquared (11/14/2011)
Okay. I'm getting those later in the search results is all. Not sure why.
Primarily it's because I was originally too lazy to hunt all the links down...
November 14, 2011 at 11:38 am
Brandie Tarvin (11/14/2011)
November 14, 2011 at 11:26 am
GSquared (11/14/2011)
SQL Kiwi (11/14/2011)
Brandie Tarvin (11/14/2011)
Anything else I should put at the top of my "check this out" list with MERGE?
Yeah, do a Google search on "site:connect.microsoft.com sql server merge...
November 14, 2011 at 11:03 am
Brandie Tarvin (11/14/2011)
Anything else I should put at the top of my "check this out" list with MERGE?
Yeah, do a Google search on "site:connect.microsoft.com sql server merge bug" 🙂
November 14, 2011 at 10:34 am
Trey Staker (11/14/2011)
November 14, 2011 at 10:32 am
Bruce W Cassidy (11/14/2011)
November 14, 2011 at 10:26 am
Peter Brinkhaus (11/14/2011)
GilaMonster (11/14/2011)
Dev (11/14/2011)
It's not a run-time error, try-catch can't catch it.
Well, it should.
No it shouldn't.
Actually, it can, although in an indirect way:
Error handling in T-SQL is...
November 14, 2011 at 10:08 am
There was an interesting discussion on Connect following Hugo's suggestion that the UPDATE...FROM syntax be deprecated:
http://connect.microsoft.com/SQLServer/feedback/details/332437/deprecate-update-from-and-delete-from
14 up-votes and 52 down-votes as of now. I tend to align more with...
November 14, 2011 at 9:56 am
TheSQLGuru (11/14/2011)
November 14, 2011 at 7:37 am
Hey Bruce!
Bruce W Cassidy (11/14/2011)
I'm not a huge fan of recursive scenarios, largely (I suspect) because I work with data warehousing and we tend to like flattening hierarchies.
Sure, but recursive...
November 14, 2011 at 7:07 am
tfifield (11/13/2011)
November 13, 2011 at 2:27 pm
One more thing, Karl, you should run DBCC CHECKCONSTRAINTS on the tables involved in that query (I'm not sure if you run DBCC CHECKDB regularly - or if that includes...
November 13, 2011 at 2:16 pm
Hi Karl,
The plan ''QueryWithoutStatusRankInSelect" does indeed have an ANY Stream Aggregate; the "QueryWithStatusRankInSelect" does not (it has the row numbering Segment and Sequence Projects).
On the face of it, this behaviour...
November 13, 2011 at 1:33 pm
See this page in SQL Server Books Online:
November 13, 2011 at 10:45 am
Viewing 15 posts - 1,486 through 1,500 (of 8,416 total)