I knew it. The author's answer to this question was wrong.

I knew about the 2 bytes used at the end of a varchar or nvarchar, so I...

Thanks Jesse McLain for this question.

I surely learned something...

Myles Sigal (2/11/2009)

---

I agree with D. Couturier; if someone brought me code for review with comments anything close to this, I'd send it back. It's nice to know the...

This was a pretty good catch!

It got me :crazy:

Who the heck would use comments like that. I practice the KISS method which stands for "Keep It Simple...

Congratulation Steve, SQL Server Central & Red Gate.

-- Here is a nice query for you guys:

SELECT 'Congratulation to ' + PersonName + ' for the success of SQL Server Central.'

FROM...

Excellent article. CIA is the main purpose of a DBA.

All future DBA's and all managers of DBA should read this.

If my previous post doesn't work, I think you have no choice but to rebuild the entire database.

You can do to the following in replacement of bcp in/out.

Create a new...

You could try this if you haven't yet.

Script out all Primary Keys, Foreign Keys and Indexes.

Backup the actual Database files (stop SQL Server, copy data files and log files, restart...

I also agree.

These guys work hard to provide very good book for the IT community. Unless you get it free from the author himself, you are steeling...

After that book, go for the "Inside SQL Server 2005: T-SQL Programming". It's a continuation of the previous book.

It goes deeply into programming:

scripts, stored procedures, temporary tables,...

I'm presently at the last chapter of "Inside Microsoft SQL Server 2005: T-SQL Querying". It's an excellent book, a must have.

I've took some training with the author, Itzik Ben-Gan,...

I got the whole series of Inside Microsoft SQL Server 2005.

1- T-SQL Querying (Itzik Ben-Gan): Only one chapter left to read! I was already an expert in query tuning,...

I took some training last year on SQL Server 2005 with http://www.traininghott.ca/. I liked it.

I was originaly registered for the Montreal classes, but they cancelled...

I wouldn't be suprised that these wanabe DBA are trying to attach the Access database directly into SQL Server. But hey, I'm not here to judge anyone.

A quick and...

Thanks Grant,

I heard about Solid Quality Mentors.

I see on their site that they offer course named "Microsoft SQL Server Performance Tuning Bootcamp". The mentor is Randy Dyess....