News

10 Quick Tips & Tricks for SQL Server Developers

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…
Read more
News

Rapid SQL XE6 / 8.7.5 is Now Available

Author: Embarcadero USA Rapid SQL XE6 version 8.7.5 is now available. EmbarcaderoRapid SQL is the integrated SQL development environment for IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase and Teradata database systems. Rapid SQL is your fast path to…
News

3 Cool SQL Server TSQL Snippets for Productivity

Author: Tim DelChiaro Nobody would want to shy away from some help. This is second to human nature and we never try totalk it out explicitly. When at work, if we can surely get help from our colleagues when it comes to driving the deadlines and completing it ahead of…