how to compare structure?

Hi,
I encounter many problems while trying to
sincronise my data in sql server. Give an example : if i
have a new scripts, how do i ensure the table generate by
this scripts will have the same as the table's structure
which currently exist in database.
another example, if i have database A and new
database B, how i ensure that table in database A has the
same structure for the table in database B. If the table
in database A is not enough, how do i update the
structure in table A so that same with database B? Can
SQL server help me to generate a scripts that alter or
create table that into database A after compare with
database B?
In summary, how to sincronize old table
structure with new table structure in two different
datable?
Thank you very much.
regards,
florencePerhaps below?
http://www.red-gate.com/SQL_Compare.htm
--
Tibor Karaszi
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:110201c3a21b$c810b260$a301280a@.phx.gbl...
> Hi,
> I encounter many problems while trying to
> sincronise my data in sql server. Give an example : if i
> have a new scripts, how do i ensure the table generate by
> this scripts will have the same as the table's structure
> which currently exist in database.
> another example, if i have database A and new
> database B, how i ensure that table in database A has the
> same structure for the table in database B. If the table
> in database A is not enough, how do i update the
> structure in table A so that same with database B? Can
> SQL server help me to generate a scripts that alter or
> create table that into database A after compare with
> database B?
> In summary, how to sincronize old table
> structure with new table structure in two different
> datable?
> Thank you very much.
> regards,
> florence|||Florence,
Please check DB Ghost at www.dbghost.com This tool has
transformed our database change control processes and is
ideal for the tasks you describe.
Thanks,
Darren Fuller MCSE
>--Original Message--
>Hi,
> I encounter many problems while trying to
>sincronise my data in sql server. Give an example : if i
>have a new scripts, how do i ensure the table generate
by
>this scripts will have the same as the table's structure
>which currently exist in database.
> another example, if i have database A and new
>database B, how i ensure that table in database A has
the
>same structure for the table in database B. If the table
>in database A is not enough, how do i update the
>structure in table A so that same with database B? Can
>SQL server help me to generate a scripts that alter or
>create table that into database A after compare with
>database B?
> In summary, how to sincronize old table
>structure with new table structure in two different
>datable?
> Thank you very much.
>regards,
>florence
>.
>

How to compare structure of two db objects?

Hi,

I would like to compare an object inside a local and remote db and I would like see if any changes has been made to the object structure (table) since the last update.

ThanksRed Gate (www.red-gate.com) has a tool SQL COmpare that does exactly that.

To do it on the cheap, you might want to script the object in each copy of the database and then do a text compare of the two.|||I guess we were on the same page, thanks.

How to compare structure of two database ?

I have one database

and I create new database by copy everything from first db

I then alter some column on new database

and now I would like to compare two database

How can I do it ?

There is the manul way which I am sure you know of because like most of use we don't keep track of the changes that we make until time comes to roll the thing out.

There is a great good called RedGate SQL Compare (http://red-gate.com/products/SQL_Compare/index.htm) the tools are sort of expensive but well worth the money. Also if you are interested Microsoft is developing a product call Visual Studio for Database Developers that can be found on the MSDN site. Which esentially does the same thing and can be found on MSDN subscription download too.

|||I would write a script looking at syscolumns and sysobjects from both DB's and look where they do not match, this should get you changes to the DB.|||That is basically what Red Hat does, but it takes it a step furthor and generate the change script for you. I personally think that is worth 250.00|||

FYI, here is a simple script I'm using:

/*--Compare the differences in table schemas between 2 databases

--*/
/*--sample to call this stored procedure
exec p_comparestructure 'pubs','northwind'
--*/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_comparestructure]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_comparestructure]
GO

create proc p_comparestructure
@.dbname1 varchar(250), --the name of the database to be comapred
@.dbname2 varchar(250) --the name of the database to be comapred
as
create table #tb1(TableName1 nvarchar(250),ColumnName nvarchar(250),Ordinal int,Iden bit,PrimaryKey bit,Type nvarchar(250),
Bytes int,Length int,BitsAfterDecimalPoint int,AllowNulls bit,DefaultValue nvarchar(500),ColumnDescription nvarchar(500))

create table #tb2(TableName2 nvarchar(250),ColumnName nvarchar(250),Ordinal int,Iden bit,PrimaryKey bit,Type nvarchar(250),
Bytes int,Length int,BitsAfterDecimalPoint int,AllowNulls bit,DefaultValue nvarchar(500),ColumnDescription nvarchar(500))

--Get the schema of database1
exec('insert into #tb1 SELECT
TableName=d.name,ColumnName=a.name,Ordinal=a.colid,
Iden=case when a.status=0x80 then 1 else 0 end,
PrimaryKey=case when exists(SELECT 1 FROM'+@.dbname1+'..sysobjects where xtype=''PK'' and name in (
SELECT name FROM'+@.dbname1+'..sysindexes WHERE indid in(
SELECT indid FROM'+@.dbname1+'..sysindexkeys WHERE id = a.id AND colid=a.colid
))) then 1 else 0 end,
Type=b.name,Bytes=a.length,Length=a.prec,BitsAfterDecimalPoint=a.scale, AllowNulls=a.isnullable,
DefaultValue=isnull(e.text,''''''),ColumnDescription=isnull(g.[value],'''''')
FROM'+@.dbname1+'..syscolumns a
left join'+@.dbname1+'..systypes b on a.xtype=b.xusertype
inner join'+@.dbname1+'..sysobjects d on a.id=d.id and d.xtype=''U'' and d.name<>''dtproperties''
left join'+@.dbname1+'..syscomments e on a.cdefault=e.id
left join'+@.dbname1+'..sysproperties g on a.id=g.id and a.colid=g.smallid
order by a.id,a.colorder')

--Get the schema of database2
exec('insert into #tb2 SELECT
TableName=d.name,ColumnName=a.name,Ordinal=a.colid,
Iden=case when a.status=0x80 then 1 else 0 end,
PrimaryKey=case when exists(SELECT 1 FROM'+@.dbname2+'..sysobjects where xtype=''PK'' and name in (
SELECT name FROM'+@.dbname2+'..sysindexes WHERE indid in(
SELECT indid FROM'+@.dbname2+'..sysindexkeys WHERE id = a.id AND colid=a.colid
))) then 1 else 0 end,
Type=b.name,Bytes=a.length,Length=a.prec,BitsAfterDecimalPoint=a.scale, AllowNulls=a.isnullable,
DefaultValue=isnull(e.text,''''''),ColumnDescription=isnull(g.[value],'''''')
FROM'+@.dbname2+'..syscolumns a
left join'+@.dbname2+'..systypes b on a.xtype=b.xusertype
inner join'+@.dbname2+'..sysobjects d on a.id=d.id and d.xtype=''U'' and d.name<>''dtproperties''
left join'+@.dbname2+'..syscomments e on a.cdefault=e.id
left join'+@.dbname2+'..sysproperties g on a.id=g.id and a.colid=g.smallid
order by a.id,a.colorder')
--and not exists(select 1 from #tb2 where TableName2=a.TableName1)
select Result=case when a.TableName1 is null and b.Ordinal=1 then 'Table：'+b.TableName2+' absent in'+@.dbname1
when b.TableName2 is null and a.Ordinal=1 then 'Table :'+a.TableName1+' absent in'+@.dbname2
when a.ColumnName is null and exists(select 1 from #tb1 where TableName1=b.TableName2) then @.dbname1+' ['+b.TableName2+'] doesn''t have column：'+b.ColumnName
when b.ColumnName is null and exists(select 1 from #tb2 where TableName2=a.TableName1) then @.dbname2+' ['+a.TableName1+'] doesn''t have column：'+a.ColumnName
when a.Iden<>b.Iden then 'Different identities'
when a.PrimaryKey<>b.PrimaryKey then 'Different Primary Key constraints'
when a.Type<>b.Type then 'Different column data types'
when a.Bytes<>b.Bytes then 'Bytes'
when a.Length<>b.Length then 'Different Lengths'
when a.BitsAfterDecimalPoint<>b.BitsAfterDecimalPoint then 'Different in BitsAfterDecimalPoint'
when a.AllowNulls<>b.AllowNulls then 'Different in AllowNulls options'
when a.DefaultValue<>b.DefaultValue then 'Different default values'
when a.ColumnDescription<>b.ColumnDescription then 'Different Column Descriptions'
else '' end,
*
from #tb1 a
full join #tb2 b on a.TableName1=b.TableName2 and a.ColumnName=b.ColumnName
where a.TableName1 is null or a.ColumnName is null or b.TableName2 is null or b.ColumnName is null
or a.Iden<>b.Iden or a.PrimaryKey<>b.PrimaryKey or a.Type<>b.Type
or a.Bytes<>b.Bytes or a.Length<>b.Length or a.BitsAfterDecimalPoint<>b.BitsAfterDecimalPoint
or a.AllowNulls<>b.AllowNulls or a.DefaultValue<>b.DefaultValue or a.ColumnDescription<>b.ColumnDescription
order by isnull(a.TableName1,b.TableName2),isnull(a.Ordinal,b.Ordinal)--isnull(a.ColumnName,b.ColumnName)
go

How to compare database structures?

Let us suppose that I have two similar databases and need to create an
sql-script upgrating one database structure to another. For example, these
databases are from different versions of some software, first is from early
version, next is from current, and second one contains several new tables,
sevelal new fields in old tables, several new or changed stored procedures,
UDFs and so on.

How to solve this problem using standard tools?http://www.red-gate.com/SQL_Compare.htm

"Evgeny Gopengauz" <evgop@.ucs.ru> wrote in message
news:ce42is$c8r$1@.news.rol.ru...
> Let us suppose that I have two similar databases and need to create an
> sql-script upgrating one database structure to another. For example, these
> databases are from different versions of some software, first is from
> early
> version, next is from current, and second one contains several new tables,
> sevelal new fields in old tables, several new or changed stored
> procedures,
> UDFs and so on.
> How to solve this problem using standard tools?|||"Evgeny Gopengauz" <evgop@.ucs.ru> wrote in message news:<ce42is$c8r$1@.news.rol.ru>...
> Let us suppose that I have two similar databases and need to create an
> sql-script upgrating one database structure to another. For example, these
> databases are from different versions of some software, first is from early
> version, next is from current, and second one contains several new tables,
> sevelal new fields in old tables, several new or changed stored procedures,
> UDFs and so on.
> How to solve this problem using standard tools?

With the tools supplied with MSSQL, there's really no way to do this
easily. Most people buy a third-party tool (Red Gate, Embarcadero
etc.) to do comparisons and migrations. There are some good, cheap
tools, and unless you have lots of time and you want to re-invent the
wheel, you should probably investigate what's available.

Simon|||> > How to solve this problem using standard tools?
> With the tools supplied with MSSQL, there's really no way to do this
> easily. Most people buy a third-party tool (Red Gate, Embarcadero
> etc.) to do comparisons and migrations. There are some good, cheap
> tools, and unless you have lots of time and you want to re-invent the
> wheel, you should probably investigate what's available.

Thank you! Now I guess why I have found nothing in the BOL :)|||The latest issue of SQL Magazine has a tool from www.apexsql.com that may
help you out.
Oscar

"Evgeny Gopengauz" <evgop@.ucs.ru> wrote in message
news:ce42is$c8r$1@.news.rol.ru...
> Let us suppose that I have two similar databases and need to create an
> sql-script upgrating one database structure to another. For example, these
> databases are from different versions of some software, first is from
early
> version, next is from current, and second one contains several new tables,
> sevelal new fields in old tables, several new or changed stored
procedures,
> UDFs and so on.
> How to solve this problem using standard tools?|||In a pinch, you can always dump the structures of the two databases into
two text files and use a DIFF utility to identify the differences. No
very sexy but it gets the job done.

Farid

Evgeny Gopengauz wrote:
> Let us suppose that I have two similar databases and need to create an
> sql-script upgrating one database structure to another. For example, these
> databases are from different versions of some software, first is from early
> version, next is from current, and second one contains several new tables,
> sevelal new fields in old tables, several new or changed stored procedures,
> UDFs and so on.
> How to solve this problem using standard tools?|||Hi Evgeny,

Try dbMaestro. It's a product that allows comparison, migration and
archiving of database schema and data. it is generate migration script
for different between schema and data , and you can run this script on
sql server

You can find it here:

http://www.extreme.co.il

fn <f_n_a_c_e_r_removeunderlines@.hotmail.com> wrote in message news:<R7OdnW0-MNboz5rc4p2dnA@.britsys.net>...
> In a pinch, you can always dump the structures of the two databases into
> two text files and use a DIFF utility to identify the differences. No
> very sexy but it gets the job done.
> Farid
>
> Evgeny Gopengauz wrote:
> > Let us suppose that I have two similar databases and need to create an
> > sql-script upgrating one database structure to another. For example, these
> > databases are from different versions of some software, first is from early
> > version, next is from current, and second one contains several new tables,
> > sevelal new fields in old tables, several new or changed stored procedures,
> > UDFs and so on.
> > How to solve this problem using standard tools?

How to commit the rest of the transactions of an update in large bulk?

I have to modify the table structure where the table have a lot of data already. The log is getting full due to uncommitted transactions, there is a lot of data being updated in large bulks, not all of the transactions are committed, the update task cannot be completed.
However, there is no more spare disk space for it to commit the transaction. Anyone can help?what exactly are you dong? bulk insert?|||change some field 's size and its predefined function where the table have about 50,000 data already.

how to combine two records into one while displaying

here is the table structure
name |account | balance
jessica 234 45.00
mary 234 45.00
Robert 111 50.00
I need show all the persons names having similar account Id in one record
my expected output when i query this should be
jessica 234 45.00
&
mary
Robert 111 50.00
thanks for your reply in advance.Your table design appears to be denormalised. I would have expected Balance
to be in a separate table. Surely the same account number can't have two
different Balances? Fixing this should make your reporting task easier.
If you have a maximum of two names per account then just use MIN and MAX:
SELECT MIN(name),
CASE WHEN MAX(name)>MIN(name)
THEN MAX(name) END,
account, balance
FROM AccountNames
GROUP BY account, balance
If you have an undefined number of names per account then probably the best
approach is to compile your report-style output in your client application
or report writer.
--
David Portas
--
Please reply only to the newsgroup
--|||David,
Thanks for the reply. Altough your right It did not really answer my question. Please forgot about the table structure, main thing when i get an import from other system my table which i showed gets accurate(same) balances for the accounts having same id.
My question is .. when you query the table i need to get the records with the same account id as one record with all the names merged in the name column.
What I was doing is , I was using a cursor to loop through the table and get the names merged . My problem is once I complete the looping process based on accountid I have to insert the record into temporary table . I was wondering is there a way without using this cursors and temp tables to just get the data easily.
thanks|||Assuming that the combination of (account, name) is unique:
SELECT MIN(CASE seq WHEN 1 THEN name END)+
COALESCE(', '+MIN(CASE seq WHEN 2 THEN name END),'')+
COALESCE(', '+MIN(CASE seq WHEN 3 THEN name END),'')+
COALESCE(', '+MIN(CASE seq WHEN 4 THEN name END),'')
... etc...
account, MIN(balance)
FROM
(SELECT A1.name, A1.account, MIN(A1.balance), COUNT(*)
FROM AccountNames AS A1
JOIN AccountNames AS A2
ON A1.account = A2.account
AND A1.name >= A2.name
GROUP BY A1.name, A1.account)
AS A(name, account, balance, seq)
GROUP BY account
--
David Portas
--
Please reply only to the newsgroup
--|||david I need your help once agai
Main thing is I need the same output as before but I was not able to join my real world tables properly to get the data
I have three table
1. Person - which has (IdColumn(PK), PersonId, Firstname,Lastname,Middlename
2. UserPerson - which has (PersonId, UserId
3. PersonAccount - which has (IdColumn(PK), PersonId, JointAccount,Balance
Also all the personId's are GUID's
I need the userperson table because my where clause has a condition to get only persons beloging to a user. (like where userid = 100
My output as discussed previously should be
person name (Firstname+middlename+lastname), JointaccountId, balanc
The one which you given works fine with the previous table structure we have discussed
I very much appreciate your help
thank
-- David Portas wrote: --
Assuming that the combination of (account, name) is unique
SELECT MIN(CASE seq WHEN 1 THEN name END)
COALESCE(', '+MIN(CASE seq WHEN 2 THEN name END),'')
COALESCE(', '+MIN(CASE seq WHEN 3 THEN name END),'')
COALESCE(', '+MIN(CASE seq WHEN 4 THEN name END),''
... etc..
account, MIN(balance
FRO
(SELECT A1.name, A1.account, MIN(A1.balance), COUNT(*
FROM AccountNames AS A
JOIN AccountNames AS A
ON A1.account = A2.accoun
AND A1.name >= A2.nam
GROUP BY A1.name, A1.account
AS A(name, account, balance, seq
GROUP BY accoun
--
David Porta
--
Please reply only to the newsgrou
-|||SELECT MIN(CASE seq WHEN 1 THEN fullname END)+
COALESCE(', '+MIN(CASE seq WHEN 2 THEN fullname END),'')+
COALESCE(', '+MIN(CASE seq WHEN 3 THEN fullname END),'')+
COALESCE(', '+MIN(CASE seq WHEN 4 THEN fullname END),'')
jointaccount, MIN(balance)
FROM
(SELECT A1.personid, A1.jointaccount, MIN(A1.balance), COUNT(*)
FROM PersonAccount AS A1
JOIN PersonAccount AS A2
ON A1.jointaccount = A2.jointaccount
AND A1.personid >= A2.personid
GROUP BY A1.personid, A1.jointaccount)
AS A(personid, jointaccount, balance, seq)
JOIN
(SELECT personid,
COALESCE(firstname+' ','')+
COALESCE(middlename+' ','')+
COALESCE(lastname,'') AS fullname
FROM Person) AS P
ON A.personid = P.personid
GROUP BY jointaccount
--
David Portas
--
Please reply only to the newsgroup
--

How to choose file structure on SQL database?

I created MDF file and LDF for one database on SQL server 2000.
I need to create more DNF files on other 5 logical drives for this datanase.
All these logical drives are located in SAN storage configured with RAID10.
Should I create one NDF on each logical drive OR create multiple DNF on each
logical drive?
Which way is better for performance?
Thanks,
Mike
What is DNF files? Is it NDF? Have you monitor your SQL Server to make such
decision?
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,
|||Hello,
Probably you should be talking about NDF files. Since it is SAN just try
creating the database in a Single Logical drive (1 logical drive for MDF
and another for LDF) and see how database performs. See the I/O queue length
counter in perfmon and seee how well it goes.
If it quue length is always <=1 then you are good. I have the similar
environemnt and I have created database based on this strategy.
I will recommend you to keep the files in multiple drives if you have
multiple controllers running. Otherwise even if you create files
in multiple logical drives you will not get any performance improvements.
Thanks
Hari
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,

How to choose file structure on SQL database?

I created MDF file and LDF for one database on SQL server 2000.
I need to create more DNF files on other 5 logical drives for this datanase.
All these logical drives are located in SAN storage configured with RAID10.
Should I create one NDF on each logical drive OR create multiple DNF on each
logical drive?
Which way is better for performance?
Thanks,Mike
What is DNF files? Is it NDF? Have you monitor your SQL Server to make such
decision?
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,|||Mike Torry wrote:
> I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this datanas
e.
> All these logical drives are located in SAN storage configured with RAID10
.
> Should I create one NDF on each logical drive OR create multiple DNF on ea
ch
> logical drive?
> Which way is better for performance?
> Thanks,
Hi,
If it's logical drives rather than physical drives, it won't help you a
lot to split the files on several drives. If you want to increase
performance, the data will have to placed on different physical spindles
and also preferably on different controllers (in most cases you'll just
have your MDF files disks on one controller and your ldf files disks on
a second controller). If you have any influence on hos your SAN is being
configured, you should also consider have more spindles in an array
rather than having many arrays. Depending on the usage of your database
it will give a better performance to have more spindles to read from
rather than splitting the load on several arrays/disks.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Hello,
Probably you should be talking about NDF files. Since it is SAN just try
creating the database in a Single Logical drive (1 logical drive for MDF
and another for LDF) and see how database performs. See the I/O queue length
counter in perfmon and seee how well it goes.
If it quue length is always <=1 then you are good. I have the similar
environemnt and I have created database based on this strategy.
I will recommend you to keep the files in multiple drives if you have
multiple controllers running. Otherwise even if you create files
in multiple logical drives you will not get any performance improvements.
Thanks
Hari
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,

How to choose file structure on SQL database?

I created MDF file and LDF for one database on SQL server 2000.
I need to create more DNF files on other 5 logical drives for this datanase.
All these logical drives are located in SAN storage configured with RAID10.
Should I create one NDF on each logical drive OR create multiple DNF on each
logical drive?
Which way is better for performance?
Thanks,Mike
What is DNF files? Is it NDF? Have you monitor your SQL Server to make such
decision?
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,|||Mike Torry wrote:
> I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this datanase.
> All these logical drives are located in SAN storage configured with RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on each
> logical drive?
> Which way is better for performance?
> Thanks,
Hi,
If it's logical drives rather than physical drives, it won't help you a
lot to split the files on several drives. If you want to increase
performance, the data will have to placed on different physical spindles
and also preferably on different controllers (in most cases you'll just
have your MDF files disks on one controller and your ldf files disks on
a second controller). If you have any influence on hos your SAN is being
configured, you should also consider have more spindles in an array
rather than having many arrays. Depending on the usage of your database
it will give a better performance to have more spindles to read from
rather than splitting the load on several arrays/disks.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Hello,
Probably you should be talking about NDF files. Since it is SAN just try
creating the database in a Single Logical drive (1 logical drive for MDF
and another for LDF) and see how database performs. See the I/O queue length
counter in perfmon and seee how well it goes.
If it quue length is always <=1 then you are good. I have the similar
environemnt and I have created database based on this strategy.
I will recommend you to keep the files in multiple drives if you have
multiple controllers running. Otherwise even if you create files
in multiple logical drives you will not get any performance improvements.
Thanks
Hari
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,