SQL Server - SUM, COUNT, and AVG Functions

SUM FUNCTION

SQL Server - SA Account

SQL Server - SA Account

SQL Server - 'DHYAN' An Attention

'DHYAN' An Attention

SQL Server - MaxDOP Configuration

Configure the max degree of parallelism Server Configuration Option

SQL Server - LAG Funtion

SQL Server - LAG (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16

SQL Server - Sample and Model Database

Sample Database

https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16

SQL Server - AVG function

Average Function

SQL Server - OLE Automation Procedure

How to enable OLE automation procedures to be able to execute OA procedures

SQL Server - Merge Column

Here we will learn on how can we combine two or more columns in a SQL query.

 

SQL Server - G Diamonds

Some of the SQL Server 'G' Diamonds

SQL Server - Auto Delete

Auto Deletion

SQL Server - ENTRE

'ENTRE'  is nothing but one thing in common as it starts from 'E' and ends at 'E' only.

SQL Server - Nomenclature

       Are you KEEN to know major components from SDS's Nomenclature while FACING performance issue?

SQL Server - Matching Role

Its quite common that sometime we give role that doesn't suit with the actual requirement.

SQL Server - Dedicated Admin Connection

DAC

SQL Server - Stored Procedure Into table

Here some steps to capture the procedure's output into temp table.  

SQL Server - Remove Existing Column

Remove Existing Column