Forget Query Analyser.  You can admin your 2000 servers from Management Service and far better.   See that button that says "script this"?  ANYTHING you do - press that button -...

Dunno if you're still reading this but -

I haven't tried it yet on our system, but can't you install the x86 OLEDB for Sybase and it will run in 32...

It's unlikely to improve your exellent cache ratio, if the page life expectancy is reasonable (as Jeff Gray mentions), that's no reason to do it.

I will give you reasons to...

Since folks are casting around for the "more than one way to do it" - my tendency would be to use perl and sqsh.   Has the advantage of working equally...

Good set of rules - let me add one more: "Keep in mind that different implementors will implement NULLS in different ways: a practical reason to avoid them."  I maintain...

Gosh, of all the database sites I like your layout the best.   Content is frequently good (not always a given in the MSSQL Server world.

More than anything, I'd like more...

Being asked the question wouldn't bother me - but being asked to do it in 5 minutes or less would have me headed to the door.   That's like measuring productivity...

Actually, I *don't* know of any issue in loading any particular characters.  The notion of "special" characters is hardly relevant to a modern dataserver: what's so special about one character...

It's tough to give a specific answer without more specifics: let me see if I understand your issue: your data has the same character in it as you are using...

There's no one answer.  Depends on what you are doing, what the HA situation is, and how much support is available.

In my shop, I try to insist that any daemons...

The lack of a decent shell in Windows is a killer.   appropos newline would have shown you "unix2dos".  

tr couild have done it.   For a custom solution, I'd almost certainly...

Tim, I don't know if this would be within your SMB budget (I work for a "SMB" but we're on the large side of "M").

Do you have more than one...

I bought this book when it first came out, because it's among the good ones.

The part I can't stand is the title.  SQL Server 2005 is indeed a good release...

But SQL is pronounced "ess-kyu-ell", except within the old Sybase tradename and current Microsoft tradename "See'kwel Server".  

And given what a lousy relational database language S.Q.L. is, I wouldn't want a...

Policies need to be explicit and written.

At the same time, I've stopped worrying if while searching for work related stuff - or even reasonable personal use from work - some...