roger.plowman (12/27/2016)

---

Syntactic sugar actually refers to the tokens added to make the *compiler's* job easier, like the ; in C to end lines. I think the term you're looking for...

Jeff Moden (12/21/2016)

---

No, Sir. I know what...

Indianrock (12/17/2016)

---

Here is what much of our ORM code is based off of:

[/url] The author used to work for us but apparently hasn't updated it...

Indianrock (12/14/2016)

---

Yes ORM-generated sql. Ours is a version called Domain Objects written by a former developer here. Others include Entity Framework and Hibernate. That sql code...

I like Martin Fowler's take on ORM's, and given the lack of mainstream pedigree of "Domain Objects" I think Mr. Fowler's discussion on this is particularily apt for this case....

Indianrock (12/14/2016)

---

Yes ORM-generated sql. Ours is a version called Domain Objects written by a former developer here. Others include Entity Framework and Hibernate. That sql code...

we are altering the thread. pray we do not alter it any further.

TheSQLGuru (12/13/2016)

---

patrickmcginnis59 10839 (12/13/2016)

---

TheSQLGuru (12/13/2016)

---

A) Regarding index reorg, I don't think you get "random crap in your database" because of it while running NOLOCK SELECTs. You may get committed bad...

TheSQLGuru (12/13/2016)

---

A) Regarding index reorg, I don't think you get "random crap in your database" because of it while running NOLOCK SELECTs. You may get committed bad data OUT on...

Alan.B (12/9/2016)

---

Indianrock (12/9/2016)

---

I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart so don't use plan guides, query...

reminds me of netscape the browser and company.

https://www.joelonsoftware.com/2000/04/06/things-you-should-never-do-part-i/

I generally opt for the 'scrap and start over' approach. Building on a poor foundation is not a good practice, and if I must dig all the way down to...

You'd get a better idea if you'd actually write some tests, one theme you'll see often here is that folks are much more interested in measuring than estimating.

But I'll guess...

This link has helped me understand strategies for linked servers (and it might be that openquery to remote servers might be impacted also).

http://sqlblog.com/blogs/linchi_shea/archive/2010/12/01/linked-server-and-performance-impact-direction-matters.aspx

Bottom line, faster to select from remote servers...

djackson 22568 (11/17/2016)

---

peter.row (11/17/2016)

---

djackson 22568 (11/17/2016)

---

Good decision? I think so. ...