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.

Archives: October 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, 431 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

6 comments, 657 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

27 comments, 595 reads

Posted in SQL Server Blog Forum on 4 October 2011