Identifying records with special characters
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 to use, Developer Friendly, Best performance … Continue reading Starting with MS SQL Server
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 by one. SET ANSI NULL ON : … Continue reading SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
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. I will create two tables, PkTable – Having … Continue reading Consequences of Timeout/Error on a Delete statement
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 managing it? Let us start with … Continue reading A Basic Introduction of Database, Tables and SQL.
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 is the most important thing to … Continue reading Clustered Index and related Interview Questions
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 be a metadata* for the above. … Continue reading GAM and SGAM
Most Dangerous Command In SQL
How SQL store your data in Pages? What are Extents?