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…
Author: Tamarian D2278
As we traverse through different versions of SQL Server, there are new enhancements that always make us learn for newer techniques. One such addition to SQL Server 2012 is called as Sequences. Sequences are just like a running number like…
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…
Author: Timur T7253
Introduction
Other than coding, the next biggest task for developers is to troubleshoot problems in their environments. Developers in the SQL world mostly face problems around error messages, getting required output via T-SQL query, and unpredictable performance of queries.
The Problem
One fine day somewhere in the world one developer was troubleshooting a performance problem…
Author: mahdy M7244
Introduction
When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data…
Author: jpro51
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on application needs. I am a firm supporter that databases are not the place to play with date and time conversions.
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 time. Keeping things till the last moment will only bring our heart rate higher and the anxiety to finish will sometimes make…
Author: Wayne S8181
Monday, July 14, 2014: Lesson 3 – Accessing Local Storage and Data
In this lesson, we explore local storage covering a range of options including using INI files and local document storage. This lesson will also show how to use FireDAC database…
I have just returned from myRAD Studio XE3 World Tour stops in Europe. It was great to see so many young and old developers in London, Amsterdam, Warsaw and Heidelberg. In two cities I was asked whether there were any Object Relational Mapping solutions for Delphi. There are two Delphi ORM(s) that I know about:
TMS Software’s TMS Aurelius – commercial ORM.
