Arun Sirpal

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

All authors

All authors

Blogs

Monday Monitor Tips: Projecting Disk Space

By

One of the things that many DBAs struggle with is managing space across an...

SQL from A to Z: Your Path to SQL Mastery this Fall

By

I'm excited to tell you about the "SQL from A to Z" learning track....

Introduction to Advanced Analytics

By

The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

problem with PIVOT Table

By DaveBriCam

Thanks in Advance! I'm having trouble grouping all counts and sums on one line...

Merge rows in SQL

By Neils

I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...

Visit the forum

Question of the Day

AUTO_DROP Statistics

In SQL Server 2022, what does this statement do? 

CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ON

See possible answers