Skip to content
March 6, 2021
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training   Data Platform Virtual Summit 2020   Virtual Symposium   DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra
    • Virtual Symposium Recordings
    • Geek Talks
  • PodCasts
  • Conference
  • Resources
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
    • Connect With Amit Bansal
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
Main Menu

Author: Akash Gautam

SQL Server

SQL Server – Its -MS + SQLServer

February 16, 2013July 6, 2014 - by Akash Gautam - Leave a Comment

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 …

Read More
SQL Server

SQL Server Subquery – Tune your Subquery-2

September 28, 2012September 15, 2014 - by Akash Gautam - Leave a Comment

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 …

Read More
SQL Server

SQL Server Recovery Model Deep Dives

September 28, 2012September 15, 2014 - by Akash Gautam - Leave a Comment

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 …

Read More
SQL Server

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

August 22, 2012September 15, 2014 - by Akash Gautam - Leave a Comment

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 …

Read More
SQL Server

SQL Server Subquery – Tune your Subquery part 1

August 14, 2012September 15, 2014 - by Akash Gautam - 4 Comments.

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 …

Read More
SQL Server

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

August 2, 2012August 27, 2014 - by Akash Gautam - Leave a Comment

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 …

Read More
SQL Server

SQL Server – When it comes to lock index while update

July 31, 2012August 27, 2014 - by Akash Gautam - Leave a Comment

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 …

Read More

Subscribe to SQLServerGeeks

Ad

master classes

SSG_linkedin

SSG_fb

dps2017_logo_website

video courses

dps2017_logo_website

create your blog

guest_post

DataPlatformGeeks Social Media Channels

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by SQLServerGeeks and DataPlatformGeeks.