N a g a s a i

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

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

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

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

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

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

Best thing to resolve this to add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) s...

In Microsoft SQL server 2000 and 2005, as part of the ‘BACKUP LOG’ command, there was an option to truncate the log file, without storing a ...

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