Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-01-05 : 17:49:10
|
| hi all,In the properties of the table in the MS Access there is an Indexed column. If someone would had set that to "Yes (Duplicates Ok)" how can one implement this to MSSQL??? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-05 : 23:23:54
|
| [code]CREATE INDEX <index_name>ON <table_name>( <column_1>, <column_2> ...)[/code]CREATE UNIQUE INDEX will Creates a unique index on a table or view.Refer to SQL Server Books Online for more information-----------------[KH] |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-06 : 05:14:00
|
| Or use Enterprise Manager - "Design" table, and in there is an option to construct indexes (unique or allowing-duplicates) using a GUI rather than the raw SQL commands - whichever you are more comfortable with!Kristen |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-06 : 10:49:17
|
| I read that it is better for perfomance reasons to seperate the index from the table data... For that reason i wroteCREATE UNIQUE INDEX ARTICLE_IDON ARTICLE (ARTICLE_ID)ON indexesbut i receive the following errorInvalid filegroup 'indexes' specified.Could anyone tell me where i have to go to create this filegroup??? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-06 : 15:22:10
|
| "I read that it is better for perfomance reasons to seperate the index from the table data"If you database is less then 5GB I shouldn't worry about it"For that reason i wrote"Sorry, didn't see that, what reasons?Kristen |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-06 : 15:30:30
|
| sorry i meant for the reason of the perfomance...anyway,for academic reason how one could create a file group? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-06 : 18:07:46
|
| You do this in CREATE DATABASE or ALTER DATABASE database ADD FILEGROUP filegroup_nameRefer to Book OnLine for syntax and details-----------------[KH] |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-01-06 : 18:38:37
|
| The performance improvement you would get from this is probably not worth the effort.Your time would be better spent learning sql, query optimisation and designing databases.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
INDEXED