Who knows. As long as you look busy, probably still have a job!

I think IT is still in demand. Part of the issue is that as people leave, there are...

I keep getting ready to write about this and every week, sometimes twice a week, I get an article that goes one way or the other.

I'm starting to think that...

First, this is really a T-SQL questions, I've moved it to that forum.

Second, you are returning the narratives, so you get distinct rows. If you don't want the narratives shown,...

On CRTs, to product light takes energy, black is less power.

On LCDs, all colors require energy, so Blackle doesn't really help, especially over time. It was a good idea years...

I heard from Apress and they are trying to get more books on the Kindle. Delays because of code formatting, but it will get there.

Good to hear opinions, especially from...

you need to devise an algorithm that determines the version flag based on the inputs.

This sounds like homework. If you show an attempt and explain what you want to...

http://support.microsoft.com/kb/274750

In Denver, CO, USA, I'd say 4 years of experience would net you in the 60-70k range. After 6-8 years, I'd say you should be in the 80s.

I think the index command gets replicated, so the subscribers will rebuild indexes as well. Shouldn't hurt, but you should be aware the subscribers will run this.

Thanks for the notes and I'm trying to watch them a bit more closely. Lots of people have submitted some and I'm editing a bit, but remember that this is...

Are you sure? got some job security at 500ft down and starting a deployment. Not like to get pink slipped for a few months out there :hehe:

Use charindex/patindex to find the decimal point, then subsctring to remove it. Concatenate the before decimal point with the after.

Do you every clear cache? I wouldn't think this would ever happen except at restart.

Not sure there's a DMV tracking restart, but you can read the log for the...

OPENQUERY or SSIS, but move the data.

Don't leave it in that old, out-dated Oracle system 😉

Is this regularly or one-time? Does the data move ad-hoc? SSIS is quick and works...

Those fellow worker are even more of a reason to separate stuff. Those guys/gals are dangerous!

I'd still argue with you, but you're not making a mistake. I think I'm just...