Thanks Lowell

Jim

So there are no "Best Practices" documents out there?

Just this Analyzer ?

Thanks

Jim

Thanks Very Much Lowell

Jim

Ok

gb_size is solved but am getting error for mb_size

any idea on how to fix this one

Thanks

Jim

*****************

select

CAST(name as varchar(66)) logical_name,

database_id,

CAST (size*8.0/1024.0 as DECIMAL (5,1)) mb_size

from

master.sys.master_files

where

physical_name NOT LIKE '%.ldf'

order by

name;

go

Msg...

Thanks Phil

Thanks Lowell

so all i needed to add was ".0" then ?

Jim

Damn !

thanks Michael

it's Monday 🙂

I must have stared at that for sometime and it did not even compute

Jim

Hi FIOlks

can someone tell me what I am not doing correctly

the first sql works but the second does not

vercdate is a datetime field

can someone explain to me why the first...

Hi Jeffrey

thanks very much for your insight regarding this one

Jim

Thanks Everyone for your input

I read the article and it specifically says that when creating an index the value is trimmed

I used the word stripped. SQL Server may not be...

Thanks Jeff

i decided against changing it anywhere

Jim

Thanks

that was what i would expect and adds to my position that i do not understand why sql server strips out the trailing spaces when it tries to index. It...

Hi Rich

thanks for taking the time to expand on this

i understand the way it is being handled, but it is not logical to my way of thinking

sql server is actually...

You are correct

In Oracle (from a web site)

..Thus the difference between VARCHAR and VARCHAR2 is that VARCHAR is ANSI standard but takes up space whereas VARCHAR2 is Oracle-only but makes...

Hi Rich

thanks for the info

this all started because i could not index a column because sql server told me the columns were the same, when they are not because of...