Most of my pet peeves have already been mentioned here and it was almost always caused by the developers not caring about the database when they were developing. Not every...

I don't really see the point of table variables.
How are they an improvement on temporary tables? Is the absence of CREATE TABLE (or INTO, if you that way inclined)...

Hi Jeff,
I will indeed read up on it.
Thanks for the very prompt reply,
Sean.

I'm preparing a pilot-study on Full-Text Search and this script will go part of the way towards it. The extended procedure master.dbo.xp_DirTree will be useful anyway.
The aim is to...

I've thought about the cost of switching too.

It comes down to resources.
If you have time, say 5 years and some people (DBAs, developers & sysadmins) whose time...

I've often wondered as to whether the model of offering university students (or even prospective university students) a starting position in a company with half of the university tuition covered...

In regards to training, I can't really complain. The company has a budget for training set aside every year and for this I am thankful.

 Often though, I'd...

I do agree with you Andy. Find the tools that make your life easier and make sense to you. I love SQL Prompt, for example, while others on my team...

For all of those new to SQL in our DBA team, I recommend two books for them to practice on.

 The first is immediate and short-to-medium term. It is...

Apparently, one may not wear white after Labor Day. I'm sure that there are good reasons for this Verbot.

I've worked in open-plan offices for the last 25 years.

 My first real job was in a school in Japan and the Japanese showed me how open-plan should work....

Nor I.