marcosc (10/21/2010)

---

Great article !

I only disagree with the conclusion

because you've showed that...

peter-757102 (10/21/2010)

---

cfradenburg (10/21/2010)

---

Interesting point about how the query optimizer works but I'm more with...

Here is a query I wrote for SQL Server 2008 and its problably good for 2005 as well. For every untrusted foreign key it generates a small script of either...

cfradenburg (10/21/2010)

---

Interesting point about how the query optimizer works but I'm more with Garima....

Unfortunatly it turns out that untrusted check constrains will not always become trusted after altering the contraint as is done in this article. If you find yourself in this situation,...

peterzeke (9/13/2010)

---

peter-757102 (9/13/2010)

---

Why would charity be totally unpaid for, isn't that unrealistic?

I can accept it will be a bare minimum if its true charity and not one of those big...

Why would charity be totally unpaid for, isn't that unrealistic?

I can accept it will be a bare minimum if its true charity and not one of those big aid organisations...

Me likes 🙂

Paul White NZ,

That link you posted doesn't work anymore, but I found the article (working link below).

http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/01/21/denormalizing-to-enforce-business-rules-part-1.aspx

I think that implementing running totals high performance style brings you to techniques that cannot just be copy/pasted by anyone. You have to understanding of how and why it works...

The age of true programming started the moment the first MICRO-Computers apeared in the shops. This is the moment in computer history where suddenly masses of people could afford and...

LIYA (9/1/2010)

---

Hi Peter,

The query is working fine; the only disadvantage is its execution time. It took long time to execute.

David's solution is much faster as compared to this....

dhamilton-905368 (9/1/2010)

---

It is all really about how "programming" has progressed so far that it is now closer to a true, measureable, science compared to the witchcraft some of us [you]...

As I remember it, the restrictive meaning of a programmer was invented in the early days of computing where organizations/academics wanted to differentiate between the various “specialized tasks” in computing....

LIYA (9/1/2010)

---

Thank u for your Help. This query helps me lot. but still have some problem.

for example i have an output with above query

EMPIDInTime ...