How to perform a large delete operation
Deleting data from your production databases can be tricky. You can either choose TRUNCATE or DELETE statements to suit your need. Here in this blog, I will focus more on…
How to tune SSRS Reports?
Let us not get into a discussion of why we are still talking about SSRS here and not some other fancy BI technologies like Power BI, Tableau, etc. I like…
What are partitions in SQL Server?
SQL Server supports table/index partitions that store multiple chunks of row data in different partitions. Starting in 2016 SP1, this is no longer just an enterprise edition-only feature. In a…
What is Business Intelligence?
You will find people defining BI, Business Intelligence in so many ways, and believe it or not all those different definitions do make sense for a specific need. In a…
How do you choose an index type?
Indexes are on-disk structures tied with a table/view that helps reduce I/O. Implementing a good indexing solution can have dramatic performance gains in the database. However, too many indexes will…
Database Files and Filegroups
Managing database files and filegroups appropriately will help with the availability of a database and of course its performance. FilesThere are at least two file types and you can have…
DBA tricks to tune SQL Server
In a perfect world, DBA installs SQL Server and clicks "Make my SQL Server run faster", and everyone's happy. But until Microsoft builds that switch, there are different configurations both…
Beyond Query Tuning
Writing efficient queries following best practices is a sign of a good database developer. However, for it to perform at the intended level there are more knobs to turn. Let…
Query Tuning – Best Practices
In my last post, I talked about how I measure query performances. Let's talk about some of the best practices around query design so that we do not have to…
How to enhance performance of SSIS Packages?
SQL Server Integration Services helps you move data from application databases to a reporting warehouse or just move data from point A to point B for other business reasons. Different…