I'm not entirely clear what you want, but there is a parameter for datepart that can give you the week of the year. You could include that in your...

I tend not to worry about most of them. You could have processes that are connected for a long time, so I wouldn't worry about that. I think that's left...

If the trigger fails, you will not likely be able to send a message since it will roll back. Potentially you could send mail, but not necessarily.

I would recommend...

If you have separate hardware, use the side by side. That way you can roll back if you have issues.

Exam 70-448 is what you need for the MCITP in BI: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us

Both my wife and I have tried staying at home at different times. It was hard for both of us, neither of us was well suited for it, and fortunately...

Gail is correct. You don't want to do this, and the database will grow as you add data. Would you expect anything else?

You want to manage space. You need a...

Thanks for the notes, and it was a nice day yesterday. Alvin wins a prize, but everyone is appreciated.

Plus beer's and BBQ are on Alvin when anyone's in Memphis for...

Dizzy Desi (10/7/2010)

---

TravisDBA (10/7/2010)

---

I disagree Jessica, the world just doesn't work that way. Ideally, it should, but it just doesn't, and as long as human nature is in the equation...

1,000,000

:hehe::hehe:

I personally would lean towards SSIS since I think it allows you more choices about what to do, and better control over security, but bulk insert will work fine.

I like...

Thanks, everyone, and thank you are well for posting here, helping others, and building a great community where we can spend a few minutes with each other during our careers.

I...

Thanks, Jessica, for a well written editorial.

Alvin,

Congrats again, and check your email. I sent you a little something as a prize for hitting the mark.

Well, it wasn't me, Jeff, or Gail. It was Alvin that hit it, so congrats.