I reduced the email1- email10 size from 1000 chars to 100 chars, saving 9000 chars.

9000 * 1 650 000 records = 1.485e+10

So why when i do a backup is my...

Steve,

The only column that is FTI is originalresume. The email1 column is indexed.

I decided to do things one step at a time, and just reduce the size of the email...

Steve,

Thanks for your suggestions !

As a test using SSMS, I did create a Copy DB and reduced the size of email field to 100 chars, did a reindex and...

Rookie Question,

I did a length check and found the longest email to be 83 characters.

Could i not just right click each Email1- Email10 column and do a Modify from 1000...

Steve,

You do make some valid points regarding overkill ! I guess i got carried away 🙂

I do have good performance and can search 1.65 million records in about 3-4 seconds...

Steve,

Thanks for your reply !

The reason i did not provide data, is that it would take too much data to get the query to work slow enough to prove the...

Thanks, i forgot the good old search button.

I got it fixed after playing with some accounts and passwords.

Thanks

Here ya go.

Thanks

Yes i know. The box is in a different physical location 🙁

Thanks

What is that lowest common denominator ?

Text format ?

Tasks -> Copy Database ->

i have tried doing a Full backup then going the SHRINKFILE and the other way around but get the same result!

I am shinking both the...

DBCC SHRINKFILE (microsoft525_log, 10) WITH NO_INFOMSGS

I am using this query and the shrink in Tasks and it will not got under 5GB for 49 records ?

When doing a copy, why...

I need to send a testDB to another country, so they may test a new project that was developed.

I dont want a direct connection to my server from another country.

I got it working after adding a new maxuserport key.

Thanks

BTW Lynn is Word 03 ok ?