SUM FUNCTION

SQL Server - SA Account

'DHYAN' An Attention

Configure the max degree of parallelism Server Configuration Option

SQL Server - LAG (Transact-SQL) https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16

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

Average Function

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

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

Some of the SQL Server 'G' Diamonds

Auto Deletion

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

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

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

DAC

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

Remove Existing Column

Here is the concept to create MSSQL - Environment with Expiry

 'CHW' I mean to say Cumulative Updates and Hotfix detail with Window Update Links

Query to find duplicate records

HotFixes  - Logshipping