Ed Wagner (2/27/2016)

---

Sean Lange (2/26/2016)

---

Alan.B (2/26/2016)

---

Sean Lange (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe...

Great article Steve. Nothing to add with respect to the algorithm discussion...

Many of us realize that subtle changes in application code can cause issues for data, which is part of...

Jeff Moden (2/27/2016)

---

Outstanding article, Steve. I'd discuss it a bit more but, being a customer/consumer of software, I would tick off the whole world with my thoughts in this...

Sean Lange (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more...

Lynn Pettis (2/26/2016)

---

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more candidates for...

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more candidates for a position when...

djj (2/25/2016)

---

Spent a couple hours rewriting a query that was taking 4 hours. Got it down to 8 minutes! Then the light bulb goes off and I realize...

+1

Cracked me up!

Ok, here we go. This may be a bit much to follow but the key take away is that I'm showing you an excellent alternative to NTILE using a tally...

If you can get away with using a stored procedure then that's the way to go. Scalar UDFs are almost always poor performers and should be avoided at all costs.

Just a quick update:

I have a good solution that I'm still testing (note my earlier comment). It has taken me longer than expected. I'll try to post it in the...

EdgeOfKnowWare (2/23/2016)

---

Rich Mechaber (2/23/2016)

---

Hi, Alan, o/p here, and I've enjoyed the follow-on conversation I started.

This aspect of NTILE() is an eye-opening piece of information, thank you for posting...

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then came...

SSC is the right place 😉

If your table had 92 million records, and you had 9 different "Val" columns, would you still use the same code?...

Note my code and comments.

USE tempdb

GO

-- Create a table with an XML column

IF OBJECT_ID('tempdb.dbo.YourTable') IS NOT NULL DROP TABLE dbo.YourTable;

CREATE TABLE dbo.YourTable(SomeID int identity primary key, SomeXML xml NOT...