Tags » SQL Performance

LEFT JOIN vs NOT IN vs NOT EXISTS Performance Comparison

A typical task that is asked of programmers in SQL is to determine whether a matching row exists for a given condition in a table. I am aware of three methods for accomplishing this task (there may be others, but as of this post these are the only ones that I know about): 1,184 more words

SQL

#Oracle DBA Bookshelf

My recommendations for the DBA bookshelf at work is:

General

Direct SQL query for Dynamics AX table

Use of SQL query to select Dynamics AX table may be done if we have external system which is integrated to our Dynamics AX. In this case we don’t want to use Dynamics AX services due to simple function that we need inside Dynamics AX. 298 more words

Dynamics AX

SQL SERVER - Activity Monitor to Identify Blocking - Find Expensive Queries

Recently when I was busy working on my next course for Pluralsight, one of my friend pinged me for some help over messenger. And the conversation went on a different spin, here is a gist of what we talked and I felt this was worth a share – 668 more words

SQL Authority

SQL SERVER - In-Memory Databases and Caching Wars

The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!

  • SAP, the giant application vendor, but a database newbie, is pushing to the market its SAP HANA, a standalone in-memory database (in an appliance box).
  • 967 more words
SQL Authority

SQL SERVER - Keeping MSDB System Database Lean and Fit - Notes from the Field #033

[Notes from Pinal]: I am working with SQL Server for almost 10 years. I have seen the most ignored databases on any database server is system database. 527 more words

SQL Authority

SQL SERVER - SQL Server High Availability Options - Notes from the Field #032

[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. 432 more words

SQL Authority