Hi Harcharan,

DBCC SHRINKDATABASE will shrink the database files, not the tables in the database.  To do that, SQL Server may move your data around.  This is one reason why this...

Hi Jeri,

Are you saying that you want to change the character set and collation for each of the 70 databases, or that you just want to change the default settings...

First of all, you shouldn't have to separately backup and truncate the logs.  Just schedule regular log backups, and allocate sufficient space for your log files.  The log files won't...

Hey MCT,

We feel your pain, and I'm sorry you lost your 100%.     But at least it got you to post! 

Jamie,

Thanks for the kind words.  I think that the topic of portable (ANSI) SQL versus vendor-extended ANSI SQL is a good one.  I guess there are two different articles being...

I agree with Antares that we should file a bug report, but ... anybody got one handy?  I'm almost inclined to sit on it, since it's so easy to work...

So, I've gotta ask ... are Rayven and Razvan really two different people? 

-C

Hi Beulah,

What you are saying is theoretically correct (although it does rely on a certain interpretation of the ANSI standard for ORDER BY clauses, according to one prior post in...

Troy (again),

As an add-on to my previous comment, when a client re-sorts data, I view that (wearing my SQL-is-not-fully-relational hat) almost the same as another step in a distributed showplan,...

Hi Troy,

I guess I always carry around in the back of my mind that although I learned all this stuff about relations and relational algebra and relational calculus, etc., in...

TroyK wrote:

Remember, people, that a mathematical set has no ordering. The ordering behavior we see is an attribute of the _presentation_ of the results, not an attribute of the results...

DISCLAIMER: PLEASE PARK YOUR PRECONCEPTIONS AT THE DOOR.    I think there is something interesting going on here, but if you come in here...

The reason that you can't change databases in the Query Analyzer dropdown when FMTONLY is on is that the dropdown is as follows.  When you click this dropdown, the Query...

Don said:

Thanks to all who have contributed. I have learned something new about human nature, if nothing else. DBA's do not like to be wrong.