I've been part of an A-team (twice actually), although not really because I wanted all kinds of lime light, more because some managers found my insight valuable on all kinds...

Pretty good article. Few things to remember about building DWs, one of which it seems you've already learned:

1. Avoid updates where possible. Inserts are many times faster. (which leads to...

Chris Hamam (12/15/2010)

---

Hugh Scott (12/14/2010)

---

amenjonathan (12/14/2010)

---

Thanks merlin for your reply and Hugh for this article. Looking forward to the next two installments.

Anybody have any idea what happens when you do...

Thanks merlin for your reply and Hugh for this article. Looking forward to the next two installments.

Anybody have any idea what happens when you do not add the partitioned column...

Are there any performance concerns when partitioning with a single filegroup apart from the restrictions on I/O increases from not using multiple disks? We're about to implement a partitioned table,...

For anyone still working on this, I found out how to pass the table name gathered in the ADO NET enumerator to the Excel source in the data flow.

1. Inside...

Ah here's the appropriate MERGE link. I've just built my version of the sproc, but am still testing it.

http://www.sqlservercentral.com/articles/MERGE/71396/[/url]

Thanks for the links. I'll definitely check them out.

Personally I still don't...

I guess I will concede to your view of cursors because I don't have time to take your challenge. I have read many articles on cursor vs set vs while...

I always use a while loop if I need to process RBAR.

Hugo Kornelis (11/17/2010)

---

Please explain.

Or, if we are just throwing terms without any...

Indexed views and triggers: two things to avoid if at all possible. Next up: Cursors are good! 😀

I prefer not to use triggers. IMO business logic is better stored elsewhere and in a less global fashion. Triggers are very heavy handed. Auditing triggers on a dev environment...

Nitya (10/19/2010)

---

The assumption that files coming in are of fixed length is little hard to generalize.

In that case the Configuration table values are hard to determine.

Great work in getting it...

Let's put the shoe on the other foot for a second (play some devil's advocet). Recently I attended my son's open house (or back to school, whichever comes first). Every...

JenMidnightDBA (10/6/2010)

---

amenjonathan (10/6/2010)

---

To be honest, I don't think there's a problem concerning women in IT. In general, women are not as attracted to engineering related professions as are men. Vice...