Aaron N. Cutshall (4/11/2011)

---

Thanks Eric! I'll try that out and let you know although it will be a while before I do since I'm getting ready to go on...

Once a smart team of engineers create a really practical piece of technology, it's inevitable that the consumer marketing industry will come along behind them, FUBAR the technology, and then...

Aaron N. Cutshall (4/11/2011)

---

I couldn't agree with you more! That sucker is HUGE...

If I need to generate a unique sequential integer IDs for transactional records (for example sale_id or customer_id), then I'll use an identity. I call that an instance ID. However,...

Martin Mason (4/7/2011)

---

magarity kerns (4/7/2011)

---

I think the first assertion needs a slight modification; a first version DW should produce one reporting subject area, not just one report. From there, it's...

There are a series of canned questions that should always be asked upfront, and these should be documented in the requirements. However, I also find it essential to ask the...

One caveat to using the ranking method is that each row is ranked dynamically...

Looking at your sample resultset above, it seems to me that the column SequenceNumber is derived...

Well, the good news is that you've got your work cut out for you and don't need to worry about getting laid off anytime soon.

In most large proprietary databases...

If you're not sure what to look for, then consider using the DTA (Database Engine Tuning Advisor) tool to analyze your query.

asterman_3 (4/4/2011)

---

Actually, I want to know whether it is possible to create a procedure from T-SQL on remote server, and than execute. Or, to create a SQL Job remotely (on...

You should create a procedure on the remote database...

One method is to create...

Steve Jones - SSC Editor (4/1/2011)

---

H-122523 (4/1/2011)

---

Hi Steve,

Interesting editorial, this, as it connects failure to probability.

In the end, we all make up the statistics; I just finished 'The Black...

If Joe's Bike Shop looses all their data without a backup, then that's a personal tragedy for their business, but it's not really a community or regional wide disaster. The...