Table valued parameters (TVP)

Table values parameters
How we can pass multiple rows in stored procedure or function as a parameter?
Table-valued parameters are a new...

Handling decimal and non numeric types using Case statement

Hi Guys

Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

on 10th oct 01.30 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ sqlsaturday,...

Implementation of Data Compression – SQL Server

Data Compression
Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of...

Trace Flags in Azure SQL Database

One of the ways that you take more direct control over your SQL Server instances is through the use of...

SQL Source Control and Git–Getting Started

It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS...