Re: [PHP-DB] mssql indexes From: Gerard Samuel (gsam <email protected>)
Date: 06/28/02

Thanks for the help and pointers...

Ryan Jameson (USA) wrote:

>Yes, in Enterprise manager, right click the table, and then choose the column and at the bottom of the design window, and there is a default value field. Some reason I seem to remember that it had some strange quirks.
>
>MS SQL is quite forgiving to making mistakes as long as they are reasonable, if you drop the table, it's pretty much gone.
>
>Another pointer is be sure to set up and schedule a maintainance plan. It's under Management. It's super easy and gives you the ability to reload in the case that your mistake is not forgiven. :-)
>
><>< Ryan
>
>-----Original Message-----
>From: Gerard Samuel [mailto:gsam <email protected>]
>Sent: Friday, June 28, 2002 3:46 PM
>To: Ryan Jameson (USA)
>Cc: php-db
>Subject: Re: [PHP-DB] mssql indexes
>
>
>Thanks for your reply. There seems to be so many options that I felt
>like a fish
>out of water. Maybe I need to make some mistakes and learn from them.
>One last request. I dont see an option to insert default values. Is
>this possible in mssql.
>Thanks
>
>Ryan Jameson (USA) wrote:
>
>
>
>>Hi Gerard,
>>
>>Every database has it's own way to handle indexes. In my fairly extensive use of MS SQL Server the index is not defined in the table definition. Hence, there probably is no way to dump the indexes directly in, you may have to just create them. It's very easy in SQL, be sure to take advantage of your one clustered index as well, the clustered index improves lookup performance noticeably.
>>
>>You can build your indexes in Enterprise Manager by right clicking a table, choosing all tasks and managing indexes. You can build indexes on pretty much any field or combination of fields, but if you need a large text field index you'll need to use the option for full-text indexing. I think that's new for SQL Server 2k... but I'm not positive.
>>
>>That's been my experience.
>>
>><>< Ryan
>>
>>-----Original Message-----
>>From: Gerard Samuel [mailto:gsam <email protected>]
>>Sent: Friday, June 28, 2002 3:12 PM
>>To: php-db
>>Subject: [PHP-DB] mssql indexes
>>
>>
>>Hey all. Today was my first time recreating a mysql dump to mssql. Im
>>using the sql enterprise manager thingy.
>>I got the table structure and primary keys finished. But Im lost with
>>mssql options for indexes.
>>Could someone point me to how to recreate a column index in mssql like
>>how mysql is??
>>If I didn't make sense, please dont hesitate to ask for more info...
>>
>>Thanks
>>
>>
>>
>>
>>
>
>
> 

-- 
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php