-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

SQL server could not start cannot find object or property (0x80092004)

SQL server could not start cannot find object or property (0x80092004)

Recently I got a call from my team the users couldn’t connect the SQL server and it’s throwing error. As always, I checked the SQL server status via configuration manager and noticed the server 2008 r2 stopped.  I tried… Read more

0 comments, 1,875 reads

Posted in SQL Server Blog Forum on 7 November 2011

AWE has removed from SQL server 2012

AWE has removed from SQL server 2012

AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit servers. To use more than 4GB memory you have to buy 64 bit servers.

 

A small organization may suffer because of this feature has removed from the next… Read more

4 comments, 869 reads

Posted in SQL Server Blog Forum on 18 October 2011

SQL server 2012 Denali not starting there is insufficient memory available in the buffer pool

SQL server 2012 does not start

Today is not a good day. Ha ha not like that

Usual I opened SQL server DENALI to play something it doesn’t open (start) it at all. It’s throwing error. Probably you know what I will do I went configuration manager checked the service… Read more

8 comments, 1,637 reads

Posted in SQL Server Blog Forum on 16 October 2011

Merge join Vs Hash join Vs Nested loop join

 

This month’s TSQL Tuesday party is being hosted by Stuart R Ainsworth (Blog| Twitter). I am very glad to write my first blog post as t-SQL Tuesday post on my newly designed website.

SQL server has three types of internal joins. I know most of folks never… Read more

34 comments, 1,681 reads

Posted in SQL Server Blog Forum on 4 October 2011

SQL Server 2008 SP2 cumulative update 9

SQL Server 2008 latest cumulative updates 9 build 10.50.1804 available now. You may download and test it Cumulative Update 9 for SQL Server 2008.

Read more

0 comments, 910 reads

Posted in SQL Server Blog Forum on 19 August 2011

SQL Server Denali CTP3 Download

Microsoft has given the SQL Server Denali CTP3 (Community Technology Preview)  for public preview. You can download the SQL Server Denali CTP3 here.

 

http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx

I'm very interested to see the SQL Server Denali new Features.

Read more

0 comments, 763 reads

Posted in SQL Server Blog Forum on 21 July 2011

SQL Server 2008 SP2 cumulative update 5

SQL Server 2008 SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it.

Cumulative Update 5 for SQL Server 2008 Service Pack 2

http://support.microsoft.com/kb/2555408

Read more

0 comments, 624 reads

Posted in SQL Server Blog Forum on 20 July 2011

T-SQL best practice SQL server

SQL server T-SQL best practice

This month’s TSQL Tuesday party is being hosted by Amit Banerjee (Blog | Twitter).

He is working with Microsoft and see here his online activities MSDN. The topic this month is T-SQL best practice. It’s the both DBA and developers Topic/Job.

Transact…

Read more

13 comments, 2,841 reads

Posted in SQL Server Blog Forum on 12 July 2011

SQL server Database backup restores Steps

SQL server Database restores sequence Steps

I have seen many people are still unclear about the database restoration sequence. Recently I have answered a number of database restoration questions SSC, MSDN... I got a comment from Anonymous user.

It’s a simple task to the experienced DBAs. However it’s…

Read more

15 comments, 1,422 reads

Posted in SQL Server Blog Forum on 6 July 2011

SQL server Disaster Recovery plan

SQL server Disaster Recovery Options

This month’s TSQL Tuesday party is being hosted by Allen Kinsel (Blog | Twitter) and the topic this month is disaster recovery. It’s a DBA Topic/Job.


The disaster recovery is really “It depends”.

What is disaster recovery?

Disaster recovery is called DR. Hmm...

Read more

28 comments, 1,095 reads

Posted in SQL Server Blog Forum on 14 June 2011

SQL server Recovery Models and Backup types

In this post I am going to explain the importance of recovery models and backup types.

Why I am writing this post ?

Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some… Read more

36 comments, 1,270 reads

Posted in SQL Server Blog Forum on 7 June 2011

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

13 comments, 2,008 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, 920 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, 398 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

15 comments, 1,779 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, 1,585 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

21 comments, 1,228 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, 694 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, 569 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, 502 reads

Posted in SQL Server Blog Forum on 24 January 2011

Newer posts

Older posts