Author: Embarcadero USA Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check for issues with bad cardinality estimates. The maximum degree of parallelism can be limited server-wide by using the max degree of parallelism option. DMV – sys.dm_os_nodes provides information about CPU node…