HOLs_Admin

Home/HOLs Admin

About HOLs Admin

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

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, [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

Hands-On-Lab: Troubleshooting SQL Server with WinDbg

Hello Friends, Here is another popular lab from Hands-On-Lab library: Troubleshooting SQL Server with WinDbg. Windbg is a multipurpose debugger for Microsoft Windows operating system. It can be used to debug problems with Visual Studio, SQL Server and other Microsoft applications. In this lab we’ll learn to use Windbg and explore few of the basic [...]

Hands-On-Lab: Troubleshooting Metadata Corruption in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Troubleshooting Metadata Corruption in SQL Server. Database corruption is one of the nightmares in the life of a DBA. We store precious data in databases and each day the dataset grows bigger and bigger. A database corruption issue not only puts the data at risk, [...]

Hands-On-Lab: Temporal Tables in SQL Server 2016 – Part 2

Hello Friends, Here is another popular lab from Hands-On-Lab library: Temporal Tables in SQL Server 2016 – Part 2. This lab talks about the use cases of temporal tables. In the first exercise, we will learn to perform point-in time analysis using temporal tables. In the second exercise, we will learn to perform data audit [...]

Hands-On-Lab: Temporal Tables in SQL Server 2016 – Part 1

Hello Friends, Here is another popular lab from Hands-On-Lab library: Temporal Tables in SQL Server 2016 – Part 1. SQL Server 2016 introduces a new feature called Temporal tables/ System versioned temporal tables which helps us in performing point in time analysis, data auditing and repairing Row-Level Data Corruption. In this lab, we will learn [...]

Hands-On-Lab: Stretch Database

Hello Friends, Here is another popular lab from Hands-On-Lab library: Stretch Database. The Stretch Database feature securely and transparently archives your cold or historical data from a local SQL Server database to Azure SQL Database. This is a new feature in SQL Server 2016. You can either move a complete SQL Server table data from [...]

Hands-On-Lab: SQL Server Plan Cache Recompilation and Reuse

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Plan Cache Recompilation and Reuse. Before a query batch begins execution on SQL Server, the batch is compiled into a plan. The plan is then executed for its effects or to produce results. The compilation of execution plans is a relatively expensive operation [...]