Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Nickel Elite Contributor
tdowning@solidconcepts.com
Posts: 107
Registered: ‎03-09-2011

Custom Tables and SQL Server

‎08-02-2013 03:50 PM

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?

 

 

Report Inappropriate Content
Message 1 of 2 (964 Views)
0 Kudos
Silver Super Contributor
Silver Super Contributor
MikeSpragg
Posts: 801
Registered: ‎03-24-2009

Re: Custom Tables and SQL Server

[ Edited ]

‎08-03-2013 02:33 AM - edited ‎08-03-2013 02:34 AM

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

Report Inappropriate Content
Message 2 of 2 (962 Views)
0 Kudos