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

In SQL Server, you can review the transaction order and lock acquisition by analysing the queries and transactions that are being executed 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....

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

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

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error or ole db...

Use below query to increase default time out or disable time out time. USE ps; GO EXEC sp_configure 'remote query timeout' , 0...

-- SQL Server 2000/2005/2008/2008R2/2012 SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ),...

Here is how we get first day and last day of the year. DECLARE @ Year int set @ Year = 2018 select DATEADD( year ,0,DATEADD( year ,@...