I had to do this as well, so you get my supply of bookmarks to help you on your way:

http://www.sqlmag.com/article/tsql3/calculating-the-median-gets-simpler-in-sql-server-2005

http://sqlblog.com/blogs/adam_machanic/archive/2006/12/18/medians-row-numbers-and-performance.aspx

http://sqlblog.com/blogs/peter_debetta/archive/2006/12/20/Medians_Actual_Query_Cost_and_Statistics.aspx

The first one by Itzik Ben-Gan is the one I used.

And...

FYI: the "I" in the original paper stood for "Inexpensive":

http://www-2.cs.cmu.edu/~garth/RAIDpaper/Patterson88.pdf

Rich

GSquared (12/18/2012)

---

Upload the picture using the Edit Attachments button below the editing window. Then use the link for that.

(If you Quote my post, you'll see how I formatted the...

Also, there's a small typo. I just found in the provided answer:

the catalog view has an underscore: sys.sql_modules, missing in the answer.

Rich

So, as a follow-up question to this somewhat unfortunately worded but very useful QotD: is there a way to query system views to find SPs, renamed with sp_rename, whose sp_helptext...

Jeff Moden (12/3/2012)

---

It IS "old school"... and I love it...

I use this VBS script (it works, please don't tell me that's old school) I wrote to do exactly that.

As explained in the comments, one benefit of this over a...

Brent Ozar has some good information on using VMWare and SQL Server: http://www.brentozar.com/archive/2011/05/keys-deploying-sql-server-on-vmware/[/url]. Note this point on his Top Ten List:

8. Avoid 1Gb iSCSI for storage. While this cheap...

Answer says "We can't delete rows from the primary table if the secondary table contains referential rows. " but the submitter's own linked explanation correctly includes what happens with ON...

L' Eomot Inversé (11/28/2012)

---

So now we have some rather bizarre behaviours: one of these 9 statements is not, according to profiler, a statement. Neither is it, acording to estimated...

seankyleprice (11/27/2012)

---

Given that the nullability of the column wasn't explicitly specified (a personal bugbear of mine) surely the answer depends on the setting for 'ANSI null default' on tempdb and...

Hugo Kornelis (11/19/2012)

---

rmechaber (11/19/2012)

---

But I "like" this because it shows up a terrible disdain in SQL Server for handling basic mathematics under certain circumstances. I don't like the "it's...

I'll take a slightly different approach in my reply: I think this is a great question.

Not because the original answer explains the oddity of rounding -- it doesn't.

But I "like"...

subramani.rudrappa 78855 (11/16/2012)

---

Hey Hi,

I know we can use SSIS to get data from excel and load in to SQL table from where i can achieve requirements.

I thought of using only...

Neil Thomas (11/16/2012)

---

I'm obviously having a dense Friday.

How does the explanation (all about @@error) relate to the question: "What is returned from #tblTrans when you run the below code:"...?

I'm not...