BTW, I see lots of generalizations. I was hoping for specifics. Not every one but a specific example of a common mistake. Perhaps like using NOLOCK everywhere or *= in...

Reminds me of watching my son's Knowledge Bowl competition this...

I hope so. No unmanaged code if possible.

GilaMonster (3/18/2015)

---

Jack Corbett (3/18/2015)

---

That was an interesting read. I can't disagree with any of it, but I can honestly...

It's an unsupported upgrade path: https://msdn.microsoft.com/en-us/library/ms143393%28v=sql.105%29.aspx

I'd just install 2008R2 Standard and move the dbs/logins/jobs/linked servers over. Only if I have a license to 2008R2.

If you need a new license to...

You can use datepart to extract the month, and day, and then concatenate them together.

cast( datepart(mm, mydatecolumn) as char(2)) + '/' + cast( datepart(dd, mydatecolumn) as char(2))

For your discussion: https://medium.com/@sailorhg/coding-like-a-girl-595b90791cce

I didn't think we cached the forum pages, but perhaps we do. I'll ask someone to flip through the code and see.

I see it on this page: http://www.sqlservercentral.com/Forums/Forum391-1.aspx

eddy.b (3/18/2015)

---

It is quite odd to see your responses when working in Bioinformatics. Computational biology / bioinformatics started in the seventies, and statistics has always played a very important role...

Thanks, I'll take a look.

That's a fair statement and good suggestion. Part of the issue is having enough experience with an ORM (or multiples) to suggest things.

I'll see what I can do in terms...

I want to ask this as well. Specifically with...

Gary Varga (3/16/2015)

---

I am all in favour of bringing all options to the table but sincerely hope that we do not allow statistics to start to rule medical science. I...

Perhaps, but that's still just a storage design for the data. I bet there are some interesting queries written...