Any SQL query can be written in a multitude of ways, but developers always follow best practices for getting the fastest response. We highlight ten ways to improve your SQL query performance.
More articles by Anoop Kumar
Anoop worked for Microsoft for almost six and half years and have 12+ years of IT experience. Currently, he is working as a DW/BI Architect in one of the top Fortune Company. He has worked on end to end delivery of enterprise scale DW/BI projects. He is carrying strong knowledge on database, data warehouse and business intelligence application design and development. Also, He worked extensively on SQL Server, designing of ETL using SSIS, SSAS, SSRS and SQL Azure. Disclaimer: I help people and businesses make better use of technology to realize their full potential. The opinions mentioned herein are solely mine and do not reflect those of my current employer or previous employers.
Explore various methods to manage HDFS, which include Node Addition/Deletion, Data Integrity issues, and many more.
Learn more about the Hadoop Distribution File System that's designed to adhere to a traditional distributed file system and the Google File system.
Explore how developers from the Query or Scripting languages communities can leverage their knowledge to be part of the Big Data world.
Lead: Learn how the new "Hadoop" framework is becoming the future BI platform to handle the huge size of data with faster processing time.
Discover the concept of data presentation in the business intelligence world. Also, learn about various ways to present data.
Explore the importance of data analysis in an end-to-end BI system.
Learn more about various Business Intelligence components, architecture, data modeling, and its importance.
Anoop Agarwal discusses the fundamentals of Business Intelligence (BI) and various data Warehouse design approaches. In this first article of the series, he shares how Big Data is different from traditional BI.
In today’s technology world, Big Data is a hot IT buzzword. To mitigate the complexity in processing large volumes of data, Apache developed Hadoop – a reliable, scalable and distributed computing framework. Read on to learn more.
Code coverage is a way to measure what percentage of the source code of a program has been tested. Read on to learn how code coverage can help to improve the overall quality of a program and how to leverage Microsoft VSTS to get code coverage for Windows Azure Service and .Net.
Learn how to improve your SQL query performance with these ten tips, including re-writing of queries and the creation and use of indexes.
Anoop Kumar shares his top 10 transformations to manage and change data in SSIS.
Anoop Kumar shows you how easily ETL performance can be controlled at any point of time by sharing 10 common ways to improve ETL performance.
Anoop Kumar discusses some common operators that are useful to interpret a graphical execution plan and troubleshoot any performance issue due to a badly written query.
Learn how SQL Server generates a query execution plan and the processes involved to achieve the task.
Learn how to identify a performance bottleneck on Windows Azure SQL Database using Microsoft System Center.
Learn how to use Microsoft Windows Azure SQL Database to deploy hassle-free relational database solutions on the cloud while realizing the benefits of a distributed data center that provides high availability, scalability and security.