Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

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

Archives: November 2012

Interview questions for SQL Server Performance Tuning Specialists

If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.

I have converted some of my learning as questions and posted it here. These are not necessarily be the interview questions.

I am sure that this will help us to assess our knowledge and hope this… Read more

3 comments, 4,533 reads

Posted in LivingForSqlServer on 29 November 2012

One Interview question. Many Answers

Conducting technical interview is an art.

Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL Server?" .

here are some open ended questions that could be answered in 10 seconds or may lead to an hour long interesting discussion.

1. I have created a Non Clustered Index to improve a query… Read more

1 comments, 1,905 reads

Posted in LivingForSqlServer on 27 November 2012

Time Pass With Transaction Log - Part 5 INSERT

 In this article We are going to INSERT a record in a simple table and try reading Transaction log record.

Note: This article is incomplete. I could not interpret lots of Hex values (no clues) and also you can expect inaccuracy in interpreted values.

USE MASTER
GO

-- Drop this… Read more

4 comments, 1,396 reads

Posted in LivingForSqlServer on 27 November 2012

Time Pass With Transaction Log - Part 4 DDL

In this article,  We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.

Our focus is to observe schema level impacts in lower level.

1. CREATE TABLE

Lets create a simple table named tEmployee in a sample database EXPLORE_TLOG

USE MASTER
GO

-- Drop…

Read more

0 comments, 1,219 reads

Posted in LivingForSqlServer on 26 November 2012

Time Pass With Transaction Log - Part 3 fn_dblog

As part of this Transaction Log Internals series, In this article we are going to observe the use of fn_dblog and some of its important columns.

fn_dblog is an undocumented function introduced in SQL Server 2005. This function is used to return active (or un-truncated) part
of transaction log file.

Syntax:
fn_dblog({BeginLSN | NULL}, {EndLSN… Read more

0 comments, 6,997 reads

Posted in LivingForSqlServer on 19 November 2012

My Favourites Of Paul Randal

As a new blogger, It is a little pain for me to blog on a technical topic.  

It starts from learning, exprimenting, being comfortable with topic, decide what to write and how to convey, make sure no or minimum technical inaccuracies,  preparing relavent demo scripts, formatting and so on.

But while going thru his blog post count, varity, depth and… Read more

0 comments, 978 reads

Posted in LivingForSqlServer on 15 November 2012

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, 1,614 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, 945 reads

Posted in LivingForSqlServer on 5 November 2012