SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

Time Pass With Transaction Log - Part 2 Basics

As part of this Transaction Log internal series, In this article We are going to revisit some basic properties of Transaction log.

Though architecture, purpose and properties of data and transaction log files are not similar, I have tried to compare some similarities
and differences of data and t-log files. Tried to cover some common myths around data and…

Read more

2 comments, 2,983 reads

Posted in LivingForSqlServer on 15 November 2012

Time Pass With Transaction Log - Part 1

Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.

Everything from basics to best practices are documented in various format except "How to read Transaction Log Entries"

Yes. this series of articles is just an attempt to try reading  transaction log records *of some basic… Read more

0 comments, 1,693 reads

Posted in LivingForSqlServer on 5 November 2012

Transaction Log Internals - My session ingredients

Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).

While seeing below two worlds best presentations on this topics, I wonder what more I could add for my one hour session.

1. Paul Randals Transaction Log Internals Maintenance (MCM Readiness Videos)

http://technet.microsoft.com/en-us/sqlserver/gg313762.aspx Read more

0 comments, 2,234 reads

Posted in LivingForSqlServer on 30 October 2012

My Training Topics For Coming Months

Just few days gone since our last Chennai SQL Server User Group meet. This is the right time to choose my presentation topics for coming months.
Lots of internals related topics are queueing up. I have chosen below four topics as my priority as much learning and focus is required on this. Read more

0 comments, 838 reads

Posted in LivingForSqlServer on 18 October 2012

CSSUG Oct2012 - My Session Presentations and Scripts Are Available Here

Chennai SQL Serve User Group Meet for Oct'2012 happend today at Microsoft Traning Centre located in Radhakrishnan Road, Chennai.

Its pleasure seeing enthusiastic community members and addressing questions of curious minds.

Recently, I got a chance to read ebook on SQL Server Statistics By Holger Schmeling. A must read book for both Developers… Read more

6 comments, 813 reads

Posted in LivingForSqlServer on 13 October 2012

Yet Another Facebook Page - Living For SQL Server

I have created facebook page named "Living For SQL Serever" couple of days back.


Inviting our community friends to like this page.

-- It's yet another facebook page that shares something about SQL server.

Personally nowadays, I am very concious in choosing topics before writing a blog post on SSC.

I am… Read more

1 comments, 1,589 reads

Posted in LivingForSqlServer on 28 September 2012

Pearls in the Ocean – Part 1


In our day to day life with SQL Server, We refer web for many reasons.

This includes understanding new SQL Server features or Recollecting syntax of rarely used commands or to check solutions for unfamiliar errors.

While searching what we need on Web, We may have to come across… Read more

0 comments, 755 reads

Posted in LivingForSqlServer on 12 September 2012

My Session on Locking Internals Part 1 in CSSUG Meet

Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server devotees irrespective of bad weather in Chennai.

CSSUG meet started with my presentation on SQL Server Locking Internals Part 1.

Vidhyasagar gave session on ColumnStore Index and FileTable. Todays topic for Mathi… Read more

3 comments, 802 reads

Posted in LivingForSqlServer on 8 September 2012

Chennai SQL Server User Group (CSSUG) meet

 Let me start with my sincere apologies first for not blogging consistently.

Primary reason is, my wife gave birth to our second child two months ago.  After becoming father of two kids my priorities are entierly changed.

secondly I had to face some issues in professional life recently,… Read more

0 comments, 1,270 reads

Posted in LivingForSqlServer on 4 August 2012

Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.

some key books/links on this topic are given in reference section for further read.

Some properties of Tempdb Properties

1. Tempdb is recreated everytime SQL Server starts.
2. Simple recovery mode. No Full/Log… Read more

0 comments, 2,092 reads

Posted in LivingForSqlServer on 15 March 2012

Data Page math : 96 + 8060 + 36 = 8192. is this correct?

I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum allowable row size is 8060.

But I was bit confused while I saw the response as 36 bytes is for row offset array (as this is not enough to… Read more

0 comments, 1,531 reads

Posted in LivingForSqlServer on 9 February 2012

Important SQL Notes collection by Jose Barreto

I have come accross below link while checking options to find top painful mirroring enabled databases.

Looks like there is no single query/DMV to get this info.

back to this link.

Excellect collection of key notes for almost all key SQL topics. Great work Jose Barreto.


Good source for Senior… Read more

0 comments, 4,042 reads

Posted in LivingForSqlServer on 31 January 2012

Free SQL Server Learning Resources

As a learner I have got chance to know lots of free and precious SQL Server resources in last few months.

Like to share this list with friends in our community. Let me share my second list later (as I wanted to keep this list short).

Unknown is an ocean.… Read more

1 comments, 2,387 reads

Posted in LivingForSqlServer on 5 November 2011

Four faces of an Employee

Whoever starts their career in any domain/technology, initially they will have two faces.

First face of an employee is to take care of his/him family & family related commitments and the second
face of him/her is to fulfill the expectation of the Organization they work.

But third and forth faces… Read more

2 comments, 1,526 reads

Posted in LivingForSqlServer on 31 October 2011

Logical CPU, Physical CPU and hyper threading

Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.

-- Hardware information from SQL Server 2008

-- (Cannot distinguish between HT and multi-core)

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],

cpu_count/hyperthread_ratio AS [Physical CPU Count] Read more

3 comments, 10,078 reads

Posted in LivingForSqlServer on 30 October 2011

Father of SQL Server?

“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server. It will  take care of your career growth and salaray”

This is whatt I repeatedly share with all who attend my training sessions and with my few followers. Read more

0 comments, 2,524 reads

Posted in LivingForSqlServer on 19 September 2011

Database Snapshot as a Reporting Solution – Some Realtime Issues and Answers

One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is using the high performance mirroring/reporting server.

I thought of moving Reporting users to make use of Mirroring server as a Reporting platform by taking Database Snapshots and making them to… Read more

0 comments, 6,118 reads

Posted in LivingForSqlServer on 19 September 2011

Youngest MCM in the world?

As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness videos on Technet last week.
Here is the link: http://technet.microsoft.com/en-us/sqlserver/ff977043

My first choice was ‘Database structure’ video by Paul Randal as this topic is bit familiar to me.
Paul Randal’s presentation… Read more

0 comments, 1,435 reads

Posted in LivingForSqlServer on 5 September 2011

Chennai SQL Server User Group and me

My one week long search to identify active SQL Server community in Chennai ended last Sunday.

Chennai SQL Server User Group (CSSUG) is one of the active user groups in Chennai organizing events every month.

Vidhyasagar (MVP) is one of the co-founder of CSSUG is actively leading this group and… Read more

3 comments, 1,862 reads

Posted in LivingForSqlServer on 7 August 2011

SQL Server, Chennai and Me

It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.

While seeing lots of blog post on pre/post SQLSaturday events, I am bit curious to know is there any active SQL Server user group in Chennai so that I can be part of it. Read more

0 comments, 844 reads

Posted in LivingForSqlServer on 26 July 2011

Newer posts

Older posts