Log in | Register

Akash Gautam, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Akash Gautam, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

AkashGautam

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

About Akash Gautam

This author has not yet filled in any details.
So far Akash Gautam has created 7 entries.

SQL Server – Its -MS + SQLServer

I love giving interviews, one of the question asked in one of my interview question was “on which particular edition automatic page repair is possible (in context of database mirroring)”.

That became a nightmare question for me as I had never heard like edition specific features for database mirroring, still I answered standard and enterprise […]

SQL Server Subquery – Tune your Subquery-2

Here goes my 2nd part of Tune your SQL Server subquery

Well,if my query is having UNION operator,we normally replace it by UNION ALL to improve performance

According to itzik-ben gan

UNION ALL returns one resultset with all rows from both inputs. UNION returns one result set with the distinct rows from both inputs.

I will show here […]

By |September 28th, 2012|Categories: SQL Server|Tags: , |0 Comments

SQL Server Recovery Model Deep Dives

Hello friends

One of the Fav question asked in most of the interviews is to explain diff SQL Server recovery model .

All they want to listen from you is word “Minimally logged”.

Actually there are two types of Logging physical logging and logical logging ,most of the database systems use physiological logging.Logical logging involves logging logical […]

SQL Server IAM Pages – So you know your IAM Page number

Hi Guys

Sorry for discontinuation from tune your queries.I was preparing for a interview and got to know very intresting thing.

As a DBA we all know about SQL Server IAM pages but exactly its page number is little bit difficult because when you run

first_iam_page  root_page

0x9D0000000100 0x9E0000000100

i am not putting screenshot bt its a hexadecimal value […]

By |August 22nd, 2012|Categories: SQL Server|Tags: |0 Comments

SQL Server Subquery – Tune your Subquery part 1

Hello,

As a DBAs we get lot of request to tune queries and we normally suggest to create Index or Update Statistics but tuning also needs rewriting of actual query and the normally performance Issue is caused by lot of Nested SQL Server Subquery.

So here is a demo what I want to write, soon ill […]

By |August 14th, 2012|Categories: SQL Server|Tags: |4 Comments

SQL Server – When it comes to lock index while update-2

Locking behaviour of Indexes while updating rows

Hello all,

The theory I am presenting you is from Reading in database systems and I find it valuable

Today I will discuss about locking mechanism at index level, I had used extended events to show a demo. Whenever we update on Heap pages or the table which doesn’t have […]

By |August 2nd, 2012|Categories: SQL Server|Tags: |0 Comments

SQL Server – When it comes to lock index while update

Its my first blog so want to dedicate someone and make it special in some ways.

You cann’t use it practically but it will clear some of your concepts.

I have a table with clustered index , they say update stmt locks data records but what about index records.

I am referring index records by root and […]

By |July 31st, 2012|Categories: SQL Server|Tags: , |0 Comments
Newsletter_Footer