Check out this article

What exactly is your question?

Are you doing the restore using Enterprise Manager or T-SQL in Query Analyser? If you are using EM can you run Profiler when you are doung the restore and...

I like it Jeff. I always forget about STUFF(). It's a great function.

Here is some code you can put in a Script Task that will find the value "ProductA" in the file and then set the Package Variable ProcessFile to either true...

It definitely won't work correctly for -360 offset as my code assumes that the offset is just whole hours with the first digit hours and the other 2 minutes. ...

Try wrapping the text in double-quotes.

="1,2,3,4,5"

Can you provide the code/expression you are using? What is the data type of the parameter?

I'd use NT Authority\System. You don't need\want network access so there is no reason to use Network Service.

This is a step that was missing in earlier versions which is...

Gail's example for turning off Auto Update stats is a good one. I've never worked on a system that was big or busy enough that you would want to...

Oooh, this sounds like fun.

What does a date look like if it is +? Is the "-" changed to a '+'?

I'd do the conversion like you are doing, then convert...

Typically for a primary key you want to select the column(s) that uniquely identify the entity and that will be used to JOIN to that table. Also, I'd like...

Thanks, but I...

Hey you folks who are going to write the book on indexing. How about helping this guy out?

Sounds like you may not have the best clustered index key. I'd recommend reading this blog post by Kimberly Tripp as it does a good job defining what makes...