Sounds to me that you have a whole data scrubbing process to handle before even worrying about the DW. We unfortunately have a whole set of DB's dedicated to just...

Auto-grow happens every time the log file runs out of room. So - if it's out of room at 12 noon it's not going to wait until after hours...

...and how exactly is this better than an identity? Sequence tables are evil in my book...:D

Jeff Moden (2/28/2008)

Ummmm.... not sure what you mean by an "index computed column".......

Your first syntax is also missing a parenthesis if I am not badly mistaken. If anything is dragging it down - it's the use of the subquery in the...

... which is why you encapsulate it within a sp_execSQL call. The script within Sp_execsql runs within its own scope, and therefore meets the "within its own batch" rule.

Want...

someone call a medic....I'm choking over here.......:hehe::cool::w00t:;):P:D:):blush:

Stop it....I'm crying!!!!

It's always good to give credit where credit is due. Now - it's just a matter of passing said good ideas along...

Now we can really say:

"Inspected by #77"....;)

The cleanest way is to usually just use a secondary column.

1. create a new column of type Datetime in your table

2. update the new column with data from s_DOB

3. drop...

Take a page out of the playbook used in the Generate SCripts functionality. In order to do that - put the create procedure script into a sp_execSQL command (make...

Oh - I understand the concept you're looking at - but you're using ADO terminology, and I'm not sure there's a way to leverage that within DTS.

What the heck is it that you're showing in the last test? a repeating pattern with 2.29M rows affected? It's a low caffeine part of the day -...

Trader - just print the @sql first - your error will likely pop right up at ya... If you don't see it - paste it into a new query...

Two possibilities:

1. use SSIS. your source would be Prod, your destination would be Test. You can then use a lookup and a conditional split to...

SAN's are large sets of disks. How they're organized is a question for whoever designed the SAN solution for your org.

Partitioning your tables may or may not send them...