Skip to content
October 3, 2023
  • 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 Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • 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
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • Premium Content (SQLMaestros)
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
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 …

SQL Server – Its -MS + SQLServer 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 …

SQL Server Subquery – Tune your Subquery-2 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 …

SQL Server Recovery Model Deep Dives 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 …

SQL Server IAM Pages – So you know your IAM Page number 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 …

SQL Server Subquery – Tune your Subquery part 1 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 …

SQL Server – When it comes to lock index while update-2 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 …

SQL Server – When it comes to lock index while update Read More

Looking for Premium SQL Content?
Check out advanced SQL tutorials
on SQLMaestros


Subscribe to SQLServerGeeks

Free Live Event


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

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

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.