The nice thing is that deprecated features last for a couple versions. DTS was announced as deprecation in 2005, it's stil there in 2008.

I'm not sure why features get deprecated....

You're welcome and glad you liked it.

Some great comments in here.

Can you give an example, or a few? It's not clear what you mean.

You also might want to check out datepart, which can get you different parts of a date,...

Also, dividing the database among servers might not work. It depends on your application.

You probably should hire a consultant to evaluate performance and help you improve the speed at which...

Keep in mind if you did move to database snapshots that the snapshots are point in time and don't keep up with changes to the primary.

It's possible that they are. the reason is that read aheads, scans of indexes or heaps, etc., don't take place in contiguous order, at least not outside 10MB. Any extents...

Did you follow instructions here? http://support.microsoft.com/kb/224071

Or you can store as varchar. Are these part numbers or something? If you don't do addition, or even if you do, I might store as character data.

I can see your argument, but the question doesn't ever come close to specifying columns. It specifies values and shows a query on one column.

This is to learn and for...

Is the user's login mapped correctly as well?

Read baarf and think about your environment. If you have lots of reads, I'd go with R1 or R10 for data, get the speed up there. You definitely want separate...

You can change it manually, it would take time, but it's probably the best way to do this. If it's not every table, and a common pattern, a script could...

This is a complicated subject and we can't necessarily give you a complete explanation on encryption. I'd suggest you read in BOL and articles on building encryption into an application....

Agree with above. Do it after.

Wither you have to pass all values, or unpassed values need defaults in the stored procedure definition.

You can specify specific parameters as

exec mystoredproc @param2 = 4, @param4 = 65

But if...