HOLs

/HOLs

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

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

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

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

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

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

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

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

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