As mentioned above, it's likely the log file that's grown. Check the individual sizes, and do you have log backups running? If not, you need to set those up.

http://www.sqlservercentral.com/articles/64582/

Sorry, fatfingered the past post.

Editions of SQL: http://msdn.microsoft.com/en-us/library/aa933150(SQL.80).aspx

It's not advertising as I'd normally see it. It's a mention that his product, which shall not be mentioned, and which apparently isn't in use by anyone, is great!

I'm tempted...

http://msdn.microsoft.com/en-us/library/aa196694(SQL.80).aspx

I'm sure he'll be back.

And I figured you'd answer, being snowed in like me.:-D

He'll go away if you let the thread die. He periodically comes through, posts for a few weeks, and then disappears.

Stop quoting him as well. The quote button increases the...

They usually do go to the company, I'd agree with that. My point is that if management refuses, someone might show up at the office with papers asking for data....

There's no magic, and I hate to see that. But there is a level of abstraction that can make things more manageable. That's what computers have done.

The "cloud" definitely needs...

Keep reading, keep learning, and practicing. The experience you get working with the product will help you. When you're ready to change careers look for a position as a junior...

What's in the file? The last lines often give a clue about what might be wrong.

One thing with SPs, be sure no application or user is trying to connect. There...

You could use VBScript in a DTS/SSIS script task if you wanted. If you are looking for basic links, perhaps searching on Microsoft is a good place to start. There...

I hadn't noticed that. No idea what that is from. I assume date, then time, but the last digits, not sure. Have you checked in the job history or maintenance...

The first one won't really generate a plan. It needs to scan everything, so why build a plan?

The second one might use an index, but the "Select *" might just...

What do you mean "to load"?

Reboots sometimes clear out things that are executing. When you get poor performance, are you documenting what is slow? Running traces to capture activity? Any...

Get backups working first. Being able to recover is key.

Then start looking at what's scheduled in jobs, maintenance, business jobs, etc. I'd get a handle on what's happening and...