Alan.B (2/23/2016)

---

With that in mind, for 92 million rows I would most certainly do it differently. Of the 4 "ranking" functions (ROW_NUMBER(), RANK, DENSE_RANK and NTILE) NTILE is irrefutably the...

Sean Lange (2/23/2016)

---

Ed Wagner (2/23/2016)

---

That is interesting,...

I cried.

("qq")

Rich

As noted, you can't do the INSERT if a key violation occurs. That's why you have keys! 😉

Not sure what your application/purpose here is, but if it's some kind...

Hi, Phil, my memory is that this was rather involved when I implemented this a few years ago. Jonathan Kehayias had a nice write-up about how to do that here:...

Call me old fashioned: I like CTRL-SHFT-C and CTRL-SHFT-R for commenting/remove commenting blocks of text. Frustrated me no end when this changed.

Here's how to get them back: http://thebakingdba.blogspot.com/2012/10/ssms-2012-getting-my-ctrlshiftc-back.html

Slightly off-topic...

And here I thought SETUSER was something Steve...

patrickmcginnis59 10839 (2/9/2016)

---

Rich Mechaber (2/9/2016)

---

Steve Jones - SSC Editor (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A...

Steve Jones - SSC Editor (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions...

David.Poole (2/9/2016)

---

I heard a story that an analysis of coin composition revealed the state of a nation's armament capability.

Data is like fissile material. Once it gains critical mass it's...

Summing up what you've heard from a lot of different people (with more experience than I) about a lot of different products, I would offer this observation:

If you use SQL...

Good question, thanks. I guess the safest and most obvious course would always be to conclude there might be corruption after an event like that and to run DBCC...

Second column? What second column??? :ermm:

Aaaaaand that's why I was confused. Missed that completely. Hope that's...

I'm sorry, I must be very dull today, but I don't understand how any rows are inserted by the INSERT statements when the primary key is an IDENTITY(1,1), regardless of...

David, if you find a good solution to this question, please post it back here. I am also struggling with the lack of session-specific temp tables in Oracle to...