Viewing 15 posts - 1 through 15 (of 425 total)
Thank you all for your valuable responses. As I think can easily be seen from my opening post I am a proponent of always using the update-alias syntax when a...
December 10, 2021 at 10:08 am
Thank you so much. After a lot of searching, I located your script which shades real insight into how to approach this problem.
My case is little reverse though....
April 11, 2021 at 9:55 pm
Using the outer apply is causing this. Replacing it by a cross apply avoids the problem. Now I just need to make sure that I won't filter out any rows...
April 15, 2019 at 9:11 am
Thanks! That's one for me to take away 🙂
October 3, 2017 at 6:17 am
Excellent. Then, while you're still in learning mode ;-), please go on and hone your new tools to perfection using this example:SELECT STUFF( ( SELECT N','...
October 3, 2017 at 5:42 am
Not completely like you requested, but having values for column names makes it hard to retrieve the data for your client software, so i suggest you pick fixed column names...
October 3, 2017 at 12:51 am
For this to work, specify on the Connection dialog in SSMS, in the Additional Connection Parameters tab, a key Replication='true', then connect to your server and db. All foreign keys,...
July 6, 2017 at 9:55 am
I've run cdc for incremental loading in several projects and I've found that it a) has some bugs, plus b) it has performance issues with larger datasets. In a MS...
June 20, 2017 at 3:03 am
A blog from Adam Machanic in 2009 having the same idea: http://sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspx
It's not really documentation, but at least more people describe the same functionality.
June 19, 2017 at 9:08 am
Deferred updates are nowadays even more hot than they were 12 years back: today not only transactional replication uses the log reader's output, but also CDC uses the same output....
May 15, 2017 at 3:01 am
RandomEvent - Wednesday, May 10, 2017 9:31 AMCould you not achieve a lot of this more efficiently with a Merge statement ?
May 11, 2017 at 4:07 am
This thread went nowhere, very quickly, with the isnull discussion totally irrellevant to the OP's question. I hope you can still filter out the various options presented, komal145?
January 11, 2017 at 6:45 am
And if you would use sub queries, would that be flexible enough for you? I've added an additional column to the example posted earlier to demonstrate what I mean. I've...
January 10, 2017 at 7:56 am
The feature to look for is CDC (Change Data Capture). Introduced in SQL server 2012, it required an enterprise license, but in newer versions it is available in other (cheaper)...
January 10, 2017 at 4:33 am
Eirikur's solution can be made even faster if you specify in your xquery that you will only ever accept one root report-node per xml document.
DECLARE @XML_DATA XML = '
November 18, 2016 at 1:33 pm