Monthly Archives: August 2011

Internal 1 – Introduction

Internal 1 – Introduction Continue on internal post. Sql server is an application/ software where it runs on system software as well as hardware i.e. Operating system and recourses, Sql server versions should be compatible with Operating system version and … Continue reading

Posted in Internal | Tagged | Leave a comment

performance Tunning continue…

We have discussed performance tunning part1, continue on that… Resource is the base for performance, if you don’t have sufficient space the optimum query/system may also not work efficiently. Latch: Latch is for physical synchronization, like while >> accessing pages … Continue reading

Posted in Performance Tuning | Tagged | Leave a comment

Denali

The new version of Sql server “11” code name “Denali” has released and CPT3 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx The more infomration on this by experts : http://www.brentozar.com/archive/2010/11/sql-server-code-name-denali-release-date-today/ http://sqlblog.com/blogs/aaron_bertrand/archive/tags/denali/default.aspx http://sqlinthewild.co.za/index.php/2010/11/09/first-impressions/ http://sqlcat.com/whitepapers/archive/2010/11/09/new-spatial-features-in-sql-server-code-named-denali-community-technology-preview-1.aspx http://www.ssistalk.com/2010/11/09/sql-server-future-code-name-denali-ctp1-now-available/ http://download.microsoft.com/download/8/C/1/8C1CE06B-DE2F-40D1-9C5C-3EE521C25CE9/Columnstore%20Indexes%20for%20Fast%20DW%20QP%20SQL%20Server%2011.pdf Will write a blog about Whats … Continue reading

Posted in Computers and Internet, General, What I learned today | Tagged , , | Leave a comment

Sql Server Internals…

These days I am learning lots of sql servr internals. I am reading blogs by Paul Randal – http://www.Sqlskills.com and gone thorugh his MCM trainings. For me Paul is the mentor of sql server, I learn most of the internal/basics of sql … Continue reading

Posted in Internal | Tagged | Leave a comment