I had to deal with ADT's in a previous nightmare job. Oh what a total pain it was! Just use the system types. The biggest pain was having to script...

To not use FKs in an OLTP with any level of complexity is just plain ignorant. There is no excuse for it, and you will just get badly burned. Amazingly...

Why would anyone have a clustered index on an NVARCHAR(341) column? Just curious because this is a main part of the problem to begin with. Hopefully this does not get...

Wow, this is really disappointing. I hadn't yet tested much with CTE's on the performance, as the db I am working with now is relatively small, but I just kind...

It's worth every penny. Heck, even just for having every database developers code be readable and in the same format / capitalization, etc.

BOL states that I can run a script as a parameter to sqlcmd:

sqlcmd -i C:\MyFolder\MyScript.sql -o C:\MyFolder\MyOutput.txt

Not sure why that is incorrect as an answer?

-Vic

A person willingly agreeing to employment terms with Wal Mart hardly rises to the "exploitation" level by the employer.

OK, touche gentleman, we agree to disagree.

-Vic

Then those people that are getting shammed at Wal Mart should look elsewhere for employment. It's a free market, go elsewhere! Don't blame Wal Mart because they may pay less...

Envy of success, pure and simple. Wal Mart thrives in this beautiful CAPITALIST country we have here and people (especially liberals), just don't like it. Long live Wal Mart, a...

I get a syntax error in 2005 with any of these 4 commands. The "correct" one gives this error:

Incorrect syntax near the keyword 'order'.

I don't think...

Can we rename this, "How To Mess Up An ARTICLE"? Your advice is quite offensive to me as a Christian. Yes, I agree that it is good to keep my...

I am no expert and I am learning it myself (seeing as I couldn't even create certificate until now :&gt ), but they are...

That's the ticket! Thanks Chris.

While I agree it is the correct answer, the actual command does not work with the April CTP. You get an error: Incorrect syntax near 'ENCRYPTION_PASSWORD'. A little checking on...

Exactly!!! Uh, just WHICH Birmingham are we talking about here?     -Vic