SQL Server Videos (Short Tutorials & Demos)
In this video, you will learn to use RANK() function in SQL Server. RANK () is one of the four Ranking Functions that are available in SQL Server. 1. ROW_NUMBER() 2. RANK() 3. DENSE_RANK() 4. NTILE(N) In one of our previous videos we have already discussed about ROW_NUMBER() function, you can watch that video here: [...]
In this video, you will learn to get back truncated data using backup and restore mechanism. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy [...]
In this video, you will learn about whether Truncate can rolled back or not? Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]
Here is a quick technique to record performance counters data in SQL Server. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]
There are many ways of monitoring SQL Server pressure. Here is a quick demo. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]
The first step towards troubleshooting Tempdb growth is to understand where is the space being used. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy [...]
When you have dozens of databases hosted in a single instance, it helps to narrow down on databases that are contributing towards maximum IO reads and writes. In other words we are trying to narrow down on databases that are consuming maximum IO. Get new content directly in your inbox - Click here You can [...]
When you have dozens of databases hosted in a single instance, it helps to narrow down on databases that are contributing towards maximum CPU cycles. Let's say you are running SQL Server in a hosting environment where the instance is hosting hundreds of small databases, each belonging to a different client. Your hosting company is [...]
Even with the fastest of CPUs and Storage, Page Splits are still very bad. Also leads to fragmentation. Here is a quick video that shows how you can capture page splits using extended events. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more [...]
Age old topic but still very important even in the age of SSDs. Page splits and fragmentation concepts were one of those early things we learned while learning about SQL Server architecture. Years later, with the advent of ultra-fast storage, the importance of these concepts has diminished but they are not irrelevant. Data in SQL [...]
Not sure whether to call this Query Tuning or Index Tuning, anyway, all that matters is we get improved performance. Life is just so easy when you have to deal with single-column indexes. They are lovable. In contrast, multi-column indexes bring so many complexities along with them. Let's dig a bit deeper. In a multi-column [...]
This is a follow up video to part 1. In this quick video you will see that SQL Server is better off with explicit conversion at it likes it. Implicit conversions are not a good thing for SQL Server. Your queries are silently suffering from performance issues and consuming extra CPU cycles while implicitly converting [...]
In this quick video you will understand the concept of implicit conversions and why are they bad for your query performance. Implicit conversions are not a good thing for SQL Server. Your queries are silently suffering from performance issues and consuming extra CPU cycles while implicitly converting from one data type to another. For example, [...]
In this quick video you will understand how to enable global trace flags. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]
The Buffer Pool is the largest memory consumer inside SQL Server. This memory is used to host the data and index pages. Each buffer is 8KB in size and the content of the data/index page is loaded in the buffer space. The buffer pool is mostly managed automatically and SQL Server does a great job [...]
This is one among those thousands of architectural beauty inside SQL Server engine that make me fall in love with it. When you send your query to SQL Server, sometimes, it may need an extra memory grant for its execution. For example, let's say the query has an expensive sort to deal with. While the [...]
This video is a follow up to CXPACKET video (Part 1). You will see that SQL Server Query Execution Engine still assign max number of threads (as per the number of cores (up to a max of 64)) even when the DB engine is under severe pressure. In today's note, I wish to pen down [...]
Really, cannot think about query tuning without these two DMVs - sys.dm_exec_query_stats and sys.dm_exec_procedure_stats. For the sake of simplicity, I will refer to them as QS and PS, respectively. Query Stats (QS) DMV will give you query-level metrics and Procedure Stats (PS) DMV will give you stored procedure-level metrics. DMV stands for Dynamic Management Views. [...]
In SQL Server, you can create single-column and multi-column indexes. Life is beautiful and easy with single-column indexes and full of ups & downs with multi-column indexes. With single-column indexes, SQL Server has to deal with only one column - just go to a value in the column and start seeking from that point. With [...]
In this video, you will understand how to setup windows debugger and get ready to debug windows with public symbols Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was [...]
