I'm going to suggest that the suggested example website of amateur data analysis (http://devnambi.com/2015/uc-analysis/) is a good example of well-intentioned BI off the rails.

1. This Smacks of a Rhetorical...

Another thing to watch out for: sending email from inside a trigger is generally considered a bad idea. Ideally, you want your triggers to execute quickly and stop holding...

WayneS (8/11/2015)

---

We've known how to stop SQL Injection for over a decade now. I'd be curious to know others thoughts as to why they think that SQL Injection is still...

Yeah, well, be careful using STR() to convert from FLOAT to VARCHAR(), too:

http://www.sqlservercentral.com/questions/T-SQL/94788/[/url]

Rich

Setting aside the question of clustering key for the moment, which others here have already taken up, I would ask whether your assumption of having an 8-column natural key is,...

TomThomson (8/1/2015)

---

Jeff Moden (7/31/2015)

---

jghali (7/31/2015)

---

WOW! do I feel silly! I actually thought it was an actual thread...

Note to self: Always look at the date before posting!!! :hehe:

Did you ever...

Here's a nice, straightforward -- but perhaps fuller -- explanation of what's going on here if you're still puzzled:

https://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/[/url]

EDIT: URL corrected for the web-friendly version of the page instead of...

TheSQLGuru (7/17/2015)

---

rmechaber (7/17/2015)

---

Another perspective: do you actually need to store the subtotal in the OrderHeader table?

This could be computed on-the-fly using views or stored procedures from the actual order details,...

Another perspective: do you actually need to store the subtotal in the OrderHeader table?

This could be computed on-the-fly using views or stored procedures from the actual order details, right? ...

Steve Jones - SSC Editor (7/6/2015)

---

Stephen Hirsch (7/6/2015)

---

The problem is that the people who use the tools aren't the ones who buy the tools. People who use tools aren't nearly...

Jeff Moden (7/15/2015)

---

rmechaber (7/15/2015)

---

Jeff Moden (7/15/2015)

---

Everytime I see that particular post, I can't help but ask why someone would spend so much...

Jeff Moden (7/15/2015)

---

Everytime I see that particular post, I can't help but ask why someone would spend so much time and effort...

"Wrong" but not wrong: CURRENT_TIMESTAMP takes no arguments, the others require them (or empty parentheses at least).

But I bit on this vague QotD anyway, so maybe I was wrong to...

Echoing what Nate said above, this also happens if you create a VIEW as SELECT * FROM MyTable and then later add columns to MyTable: the VIEW will not return...

Does this app/database have any VARBINARY(MAX) columns?

Your demonstration that SELECT * is a resource hog will be made as forcefully as a.... high velocity pork chop. 🙂

Rich