HOLs_Admin

/HOLs Admin

About HOLs Admin

This author has not yet filled in any details.
So far HOLs Admin has created 68 blog entries.

Hands-On-Lab: SQL Server Advanced Query Tuning

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Advanced Query Tuning. This lab talks about a very common yet difficult problem, finding TOP n rows per group. The problem may seem easy, however in this lab we’ll discuss multiple ways to solve this problem and compare the different ways on performance [...]

By |July 10th, 2020|HOLs|0 Comments

Hands-On-Lab: SQL Server Advanced Aggregations

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Advanced Aggregations. To meet various business requirements, sometimes we need to calculate cumulative aggregations, sliding window aggregations, Year-To-Date aggregations. This lab is divided into four exercises. In the first exercise, we will learn about cumulative aggregations and will learn to find running total [...]

By |July 9th, 2020|HOLs|0 Comments

Hands-On-Lab: Working With SEQUENCE in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working With SEQUENCE in SQL Server. In Transact-SQL (T-SQL) 2012 SEQUENCE is a user-defined object to generate sequence of numbers based on the specifications while created. NEXT VALUE FOR function generates sequence number from the specified SEQUENCE object. This lab is divided into six exercises [...]

By |July 8th, 2020|HOLs|0 Comments

Hands-On-Lab: Pivoting in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Pivoting in SQL Server. To understand and analyze the data in more efficient way, we may have to rotate rows into columns and columns into rows. The rotation of rows to columns is called pivoting and the reverse operation is called unpivoting. This lab explains [...]

By |July 7th, 2020|HOLs|0 Comments

Hands-On-Lab: Optimizing SQL Server Stored Procedures

Hello Friends, Here is another popular lab from Hands-On-Lab library: Optimizing SQL Server Stored Procedures. Whenever an application is performing slowly because of database, then we need to optimize the stored procedures in that database. This lab is divided into three exercise explaining various techniques that are used to optimize the stored procedure such as [...]

By |July 6th, 2020|HOLs|0 Comments

Hands-On-Lab: OFFSET and FETCH in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: OFFSET and FETCH in SQL Server. In Transact-SQL (T-SQL) 2012 OFFSET-FETCH clause provides us an option to fetch page of results from the result set. This lab is divided into six exercises explaining different usages of OFFSET-FETCH clause such as skip few rows from the [...]

By |July 4th, 2020|HOLs|0 Comments

Hands-On-Lab: Merging Data in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Merging Data in SQL Server. MERGE statement is used to modify data in a target table based on data in a source table. The statement joins the target to the source by using a column which is common to both the tables. We can INSERT, [...]

By |July 3rd, 2020|HOLs|0 Comments

Hands-On-Lab: Logical and Physical Query Processing in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Logical and Physical Query Processing in SQL Server. In this lab, we’ll learn about how a query is logically and physically processed in SQL Server. In the first exercise, we will learn about logical execution order of the statements in select clause. In the second [...]

By |July 2nd, 2020|HOLs|0 Comments

Hands-On-Lab: LAG and LEAD Functions in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: LAG and LEAD Functions in SQL Server. In Transact-SQL (T-SQL) 2012 LAG & LEAD are the new analytical functions. LAG access data from the previous row in the same result set without the use of self-join. LEAD access data from a subsequent row in the [...]

By |July 1st, 2020|HOLs|0 Comments

Hands-On-Lab: JSON Support in SQL Server 2016

Hello Friends, Here is another popular lab from Hands-On-Lab library: JSON Support in SQL Server 2016. JSON is a short form of Java Script Object Notation which is a simple and lightweight format for exchanging data between multiple sources. The main advantage of using JSON is, it is easy to read. SQL Server 2016 empowers [...]

By |June 30th, 2020|HOLs|0 Comments

Hands-On-Lab: Inserting Data in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Inserting Data in SQL Server. In Transact-SQL (T-SQL) INSERT allows us to add one or more rows into a table. In this lab we’ll learn different ways to insert data into a SQL Server table. In first exercise we will learn to insert a single [...]

By |June 29th, 2020|HOLs|0 Comments

Hands-On-Lab: Error Handling in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Error Handling in SQL Server. Error Handling is very essential in every programming language, similarly in SQL server we have multiple built in functions to handle errors that may occur in TSQL code. This lab is divided into six exercises explaining different types of Error [...]

By |June 27th, 2020|HOLs|0 Comments

Hands-On-Lab: Deleting Data in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Deleting Data in SQL Server. In Transact-SQL (T-SQL) DELETE allows us to remove one or more rows from a table. This lab is divided into five exercises explaining different ways of deleting data from a table. In first exercise we will learn to delete duplicates [...]

By |June 26th, 2020|HOLs|0 Comments

Hands-On-Lab: Delete vs Truncate in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Delete vs Truncate in SQL Server. The biggest myth ever in SQL Server is TRUNCATE operation cannot be rolled back whereas DELETE operation can, as DELETE operation fills the transaction log with enough details to rollback which is not in the case of TRUNCATE. This [...]

By |June 25th, 2020|HOLs|0 Comments

Hands-On-Lab: Constraints in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Constraints in SQL Server. Constraints in SQL server are used to enforce rules for the data to be stored in a table. If any rule violation happens, the corresponding constraint will abort the invalid action which is against the rules. We have six constraints in [...]

By |June 24th, 2020|HOLs|0 Comments

Hands-On-Lab: Analyzing Minimally Logged Operations in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Analyzing Minimally Logged Operations in SQL Server. Inserting lot of records at once in SQL Server not only generates lot of transaction log records but also slows down performance because of exclusive locks being held for long time on the table the data is being [...]

By |June 23rd, 2020|HOLs|0 Comments

Hands-On-Lab: SQL Server Memory – Monitoring Buffer Pool

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Memory – Monitoring Buffer Pool. Monitoring memory utilization by each object is very critical when troubleshooting SQL Server Memory issues. In this lab, we will learn to monitor buffer pool utilization per each object in a database and also will learn about CHECKPOINT [...]

By |June 22nd, 2020|HOLs|0 Comments

Hands-On-Lab: SQL Server Tempdb

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Tempdb. Monitoring tempdb is critical as most of the user workloads which are doing heavy sorts and hashing may require tempdb space. Few of those operations may cause out of disk space scenarios which in-turn causes system breakdown. In this lab, we will [...]

By |June 20th, 2020|HOLs|0 Comments

Hands-On-Lab: SQL Server Thread Life Cycle

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Thread Life Cycle. Every single workload that SQL Server executes requires a thread. Knowing how a thread goes into different states in its life cycle of execution is very critical while trouble shooting slow running workloads. In this lab, we will understand the [...]

By |June 19th, 2020|HOLs|1 Comment

Hands-On-Lab: Using Query and Table Hints in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Using Query and Table Hints in SQL Server. Many administrators address performance problems solely by tuning system-level server performance: for example, memory size, type of file system, number and type of processors, and so on. However, many performance problems cannot be resolved this way. They [...]

By |June 18th, 2020|HOLs|0 Comments