RAD Studio 10.4.1 is now available! Learn more. Looking for discounts? Visit our Special Offers page!
News

10 Quick Tips & Tricks for SQL Server Developers

Author: Embarcadero USA

Tips and Tricks for SQL Server Developers

Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave.

  1. For inefficient query plans: Check for issues with bad cardinality estimates.Try Rapid SQL
  2. The maximum degree of parallelism can be limited server-wide by using the max degree of parallelism option. 
  3. DMV – sys.dm_os_nodes provides information about CPU node configuration for SQL Server.
  4. Slow query can be because of Missing indexes can force table scans and slow down the query.
  5. Plan guides can be created for ad hoc queries as well as queries inside a stored procedure.
  6. On both 32-bit and 64-bit platforms, memory that is allocated through the AWE mechanism cannot be paged out.
  7. Entities with the same query_hash value have a high probability of referring to the same query text.
  8. The query hash is computed from the tree structure produced during compilation.
  9. A change in the cardinality of a table variable does not cause a recompilation.
  10. You can use Performance Monitor and SQL Server Profiler to detect excessive compilation and recompilation.

Take your SQL Development to the Next Level

Embarcadero Rapid SQL is the intelligent SQL IDE empowering database developers and DBAs the ability to create high-performing SQL code on all major databases from a single interface. This toolset simplifies SQL scripting, query building, object management, debugging and version control with intuitive, innovative tools.

Try Rapid SQL | Learn more about Rapid SQL | Contact Us


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Learn More About Upgrading

Related posts
DelphiShowcase

HeidiSQL Is A Lightweight Open Source Database Management Tool Built In Delphi

CodeDatabaseDelphiRAD Studio

Learn How To Use FireDAC To Work With A Firebird Database In Delphi

DatabaseRAD Studio

Newcomer's Perspective - FireDAC and SQLite

CodeDatabaseDelphiRAD Studio

Learn More About The FireDAC Connection Object In This RAD Studio Sample App

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES