Monthly Archives: November 2010

NOLOCK – truth

With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that you don’t expect consistency, so there are no guarantees. Bear in mind though that “inconsistent data” does not only mean … Continue reading

Posted in Lock/Blocking, What I learned today | Tagged , | Leave a comment

Sql Server -11 “Denali”

New Version Sql Server “11” code name “Denali” CPT1 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/default.aspx Here are experts comment and information: http://download.microsoft.com/download/8/C/1/8C1CE06B-DE2F-40D1-9C5C-3EE521C25CE9/Columnstore%20Indexes%20for%20Fast %20DW%20QP%20SQL%20Server%2011.pdf http://www.ssistalk.com/2010/11/09/sql-server-future-code-name-denali-ctp1-now-available/ http://sqlinthewild.co.za/index.php/2010/11/09/first-impressions/ http://sqlblog.com/blogs/aaron_bertrand/archive/tags/denali/default.aspx http://sqlcat.com/whitepapers/archive/2010/11/09/new-spatial-features-in-sql-server-code-named-denali-community-technology-preview-1.aspx http://www.brentozar.com/archive/2010/11/sql-server-code-name-denali-release-date-today/ Whats new: http://www.databasejournal.com/features/mssql/article.php/3916166/Top-9-New-Features-of-SQL-Server–Denali.htm Happy Learning. Vinay

Posted in General, Installation, Software, What I learned today | Tagged | Leave a comment

unistall sql server completely (Must Read)

Everyone know how to uninstall sql server very easy : control panel -<Add remove programs ->sql server some times you can also uninstall using setup cd/setup dump. found a very great forum answer which shows how to unistall sql server … Continue reading

Posted in Add/remove, General, Installation, Software, Tool, What I learned today | Tagged | Leave a comment