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: 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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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.