Nice job, dealing with circular references in SSDT is a PITA!

This is some good stuff, nice work. Good alternative if you can't purchase a 3rd party tool.

SSMS for admin tasks, SSDT for development. The more I use SSDT the more I like it.

I'm right there with you, on the same path, working to get there.

I could write an article about it, not sure how much information I could give out though due to confidentiality agreements. We did have large SQL Server enterprise servers running...

Two instances in every store running on a physical server. Cloud wasn't an option at the time. No extra development costs.

I ran a 4700+ store retail chain on 9400 instances of SQL express. Microsoft loved me 😎

I think I figured it out, I was having some circular reference problems, I ended up having to build the dac pac of one of the databases and using that...

I believe this is sort of what I was looking for, let me test this one out and see how it performs. I'll let you know what I find. Thanks

I know for this example the stock_nbr_ky values are the same but they won't always be

I believe part of the problem has to do with the OR in the WHERE clause, removing it gives me a better plan that runs in subseconds.

select

stockNew.stock_nbr_ky as stock_nbr_ky_new,

stockOld.stock_nbr AS...

The legendary ScaryDBA! I'm a big fan of your distilled tuning book and Red Gate in general. Thanks the for the help. My thoughts were in line with yours, I...

nice article

same error