Eric M Russell (1/15/2015)

---

Robert.Sterbal (1/14/2015)

---

I think some of those geeks would also say that they want to supplant Microsoft licensing from their data.

Microsoft handles the needs of small numbers...

maybe schedule a job in windows task scheduler that runs a query? could use sqlcmd, or a small dot net program.

I agree with this. Many...

You could just limit the monthids that you're cross joining with.

Alexander Suprun (1/7/2015)

---

Grant Fritchey (1/7/2015)

---

syquil (1/7/2015)

---

That was a good chuckle. Thank you for that.

Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit?...

sgmunson (12/31/2014)

---

Thanks fpr the info. Interesting that someone coined the term "DAS", because while SATA or e-SATA would qualify under that umbrella, so would a USB attached drive,...

sgmunson (12/30/2014)

---

Okay Scott... what, exactly, is "DAS" ? I'm usually in a contract role, and usually for long enough that I don't stay in one place for...

really helps to have that ready to go ddl so we can test solutions. here's a query I like, might not have the efficiency of "apply" methods and of course...

run checkdb on your databases!

David Rueter (12/19/2014)

---

patrickmcginnis59 10839 (12/19/2014)

---

David Rueter (12/18/2014)

---

For example, if HTML included something like <a href="getRecord?id=6">Click for details</a> it would be trivial for a malicious user to call "getRecord?id=5" to retrieve...

David Rueter (12/18/2014)

---

For example, if HTML included something like <a href="getRecord?id=6">Click for details</a> it would be trivial for a malicious user to call "getRecord?id=5" to retrieve data he is not...

Thanks for posting your conclusion as a followup, interesting stuff!

gene-683843 (12/18/2014)

---

I have always held the opinion that the use of an artificial PK for database table design (GUID or otherwise) is a lazy way to maintain uniqueness of data....

codykonior (12/17/2014)

---

Imagine the following imaginary scenario:

- A database in SIMPLE mode.

- A table with a 10TB clustered primary key that is 99% fragmented.

- A disk with plenty of log space...

Grant Fritchey (12/15/2014)

---

patrickmcginnis59 10839 (12/15/2014)

---

Grant Fritchey (12/15/2014)

---

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use your bosses...