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

SQL Server Blog Forum

My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.

Restoring a database from higher version to lower version SQL server

Restoring a database from higher version to lower version SQL server

How to downgrade a database from higher version to lower version?

There is no direct way to do this like Backup/Restore. You can use an alternative ways.

The alternative ways are,

 

1. Generate Script

2. Import/Export

3. Transaction…

Read more

12 comments, 979 reads

Posted in SQL Server Blog Forum on 28 May 2011

Microsoft SQL Server 2008 R2 SP1

Microsoft SQL Server 2008 R2 SP1 CTP
SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409

Read more

0 comments, 450 reads

Posted in SQL Server Blog Forum on 20 May 2011

Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One

 

Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One
I am a bit late to this party. I have seen this post from Grant’s blog now only. Thanks to Thomas LaRock such a great topic.

Here is mine:

 

1. Too many indexes on a table… Read more

4 comments, 178 reads

Posted in SQL Server Blog Forum on 4 May 2011

Shrinking the log file script for SQL server database

Shrinking the log file script for SQL server database                               

This script mainly for a DBA’s, because most of the time the log file grow again and again and eats up all the disk space and finally an application goes down.

Errors from SQL server error log:

Error: 9002, Severity: 17,…

Read more

13 comments, 952 reads

Posted in SQL Server Blog Forum on 10 April 2011

INDEX DEFRAGMENTATION SCRIPT for SQL server 2000

 

INDEX DEFRAGMENTATION SCRIPT SQL 2000

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance. When you perform any DML operation (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. If you use predefined maintenance plan it will take much server resource and…

Read more

21 comments, 908 reads

Posted in SQL Server Blog Forum on 12 March 2011

Difference between truncating and shrinking the transaction log file

 

Difference between truncating and shrinking the transaction log file

I have noticed in many forum the frequently asked question is “Truncating and shrinking the log file both are same”

The answer is obviously NO. These both are totally different. Before going into discussion, let’s read the transaction log file…

Read more

20 comments, 586 reads

Posted in SQL Server Blog Forum on 7 March 2011

How to get the SQL server critical errors via mail using native T-SQL Script

 

T-SQL Tuesday #015: Automation:

 

 

     

I am very much interested to participate in the T-SQL Tuesday event party. I have seen the T-SQL Tuesday logo and article in one of my favorite SQL server blog Gail Shaw.

I found the Adam Machanic ( Blog | Twitter ) via…

Read more

13 comments, 336 reads

Posted in SQL Server Blog Forum on 6 February 2011

How to setup the Database mail in SQL server 2005

How to setup the DB mail using Gmail account

In this article I am going to show the database mail setup steps with screen shots. When I tried to test one of my automation procedure in my friend’s laptop I got number of errors.Then I Goggled and found the solution.…

Read more

10 comments, 254 reads

Posted in SQL Server Blog Forum on 5 February 2011

SQLskills Master Immersion Events 2011 competition

SQLskills Master Immersion Events 2011 competition




      I have completed engineering and my native is M.Uthamasolagan (village near chidambaram ). I have started my career as SQL server DBA with my brother’s Rajakrishnan Rajadurai support. To be frank I am not good in English and so I feared to work during…

Read more

3 comments, 209 reads

Posted in SQL Server Blog Forum on 24 January 2011

How to find the SQL server port number

 

One day I got a call from my junior DBA. She asked me, how can I find out the port number for a particular server? Then our conversation started,

Me:

I asked a question to her what version of SQL server is that.

Junior DBA:

Its SQL server 2005

Read more

9 comments, 186 reads

Posted in SQL Server Blog Forum on 19 January 2011

Step by step backup/restore using T-SQL

 

This article mainly for SQL server learners, who is going to become a DBA, in this article I am going to explain the backup and restore using T-SQL.

Why I choose the T-SQL instead of GUI?

Below are reasons,

I have seen a number of articles and blogs shows…

Read more

15 comments, 292 reads

Posted in SQL Server Blog Forum on 10 January 2011

Happy moments in 2010

Happy moments in 2010

Hi all wish you a happy new year.
I know it’s a late post anyway I am going to share my 2010 happy moments.
My happy moments:

I have joined one of the MNC and started writing a blog, articles, reading books and following some other… Read more

35 comments, 402 reads

Posted in SQL Server Blog Forum on 7 January 2011

Clustered index vs Non clustered index

Clustered index vs Non clustered index structure

Clustered and Non clustered indexes are stored in a B – tree structure .

Clustered Index

  • Clustered index enforce the logical order. (Misconception: Clustered index does not enforce the physical order)

 

  • A table has only one clustered index because, the original table…

Read more

6 comments, 1,349 reads

Posted in SQL Server Blog Forum on 2 December 2010

INDEX DEFRAGMENTATION SCRIPT

 

INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005

I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me to write a script.

I have posted the updated INDEX DEFRAGMENTATION script here, which is already published in sqlservercentral (SSC).


Script changes:

·         I used while…

Read more

11 comments, 716 reads

Posted in SQL Server Blog Forum on 23 November 2010

SQL server basics for beginners

 

In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.

SQL-Structured Query Language (pronounced as SEQUEL) is a Database, computer language designed for managing data in relational database management system (RDBMS).

Most of the people have to… Read more

13 comments, 750 reads

Posted in SQL Server Blog Forum on 23 November 2010

sql server internal architecture

Folks,

I am very glad to share my experience. I have two reasons to write this article here.

First one is I had an interview with one of the company, they asked about the SQL server internals. (On that time I struggled)

When I Goggled I didn’t get entire information…

Read more

4 comments, 188 reads

Posted in SQL Server Blog Forum on 12 November 2010

Newer posts