N a g a s a i

​Exciting news for aspiring developers! Scrimba has just launched its Fullstack learning path, offering a suite of interactive, in-browser c...

Here is how we can find a table or view in SQL database. Below query will help you find the table or view and which object has used. se...

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

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

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

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

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

We’ll use the function EOMONTH() to find the last day of the month. DECLARE @ fromdate DATETIME, @ EOMMonthdate DATETIME SET @ from...

At some point in time we’ve all had to find out how many rows are in a table. The first answer you’ll usually get when you ask someone how t...

Here is how we can get current time zone from sql server DECLARE @TimeZone VARCHAR(50) EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE...

Here is how you can get via SQL Query, This works on any SQL Server version USE database_name GO -- Get Backup History for required datab...

Here is the query below that can pull all above results. Declare @ VName varchar( 256 ) Declare Findlinked cursor LOCAL STATIC FORWA...

Open SQL Server Management Studio (SSMS) and connect to SQL Server. Run below query to find version and edition of SQL server. SELECT ...