Indexes play a critical role in enhancing your database performance by facilitating faster query execution. Having the right indexes in place can speed up the process of fetching data from your underlying tables whereas having redundant indexes can hurt the performance negatively.
Diagnosing a SQL Performance Issue in Production
We bumped into a Performance issue last week for one of our web application in Production. After doing some research and looking at Logic Monitor reports for web servers and database servers, we figured out that the Deadlocks and Lock Timeouts in the Database have increased considerably.
Generate millions of rows of test data for SQL Performance Analysis
Your application is bound to grow over a period of time. Sometimes it is critical to test your changes with a bigger workload than your current table size to identify any performance bottlenecks, well ahead of time. Leveraging automated tools to generate a workload for you to test your application makes your lives much easier.
Identify SQL Blocking Issues using Activity Monitor
Blocking in SQL Server occurs when a transaction in a database session locks resources that another transaction requires to read or modify. If your application has long term blocking, then you have a problem in your hands to resolve.
Double your Coding Speed using SQL Code Snippets
SQL Server Management Studio provides a cool feature called ‘Code Snippets’ which can help you to considerably increase your coding speed. Code Snippets are ready made snippets of code, which you can insert into your T-SQL code. As a result, you can type less and generate more code.
Live Query Statistics in SQL Server 2016
How many times have you come across a scenario when you execute a TSQL Query and it just runs and runs, without displaying any results and you wonder what’s going on – and finally end up cancelling the executing query?
Enhance Developer Productivity with CodeLens Code Health Indicator
In this blog, we will look at a very cool Visual Studio 2015 extension called ‘CodeLens Code Health Indicator’ and its features. This extension shows the current value of the Maintainability Index for our code and provides us insight into… Read More ›
Increase your Code Review efficiency with Visual Studio Code Metrics
In this blog, we will try to understand the importance of code reviews, classify types of design flaws and identify the code smells using Visual Studio Code Metrics. Why is Code Review important? In a development life cycle, Code Reviews… Read More ›
Manage your Technical Debt with Visual Studio 2015 and SonarQube
Are you worried about ‘Technical Debt’ in your project? In this blog, we will try to understand what Technical Debt is, what causes it, how to measure it and ultimately bring it down. What is Technical Debt? Everybody wants to write… Read More ›
Improving SQL Performance using Covering Indexes
What is a Covering Index? An index that contains all required information to resolve the query is known as a “Covering Index” – it completely covers the query. Covering Index includes all the columns, the query refers to in the… Read More ›
Increase your Coding Speed using Code Snippets in Visual Studio
Code Snippets are one of the coolest features of Visual Studio, which can help us to increase our coding speed multi-fold times. Good Developers generally use shortcuts and tricks to type less and generate more code in less time. Code… Read More ›
Performance Analysis using PerfTips in Visual Studio 2015
Troubleshooting Performance issues has always been a topic of discussion. As and when a performance problem is highlighted, developers tend to run a profiling tool, at their disposal, to diagnose the issue. Not having access or license for a profiling… Read More ›