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

Creating and altering scripts in SQL Server can be essential for database management and development. Here’s a more detailed guide on how to...

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

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

❯ Python ➟ Corey Schafer ❯ SQL ➟ Joey Blue ❯ Data Analyst ➟ AlexTheAnalyst ❯ Tableau ➟ Tableau Tim ❯ PowerBI ➟ Guy in a Cube ...

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

Here is the issue,  you cannot call a non-deterministic function from inside a user-defined function. So there is a workaround, By creatin...

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

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