Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Nickel Elite Contributor
Posts: 107
Registered: ‎03-09-2011

Custom Tables and SQL Server

I have added some custom tables.

 

After doing some performance analysis it was revealed that these custom tables (Created with Database Manager) do not a have a "Primary Key" and unique clustered index in SQL server.

 

Is it permissable to set the Primary key and create the unique clustered index using SQL Management Studio?

 

The Primary Key was identified as such when creating the table and functions correctly in all sales logix applications.  It just not performing as good as it can from a SQL Server stand point.

 

Current SQL Server is SQL Server 2005 SP3

 

Is SQL Server 2012 supported by SalesLogix 7.5.4 and up?

 

 

Highlighted
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: Custom Tables and SQL Server

[ Edited ]

It only depends if you have remotes.

 

If you do not - then what you wish to do is absolutely fine. SLX does not store anything about indexes - it queries the DB for these at runtime.

 

It would not have any idea about funky compound keys etc. but those will be used by SQL in any event.

 

If you have remotes, just bear in mind what you do in Studio will not go to the remotes until they are rebuilt.

 

SQL2012 is not supported (but works, uncertified) until v8.

 

More info on indexes (quite old, but still relevant, now) here: http://www.empath-e.com/documents/Bulletins/090319-IndexUtilisation.pdf