create database student
on primary
(
name='p_data',
filename='d:\sql\p_data.mdf',
size=10mb,
maxsize=20mb,
filegrowth=2mb
)
log on
(
name='p2_log',
filename='d:\sql\p2_log.ldf',
size=12mb,
maxsize=20mb,
filegrowth=3mb
)
alter database ss
add file
(
name='ndf7_data',
filename='d:\sql\s\ndf7_data.ldf',
size=11mb,
maxsize=21mb,
filegrowth=3mb
),
(
name='ndf6_data',
filename='d:\sql\s\ndf6_data.ldf',
size=11mb,
maxsize=21mb,
filegrowth=3mb
)
go
Subscribe to:
Post Comments (Atom)
sql server index
sql index An index is an internal table structure that sql server uses to provide quick access to rows of a table based on the values...
-
In the ten years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance... -
create database student on primary ( name = 'st_data' , - - à it is use for logical name. filename = 'f:\my... -
create a table simple tableperson create table person ( p_id int, firstname varchar(50), lastname varchar(50), addr...
please explain your code
ReplyDelete