I am a senior software programmer who is still working hard to get a DBA hat. I am in love with SQL Server. SQL Server for me is all about passion. I am MCSA in SQL Server. Through this blog I am giving myself an opportunity to learn more about SQL, as well as sharing my knowledge and expertise with the world.

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...

2015-10-04

305 reads

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...

2015-10-04

389 reads

GAM and SGAM

In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...

2015-09-12

434 reads

GAM and SGAM

In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...

2015-09-12

615 reads

Blogs

Power BI – Hungry Median

By

Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...

Top 10 Must-Ask Questions Before Going to the Cloud

By

After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Read the latest Blogs

Forums

error while running Replication

By atulyan.aries

Has anyone faced this error Agent message code 20037. The process could not bulk...

Run Azure Automation Runbook Against DB Hosted on an Azure VM

By dan-404057

Hi - has anyone created a PowerShell runbook which connects to a database hosted...

The Compression Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Compression Type

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers