I don't mind one time jobs, but don't have them delete right away. I want the history and being able to look in the short term.

We had a few one...

There is also this: http://www.sqlservercentral.com/articles/Indexing/68439/

Short answer: with no index(heap), the data is on pages/extents (8 pages). It's written as it comes in. Typically this means every 8 page extent of...

Ed Wagner (2/26/2016)

---

Sean Lange (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Hugo Kornelis (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been stuck in my head each morning this week... Sheena...

BOL does note this will return an error, but the "E" in the chart is very misleading. I'd say this is one of the poorer documentation efforts to not just...

I work with what I have. I don't have a wiki here, nor resources to...

Jeff Moden (2/26/2016)

---

Here's an interesting site by NANPA, the North American Numbering Plan Association.

It contains all of the active NPA/NXX combinations in various files (including one larger file that contains...

Added, and if you'd like to show how to get data from here and analyze..... 😀

Sector7G (2/26/2016)

---

Here's another list for healthcare data. This download contains info for healthcare providers. It includes name, business address, certification (MD, RN, LPN, etc.). The primary key...

That doesn't make sense. Breeds or colors.

How do you decide that item A (Pitbull) becomes Item B (Boxer)? I am guessing you assume that the ID is an order, and...

Good luck, and you are welcome. If you'd like to write up how you to this one thing, protecting this data, we'd love an article.

Steve

That's fine. Package protection is good. The important thing is that someone knows where the password is and how it's controlled. I might even think about having a non-business person...

You have to secure this somehow. There isn't a good way to do this, other than injection from the package or as a parameter. In either case, you then need...

Steven.Grzybowski (2/25/2016)

---

Eric M Russell (2/25/2016)

---

If we divide 1.5 PB (15,000,000,000,000,000) by the total number of global NetFlix accounts (60,000,000), that equals ~ 250 MB (250,000,000) of event data gathered daily...

Jeff Moden (2/25/2016)

---

Apparently, all that predictive analysis with a PB per day didn't do squat for Netflix. Their stock dropped from a high of ~131 on 4 Dec 2015...

Michael Meierruth (2/25/2016)

---

Maybe the birth of hadoop was motivated by the Netflix contest back in 2006.

I drove into this contest with immense passion and I remember doing lots of things...