N a g a s a i

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

Here are the key points about different types of keys in the relational model: 1. Candidate Key :    - It is a minimal set of attribut...

To get the key column list from indexes that are duplicates in SQL Server, you can use the following query: use databasename go WI...

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

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

In SQL Server, you can implement retry logic for transactions using T-SQL and error handling. Here's an example of how you can create a ...

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: ...

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

FREE Certificates ❯ DBMS, SQL http://learn.saylor.org/course/view.php?id=93 ❯ SQL http://openclassrooms.com/en/courses/2071486-retriev...

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

SQL injection is a type of web application security vulnerability and attack that occurs when an attacker is able to manipulate an applicati...

Recently we need to look for a procedure where we are using in SQL Jobs. There is no easy way to find unless you script all jobs and find in...

Microsoft SQL Server Management Studio (SSMS or S.S.M.S.) is the integrated environment for managing your SQL Server infrastructure. SQL Se...

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

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

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

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

Install SSDT with Visual Studio 2019 If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT. If you...

Starting with Visual Studio 2017, the functionality of creating Database Projects has been integrated into the Visual Studio installation. T...

Here is how you can get column names from specified table SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = ...