How to Use Default and Custom Widgets in SQL Server Operations Studio
There are already a number of articles and blog posts that reveal the benefits of the SQL...
The Art of Aggregating Data in SQL from Simple to Sliding Aggregations
Let us start our SQL journey to understand aggregating data in SQL and types of aggregations including simple and sliding aggregations....
Calculating Running Total with OVER Clause and PARTITION BY Clause in SQL Server
You often come across scenarios where you have to calculate a running total of a quantity. A running total refers to the sum of values in...
Understanding the Importance of Memory Setting in SQL Server
Memory is one among the resources forming the performance triangle—CPU and storage being the...
SQL Server Table Partitioning and Partitions Tutorial
Problem In this article, we will focus on the demonstration of table partitioning. The simplest explanation of table partitioning can be...
Microsoft SQL Operations Studio: Configuration and Querying
In my previous article, Microsoft SQL Operations Studio: Understanding and Installation, we discussed deeply the need for a new SQL Server...
Microsoft SQL Operations Studio: Understanding and Installation
SQL Server Management Studio is considered as the default integrated graphical user interface tool...
Grouping Data using the OVER and PARTITION BY Functions
The OVER and PARTITION BY functions are both functions used to portion a results set according to specified criteria. This article explains...
Restoring Database with CDC Enabled
In this post, I am going to talk about an issue I found while restoring a backup of CDC enabled database to a different SQL instance. You...
SQL Server – Dissect the Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction...
