Perhaps you don't have the help compiler installed (not sure why you wouldn't)? Check out:

http://www.ec-software.com/downloads_mscomp.html

There is...

Did you determine why the log got so big? 25Xdata is not normal. I'm guessing you have the database in full recovery but never backup the transaction log???

And this is NOT going to get you what you think:

5.Display the customer name, employee name, and employee ID for all orders that were handled by the Sales Representatives.

this...

And that's because it's really a delete and...

Vidya (2/26/2009)

---

Unfortunately, renaming the new server to be the same as old won't work. Both will be online for a while until all testing is done.

Also, when I have...

I wouldn't sweat the small stuff. You should be honored so many people with your name are in your field as well. You could always come up with a more...

Vidya (2/26/2009)

---

Hi,

Is there a way to restore only the data and not the structure of the database (table structure, stored procedures, etc)?

My situation is that we are moving the...

How often are you backing up? I have maintenance plans that delete files older than 2 weeks and have never seen it fail to do it. How big are your...

I agree. You've got two resource-intensive jobs running and competing for CPU. They'll finish eventually but obviously the process will run longer. How are you removing unused space from the...

If the below command doesn't return the backup info, including compatability level (SQL version), it may very well be corrupt. If so, I know of no way to get it...

Absolutely. Truncating a table of 3.3 million rows at my job added about 200MB to the log but by using...

If your database is...

GSquared (2/25/2009)

---

I don't know about the three or more spaces thing. I've seen ones with punctuation and such that were basically a full description of the purpose of the...

Well put. I'll be plagiarizing that in the future. 😀