Jeff, my problem is maximum size 8... I was tried using SSIS, but it's the same problem... I have a 180 columns and 1 million rows (MySQL).... when I show...

I've this problem: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7a5c76c5-e6f3-49c7-9c52-95935d7530fd/the-character-string-that-starts-with-is-too-long-maximum-length-is-8000?forum=sqlreportingservices

but the problem is openrowset

Msg 103, Level 15, State 1, Line 4

The character string that starts with 'select `ID`,if(`STATUS`='',null,`STATUS`) as `STATUS`,if(`DIGITADOR`='',null,`DIGITADOR`) as `DIGITADOR`,if(`DATA_INCLUSAO`='',nu' is too long. Maximum length is 8000.

is...

Gila,

I noticed that the log file is bigger when I do a full backup. is this normal? actually my database have a 80gb (mdf). and a do a shrink... all...

all right, but the big problem is backup log... may a 170mb for each file... lets suppose that I have 30 log files? 30 x 170 = 5gb backup log?...

I noticed that the log file is bigger when I do a full backup. is this normal?

Gila,

so... in the case, it's recommend a put datafiles .mdf, .ndf and .ldf in the same disk, correct?

All right...

I have been installed and my installation not was successful.. is due this problem.

how can i fix it?

" If you have 4 processors, you could start 4 MDF" (in the case, i'll have 5 datafiles all right? (4 for ndf) and (1 mdf-default), ok?

and about: "files at...

1,000MB equals = 1GB? or 1MB?

and if I have 4 processor (physical) I need put more 3 datafile? because exist mdf (default).

You sad: "500MB with 500MB growth for the LDF...

yes, but the problem at the moment is because my tempdb is thin.... small.. (that is new project - SQL Server)... Hardware, OS, Database... and my tempdb is small.. you...

Yes... but lets suppose that I am installing at the moment and tempdb is small.. (2,3,4mb), in other words, is not a big... how can i calculate this (for each...

and about the size of them? how can i calculate that?

someone to volunteer?

hm, all right.

last doubt dude...

i have this index:

id index_type_desc index_id avg_frag

1CLUSTERED INDEX080

alter index indexname

on table X

rebuild with (online=on)

after that...