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
Tags » SQL Performance
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
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
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
[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
[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