But the question was to pick 5 PERCENT. Your query returned 50 percent.

-SQLBill

An easy way to 'shrink' the tempdb is to stop and restart the services when you are done with all your transactions. This will cause tempdb to be rebuilt based...

By the way, as Frank has pointed out in two other threads:

There is already a thread on this QOD

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19291

Please use that one.

-SQLBill

Read the header on the page you actually submit the answer from. It stated that the questions and answers may have changed and to make sure you check them before...

Make sure there's no space between the final two single quotes:

'' not ' '

That should work.

-SQLBill

Luda,

Please don't post twice. Your post, with the same subject, in the TSQL section is getting responses.

-SQLBill

quote:

---

Yes, there's a way!! Go into Enterprise manager, open the table in design view, move your column to where you want...

Some companies require a Bachelor's Degree (especially Fed Government jobs), but will accept a Certification along with experience in place of the degree.

-SQLBill

1. Why not? SQL Server BACKUP commands are designed to do backups while the database is in use. My database is 24/7 and I run full backups once a day,...

Frank,

First we need to find out how the count of readers is done. Is it just anyone who OPENS the article? If so, that will skew the results. I've openned...

1. Are you getting any errors in the Windows Event logs? (check both your workstation and the server hosting SQL Server)

2. In Enterprise Manager, Tools Option, select Query Analyzer. Run...

Also there are two Administration forums:

Notification Services

- Administration

SQL Server

- Administration

But since the forum name is JUST Administration, how is a poster supposed to know the difference?

-SQLBill

...

Instead of adding a VB forum, why not create a Front-End Applications forum. Kind of a catch-all.

Also, can the General forums be 'cleaned' up? There are two General forums (last...

I can't compare the two and I don't use the maintenance plans. Why not? I like to control what is done and when. I recently had a vendor do an...

Have you tried running sp_spaceused on both databases? That stored procedure (refer to BOL for more information on it's usage) will show you how much space is being used and...