When the password is stored it's encrypted.

In 2000 you could sniff the network for connections using SQL authentication, isolate the conection information, run it through a little C utility (see...

The datetime specification requires either a date or a null value. There aren't any "blank" dates. If you're using it for display purposes, you can convert to a...

Robert... good point. Honestly I've never been a fan of sp_rename, or even ALTER statements. If possible I usually drop/recreate objects. But that's something good to...

You should be able to just right-click the package in EM and select "Schedule Package". That's how I've always done it. It will create the job for you...

For programmatic objects (functions, triggers, stored procedures) you can use sp_helptext. It's not as good, but it's pretty good. Change your results to text rather than grid and...

Sometimes SQL Server decides that the queries which are being sent are not best split into parallel operations.

That being said... you probably want to check/post settings for your CPU...

What's the data type of the column it's being compared against. That provides a value which could be evaluated just as easily as an integer (even though it's a...

It might be worthwhile to try running profiler on the database server at the time of execution and seeing if you can capture the exact SQL statement that is being...

If it's a third-party application you may not have a lot you can do without invalidating any support you've purchased. I'd contact your vendor about it first.

Delete operations will...

I have to chime in as well. If anything I've found overuse of NOLOCK by people who don't really understand why blocking exists.

Blocking is good.

It ensures that there are...

GETDATE() is a system function for returning the system's current date/time. If you want to get the most recent date from a column use MAX()... example:

SELECT Max(MyDateTimeColumn) FROM MyTable

SELECT...

Be careful about defragging... it's usually not something you should do on SQL Server's usually (for a bunch of different reasons). If you have a maintenance window when...

Sounds like you might have a serious problem with the underlying disk subsystem. You might be able to fix it by creating an exact copy of the data and...

I'd echo John here. Most people will want to use maintenance plans. Something like this should do it for you, but you'll still have to manage removing old...

Congratulations! This has been an excellent site for furthering my career by allowing me to ask questions, provide assistance and publish my own work.