New answers tagged

0

To quote MSDN as an authoritative source: There are no significant differences between creating a UNIQUE constraint and creating a unique index that is independent of a constraint. Data validation occurs in the same manner, and the query optimizer does not differentiate between a unique index created by a constraint or manually created. However, creating ...


8

There are a couple of things to say about this, Dynamics AX performance is not necessarily always caused by SQL Server slowness, especially if you say "everything is slow". When faced with performance issues in Dynamics AX I tend to use the following approach: First start with reviewing resources on all servers involved (cpu pressure, memory pressure, ...


0

I would first configure the server according to best practices including: RCSI MAXDOP = 1 TempDB Memory Settings etc... Then if performance is still an issue, dig into the most resource intensive queries and try to optimize those...though, I believe in AX everything is cursor based.


2

I think you mean PascalCase (not camelCase) since Title Case only applies when there is white space separating the words. I agree with @wBob that the best you can do via T-SQL is ensure that the first letter is upper-case. Though you could probably go one step further, extending the condition suggested by @wBob, and ensure that the 2nd letter (assuming it ...


2

SQL Server's implementation of the Like operator only supports a really cutdown kind of regEx which includes basic character matching and wildcards, but does not include Number of repeats like {1} or the other kind regEx anchors like \b or \s. It is also generally speaking, not case-sensitive. That said, you can sometimes spoof these kind of things with ...



Top 50 recent answers are included