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: Sachin Nandanwar

SQL Server

SQL Server: Is Replication Recovery Model dependent ?

July 7, 2011November 17, 2014 - by Sachin Nandanwar - 1 Comment

There is a myth that for replication to work properly the databases always have to be in Full recovery mode. Well that is not at all true. First let me give …

SQL Server: Is Replication Recovery Model dependent ? Read More
SQL Server

SQL Server Phantom Reads In Repeatable read ??? I dont think so….

June 16, 2011December 15, 2014 - by Sachin Nandanwar - Leave a Comment

According to BOL Repeatable transaction isolation level will give a repeated (consistent) view of the data for that particular resultset in a transaction.Here is the exact definition “Specifies that statements cannot …

SQL Server Phantom Reads In Repeatable read ??? I dont think so…. Read More
SQL Server

Sparse Columns in SQL Server 2008

May 4, 2011December 18, 2014 - by Sachin Nandanwar - 2 Comments.

Prior to SQL Server 2008 there was a lot of space wastage due to the storage of the NULL bitmaps for tracking NULL values in columns defined as NULL.SQL reserves the …

Sparse Columns in SQL Server 2008 Read More
SQL Server

SQL Multiply all values in a column

April 13, 2011December 18, 2014 - by Sachin Nandanwar - Leave a Comment

Hi, Most of you reading this blog must be aware that SQL Server has an aggregate function called SUM to add all the values in a column.But what if you want …

SQL Multiply all values in a column Read More
SQL Server

Ghost Records in SQL Server… Now whats that ????

April 10, 2011December 18, 2014 - by Sachin Nandanwar - Leave a Comment

I always wondered what happens when a row is deleted from a table.Does SQL server directly overwrites the record or makes it invalid or it does something which is undocumented.Little bit …

Ghost Records in SQL Server… Now whats that ???? Read More
SQL Server

SQL Server Index Range query

April 8, 2011December 18, 2014 - by Sachin Nandanwar - Leave a Comment

There is a myth going around that for columns which are used as predicates always should have a clustered index which is backed up  and recommended by  Micorsoft  http://technet.microsoft.com/en-us/library/ms190639. aspx Let us …

SQL Server Index Range query Read More
SQL Server

SQL Server: Sum of values for Time Slots

April 5, 2011August 28, 2014 - by Sachin Nandanwar - Leave a Comment

I had a bit of an unusual task where I needed to find the sum of values in between specific time interval slot for dates.Below is a small sample of the …

SQL Server: Sum of values for Time Slots Read More
SQL Server

SQL Server: How does SQL Server treats NULL values ?

April 2, 2011August 28, 2014 - by Sachin Nandanwar - Leave a Comment

Definition of NULL values.Extract from BOL A value of NULL indicates that the value is unknown. A value of NULL is different from an empty or zero value. No two null …

SQL Server: How does SQL Server treats NULL values ? 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.