Binary1010 (3/3/2010)

---

My favorite example of a terrible pricing "scheme" is a vendor (won't name names...it's not microsoft) that wanted to charge us first for the software on a per user...

Alvin Ramard (3/3/2010)

---

GabyYYZ (3/3/2010)

---

Alvin Ramard (3/1/2010)

---

...

Most of the talk that I heard about medal standings referred to total medal count, not the number of gold medal. I think it...

Alvin Ramard (3/1/2010)

---

...

Most of the talk that I heard about medal standings referred to total medal count, not the number of gold medal. I think it would make more...

Paul White (3/1/2010)

---

GabyYYZ (3/1/2010)

---

One option, especially if you have an indexed identity column on your source table, is to generate a separate table of random row numbers, create a clustered...

arr.nagaraj (3/2/2010)

---

Not too sure whether I got your question correct, But anyways thought of asking this.

Did you try disabling the Non clustered index during the pruning process and then enabling...

If NEWSEQUENTIALID() is the default...

Neil Franken (3/1/2010)

---

Hi There

Cool article but here is what I have found with newid().

...

Right lets say the profile(salary) matches 1,5 million rows in the database. SQL server will return all...

Thanks everyone for their help, and...

really? I was under the impression that PCI meant I couldn't see the data at all during routine maintenance...Hmm...this could make things interesting.

You know, sometimes I feel like recommending people use MS Access. (I have a headache...where's my sledgehammer?)

Timothy Graffham (1/25/2010)

---

You might consider removing the wildcards from the dynamic sql and allow them to be specified in the search string. That way, you could explicitly specify left...

I have a colleague working on a side project to search all columns for any errant information that looks like a credit card and I was wondering if there are...

See signature... 🙂

Greg Edwards-268690 (1/6/2010)

---

GabyYYZ (1/6/2010)

---

Kit G (1/6/2010)

---

GilaMonster (1/6/2010)

---

I have a set, if you need me to do a...

tskelley (1/6/2010)

---

Thanks, great script. And yes, SQL 2005 or higher. I am one of those dinosaurs that still defaults to SQL2000 to keep customer backward compatibility.

As for the...