SQL Hyenas

While working with large amount of data, the main problem with queries is to increase performance of queries by decreasing execution time. Many factors are affecting on query performance. Some are as bellows: 1.     Data volume : If you are playing with large amount of data and taking multiple column from multiple table with certain join then performance of query is get slow down. You need to keep in mind that before joining table to get another column first reduce size of data. Apply where clause and take data on conation what you required. You can use CTE or Temporary table for capturing limited data and instead on joining actual table join CTE or Temporary table to it. It will defiantly optimize the performance of query. 2.     Indexes: Creating useful indexes is one of the most important ways to achieve better query performance. While creating Indexed you need to consider, frequency of run the query, type of queries which is using ...

What is JSON: JSON stands for  J ava S cript  O bject  N otation, and is a way to store information in an organized, easy-to-access manner, "self-describing" and easy to understand. It gives us a human-readable collection of data that we can access in a really logical manner. Why we need JSON: JSON is a lightweight data-interchange format and it is language independent. Many sites are sharing data using JSON in addition to RSS feeds nowadays, and with good reason: JSON feeds can be loaded asynchronously much more easily than XML/RSS. Format of JSON string: JSON Example { "employees" :[     { "firstName" : "John" ,   "lastName" : "Doe" },     { "firstName" : "Anna" ,   "lastName" : "Smith" },     { "firstName" : "Peter" ,   "lastName" : "Jones" }             ] } You can compa...