Not sure I need any ideas on this one. I ensure I am not even able to check work emails during time off. Not once have I ever done so...

Elliott Whitlow (11/23/2011)

I've worked in small to ginormous organizations and without exception I've seen shody business requirements in all of them. The ones who say "here do it" are...

If you don't want to fix someone's computer - you can always use the Dilbert comeback - sure I'll fix your computer - when you have mown my lawn...

Mmm, I have not entered becuase I am lazy but also because if won I would have to take the cash alternative - I think my wife would rightly...

There are various times in my career when I should certainly have heeded Phil's advice, enough said. I think I have learnt perhaps the hard way that the only person...

SQL Kiwi (11/1/2011)

---

call.copse (11/1/2011)

---

I occassionally use an EAV type thing for very limited cases (storing central control variables that may vary by territory say) - is SQL_VARIANT a good move...

I appreciate the extra flexibility of SSIS (over DTS) but my main complaint is it is very tender. Meaning, things that would have been passed over in DTS (say very...

Darn, I jumped wrong there, I guess it is because I just didn't think about it. Not really gone for the concept of DDL triggers much yet so just selected...

Hugo Kornelis (11/1/2011)

---

SQL Kiwi (11/1/2011)

---

Hugo Kornelis (11/1/2011)

---

Great question, Paul!!

Can I interpret this as "Your production code will likely completely avoid...

I am not convinced there is that much gain to be made by taking action which demonstrates lack of trust in staff. Anyone in a dev or DBA position is...

Wot DugyC sed. Fortunately I overrode my immediate impulse to get this one right!

Nice one. I got it right - yay! - though I had to spend 20 minutes reading up (sorry work) first, as I was determined to get it right.

I think...

I am definitely lucky to have a job I enjoy, and one that pays top end of the payscale - and when I start to not enjoy it then I...

I think there are more complex cases where you need to do the kind of thing discussed in the question - using a subquery - but I did immediately think...

Probably about 5 on 2000 and a similar number on 2005, a couple set up on 2008, although we have not got many real projects running on 2008 yet, mainly...