gyessql (1/16/2009)

---

But if he did go with...

Can you post the execution plan for the original query?

When you're not using it in a WHERE clause or a JOIN, COALESCE

gyessql (1/16/2009)

---

Grant Fritchey (1/16/2009)

---

You could make the Course and Unit pk into a compound PK that includes AccountId. Then the UnitCourse table will have an added column used as a...

You could make the Course and Unit pk into a compound PK that includes AccountId. Then the UnitCourse table will have an added column used as a constraint against each...

mike.sortino (1/16/2009)

---

I believe that there are solid arguments for both sides of this issue. It is nice and comforting to know that you are being paid fairly for what...

Yes,...

For all those people who want employees treated "fairly" you'll need to define "fair." Does it mean identical, in that, all DBA's are paid 30K? Does it work of seniority,...

If you're getting this sophisticated with dynamic SQL, then you really need to look into sp_executesql instead of simply using the exec statement. sp_executesql will allow you to define parameters...

I wish it was available online, but if you can track down the final copy of the SQL Standard, I wrote an article comparing TOP, MAX and ROW_NUMBER as a...

Regarding Performance: It depends, but yes, CROSS APPLY can be used in place of an INNER JOIN in some situations to realize a performance benefit. It's only going to work...

I'm hoping we can get it to 100 pages. Then it should die. Horribly. Suffering.

MarkusB (1/16/2009)

---

Resource Governor can only limit CPU and RAM usage for a workload group, you cannot use it to cancel queries after a certain time.

The only way to set...

No. I don't want to be angry at anyone becuase they're making more than I think they're worth and I don't want anyone angry at me for the same reason....

Really? What happens if you're updating more than one row? What about if you were updating 1/2...