From what I've learned, RAID 5 is slower in comparsion to RAID 1 because the data is distributed redundantly accros the stripes to allow for recovery ,so it can potentially...

this is a really good source...there's a brief paragraph on the one filegroup per disk and such:

http://www.sql-server-performance.com/articles/per/optimize_filegroup_performance_p2.aspx

ouch; i had a similar issue where a controller card went bad and was writing bad data for hours before the db was too corrupted to use, but I had...

I think the article complete skips over how the other 90% benefit after the 10% paid for the research and development of the software.

Take the Internet for example...it wasn't targeted...

here a snippet i saved for looping thru access tables from an application:

Set AccessCN = New ADODB.Connection

    AccessCN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Clients\someAccessDb.mdb;Persist Security Info=False"

    AccessCN.Open

    Set rs = New ADODB.Recordset

   ...

the way to do it is with the ALTER TABLE ALTER COLUMN command:

example:

create table test (testid int,testcol float);

exec sp_help test;

alter table test alter column testcol decimal;

exec sp_help test;

drop table test;

now...

a simple asp web page like this would work; change the connection info toyour page, put it somewhere on the web server and browse to that page:

<!DOCTYPE...

I'm betting it has to do with dynamic sql; also "Primary" should be in single, not double quotes, right?

if you add one of the many split function examples here on...

I'm confused about what you mean when you said "I go to my site, it asks me for a local user account"

Are you sure it's SQL server that is asking...

thanks for the correction Steve; i never get to play with replication, but I try to read about it here.

since this is db2 instead of sql, does that mean the  idsdemo.FFIITMAP is not databasename.tablename? so the tablename has a period in it? ie [idsdemo.FFIITMAP]

if that's true, then we'd just...

not enough info to really help yet helen.

the real table definition is much more helpful, as well has the name /definition of the table you are "merging" it with, ie

I'm going to agree with you...it's common to see bit fields keeping track of attributes, when more properly it should be one-to-many tables.

you could envision  that if you had to...

the full text catalog is not stored in the database, but actually separately on the server i believe.

as a result, you need to deploy the database, and after restoring it...

wierd...it's ok syntax wise, so I suspect is has to do with teh multi-part-name.

I'd suggest aliasing the table to fix it:

Update idsdemo.FFIITMAP

  set idsdemo.FFIITMAP.FFIHGTH = A.CFFIHGTH

From idsdemo.cubiscan  A

WHERE ltrim(rtrim(A.CFFIITMN)) =...