Showing posts with label SQL Server 2019. Show all posts
Showing posts with label SQL Server 2019. Show all posts
Wednesday, April 24, 2024

Understanding Indexing in SQL Server: Types and Usage

›
What is an Index?    An index in SQL Server is a data structure associated with a table or view that speeds up the retrieval of rows based...
Wednesday, March 13, 2024

How to Review transaction order and lock acquisition in SQL Server

›
In SQL Server, you can review the transaction order and lock acquisition by analysing the queries and transactions that are being executed a...
Tuesday, March 12, 2024

What is deadlock priority and how to address in SQL Server

›
In SQL Server, deadlock priority is a mechanism that allows you to influence the selection of the transaction that will be chosen as the dea...
Sunday, March 03, 2024

How to find a view in database where its used in SQL Server

›
To find where a specific view is used in a SQL Server database, you can query the system catalog views. Here's a query to achieve this: ...
Friday, February 02, 2024

Removing Cached login and password list in SQL Server Management Studio

›
You need to look in following location based on the SSMS Instance you have in your local PC. Since mine is 19.0 version, Below is my path....
Sunday, June 18, 2023

How to implement impersonation in SQL Server

›
To implement impersonation in SQL Server, you can follow these steps: 1. Create a Login : First, create a SQL Server login for the use...
Friday, June 02, 2023

How to get comma separated values from SQL

›
There are few types where you can get comma separated values form SQL SERVER using SQL 1. XML PATH method: SELECT STUFF(( SELEC...
Thursday, February 09, 2023

How to Find Tables that Contain a Specific Column in SQL Server?

›
Basic concept to understand about SQL Server is that of catalog views, which are effectively database tables (catalogs in this case) that di...
Thursday, December 01, 2022

How to check active transactions in SQL Server

›
A transaction is a single unit of work. If a transaction is successful, all of the data modifications made during the transaction are commit...
Wednesday, November 16, 2022

What is the Query to display the failed SQL Jobs

›
We can get this information by the standard reports available in SQL Server, right click on SQL server agent> Standard reports and select...