-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLdose

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.

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL.

Now let us start with basic of Microsoft SQL Server and how to work with it. I am a fan of MS SQL Server. It is easy… Read more

1 comments, 343 reads

Posted in SQLdose on 10 April 2016

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

Hi Guys,

When you generate a script to create a Stored Procedure, below three statements are generate by default.

SET ANSI_NULLS on

SET NOCOUNT on

SET QUOTED_IDENTIFIER on

Why do we need these. Why Management Studio thinks we would require these options. Let us understand each one of these one… Read more

0 comments, 3,689 reads

Posted in SQLdose on 17 December 2015

Consequences of Timeout/Error on a Delete statement

Hello Guys,

Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or Timeout, will already deleted data will be rolled back, considering we do not have any transaction? “

My previous Answer was NO, After I executed the below statements. Read more

4 comments, 2,264 reads

Posted in SQLdose on 21 October 2015

Consequences of Timeout/Error on a Delete statement

Hello Guys,

Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or Timeout, will already deleted data will be rolled back, considering we do not have any transaction? “

My previous Answer was NO, After I executed the below statements. Read more

4 comments, 295 reads

Posted in SQLdose on 21 October 2015

A Basic Introduction of Database, Tables and SQL.

It seems to be the most basic thing but this post is specifically to those who have just started or want to start their career in Database Domain. When you are a novice. You have only idea about what is a Database. But in practical life how companies are actually… Read more

7 comments, 231 reads

Posted in SQLdose on 20 October 2015

A Basic Introduction of Database, Tables and SQL.

It seems to be the most basic thing but this post is specifically to those who have just started or want to start their career in Database Domain. When you are a novice. You have only idea about what is a Database. But in practical life how companies are actually… Read more

7 comments, 2,597 reads

Posted in SQLdose on 20 October 2015

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, binary and clustered. Lets move on to non clustered index(NCI).

NCI for me is the most mysterious object in SQL Server. The way SQL Server work with… Read more

0 comments, 246 reads

Posted in SQLdose on 4 October 2015

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, binary and clustered. Lets move on to non clustered index(NCI).

NCI for me is the most mysterious object in SQL Server. The way SQL Server work with… Read more

0 comments, 193 reads

Posted in SQLdose on 4 October 2015

Clustered Index and related Interview Questions

Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I was trying to avoid this one, as I believe there is lot already written about it. But I cant anymore, after all my life is at stake. :p
Indexing… Read more

5 comments, 223 reads

Posted in SQLdose on 20 September 2015

Clustered Index and related Interview Questions

Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I was trying to avoid this one, as I believe there is lot already written about it. But I cant anymore, after all my life is at stake. :p
Indexing… Read more

5 comments, 293 reads

Posted in SQLdose on 20 September 2015

GAM and SGAM

In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for previous blog:  https://sqldose.wordpress.com/2015/08/30/how-sql-store-your-data/ )

But how SQL Server maintains information about the pages? How SQL Server know which page is free and which has been allocated?  There has to… Read more

3 comments, 303 reads

Posted in SQLdose on 12 September 2015

GAM and SGAM

In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for previous blog:  https://sqldose.wordpress.com/2015/08/30/how-sql-store-your-data/ )

But how SQL Server maintains information about the pages? How SQL Server know which page is free and which has been allocated?  There has to… Read more

3 comments, 319 reads

Posted in SQLdose on 12 September 2015

The most dangerous command in sql

GUYS,

I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the most dangerous sql command that you can execute. Just read and enjoy. Do not implement.

http://www.sqlskills.com/blogs/paul/dbcc-writepage/


Read more

0 comments, 536 reads

Posted in SQLdose on 31 August 2015

The most dangerous command in sql

GUYS,

I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the most dangerous sql command that you can execute. Just read and enjoy. Do not implement.

http://www.sqlskills.com/blogs/paul/dbcc-writepage/


Read more

0 comments, 1,262 reads

Posted in SQLdose on 31 August 2015

How SQL store your data?

What happens when you create a table?

Have you ever give it a thought, how sql server actually managing your table? Where is your data actually got stored?

If yes, then you are equally passionate about sql server. Which means you are a competitor and we might be fighting for… Read more

7 comments, 543 reads

Posted in SQLdose on 30 August 2015

How SQL store your data?

What happens when you create a table?

Have you ever give it a thought, how sql server actually managing your table? Where is your data actually got stored?

If yes, then you are equally passionate about sql server. Which means you are a competitor and we might be fighting for… Read more

7 comments, 422 reads

Posted in SQLdose on 30 August 2015