New code formatting engine available for you SQL gurus.

http://www.sqlservercentral.com/Forums/Topic763966-433-1.aspx

Thanks, Mel.

Give it a try if you can.

Hopefully they are not removing databases regularly. the plans don't modify well, so if this is a regular problem, I'd stop using the "all user databases" and check each database....

software shouldn't break down like hardware does, but it always has defects in it. If we continue to delay fixing software, often we are building on a poor foundation and...

I would bet something else has changed. If you added more memory, you might have people running queries that they didn't run before, or perhaps trying reports that used to...

What do you mean by database size? The size on disk? The data size? The data size + log used size?

We are happy to help, but we also expect you...

You create an SSIS package, add an FTP task to it, then run the package. It's not a standalone task.

First, you have a WHERE clause in both examples. The problem is the inequality, not the WHERE clause. The only way you can determine something is NOT another value is...

The formatting has been corrected.

Check SPID 14

User initiated stack dump. This is not a server exception dump.

Not sure what is running, but something appears to be calling a dump.

Glad you like them, and I'll try to keep them going.

Configuration Manager can help you set ports

Bad Jeff, bad!

Code formatting coloring is high on the next maintenance window (next 2 weeks)

I think it's based on the defaults you have set for your account.

I know I always get them.

Nice one, jcrawf02.

I know many of you by your names here. Changing them around will have my head spinning. Especially in this thread!