Search SQL Server content

The correct cardinality estimation using table variable

Hi Friends, In my previous blog post, we have seen that SQL Sever estimates number of rows in a table variable was 1. Now the question is, Is there any way to make the correct estimation for the number of rows while using table variable? My today’s blog post is focused on the correct cardinality […]
Read More »

Mixing OLTP and DW - A Tale of Seven Wonders - Wonder 6

Hello Geeks, Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]
Read More »

Nested Loop Join - Temp Table versus Table variable

Hi Friends, In my previous blog post, I have shown you the working of nested loop join in SQL Server. Today, I am going to show you the Nested Loop Join – Temp Table versus Table variable. Before executing a query, SQL Server generates an estimated execution plan on the basis of various server settings […]
Read More »

Nested Loop Join Internals

Hi Friends, Today, I am going to show you Nested Loop Join Internals in terms of performance. Generally, we write a query in SSMS and then submit it to SQL Server for execution. In the query, there may be join conditions like an inner join, outer join, self join, etc. all these are the logical […]
Read More »

Data Platform Day in Hyderabad, Bangalore, Mumbai & Gurgaon in Jan/Feb 2016

Dear SQL Geek, Warm wishes for the New Year from SQLServerGeeks Team. We are back with our most popular free event, SQL Server Day. But starting this year, SQL Server Day has been re-christened as Data Platform Day to reflect a global trend. This is our first event after the success of Asia’s First SQL […]
Read More »

Reserved threads and Used threads in parallelism

HI Friends, We know about parallelism in SQL Server i.e. SQL Server uses multiple threads for the processing of a request to make it faster.  Two main important settings for the decision of going with parallelism are: MAXDOP: Maximum degree of parallelism, This value represents, how many threads can be used for parallel processing. The […]
Read More »

Space Monitoring - A Tale of Seven Wonders - Wonder 5

Hello Geeks, Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]
Read More »

Forward and Backward Scan

Hi Friends, First of all wish you all a very Happy New Year 2016. I hope this new year will bring lots of joy and happiness in your life. Today, I’ll show you the Forward and Backward Scan. We all knew that whenever we  create an index (Clustered or Non-Clustered) on a table in SQL […]
Read More »

Max Server Memory - A Tale of Seven Wonders - Wonder 4

Hello Geeks, Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]
Read More »

Read-Ahead Reads in SQL Server

Hi Friends, There is a mechanism known as Read-Ahead Reads in SQL Server to read the pages in a buffer before getting the request from query. By default, this feature is enabled in the SQL Server. Have you ever tested the performance impact in terms of IO and Execution time? So today I am going […]
Read More »

Auto Shrink - A Tale of Seven Wonders – Wonder 3

Hello Geeks, Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]
Read More »

T-SQL to create the File Group and Files

Hi Friends, Below is the simple T-SQL to create File Group and Files for a database and adding multiple files under that file group. Here you can specify values as per your requirement like: 1- Database Name under which you wants to add file group. 2- Name of the file group. 3- Number of files, […]
Read More »

ADMIN? - A Tale of Seven Wonders - Wonder 2

Hello Geeks, Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]
Read More »

Fill Factor versus Record Length

Hi Friends, Almost all of us knows about Fill Factor in SQL Server. For those who don’t know about Fill factor, Book online defines Fill Factor as mention below: “The fill-factor option is provided for fine-tuning index data storage and performance. When an index is created or rebuilt, the fill-factor value determines the percentage of […]
Read More »

Security?

Before we start the same old story, let’s understand “Why?” Why security is so much important even to leadership / higher management? Why auditors are always asking so many questions around it? The answer is pretty simple; Data is like life blood to any business & no business can afford to lose its data. To […]
Read More »

Maintenance Plans - A Tale of Seven Wonders - Wonder 1

Hello geeks, Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Awww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]
Read More »

Non Clustered Index Key Length in SQL Server 2016 CTP 3.0

Hi Friends, We all are aware about clustered and non clustered indexes in SQL Server. We are also aware about limitation of Non clustered index key length i.e. 900 bytes. That means you can’t have key length data size more than 900 bytes. I tried to explain the same thing in one of my blog […]
Read More »

Backup and Restore Sequence in SQL Server

Hello Geeks, The time is flying by as I rejoice in the aftermath of the SQLServerGeeks Annual Summit 2015. It has been a wonderful event and once in a life time opportunity to be part of the Asia’s first SQL conference. More eventful was my personal life with the arrival of my princess Mahira on […]
Read More »

Fixed and Variable length data type char() versus varchar()

Hi Friends, This blog is focused on Fixed and Variable length data type char() versus varchar(). During the creation of any new table, we take the decision for data types. Here we will see one interesting scenario which you have to keep in mind during the selection of data types. Let say we have a […]
Read More »

Announcing The President & The Vice President for 2015 – 2017 Term

Hi Friends, Here comes the much awaited post from me. To be honest, I was just reeling in the success of Asia’s First SQL Conference Since last one year SSG Team was working rigorously to make sure you have a great time at SQLServerGeeks Annual Summit 2015. It was a long & a tough journey […]
Read More »

Older