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 →

Read more

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/ Happy Learning. Vinay

Read more

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 →

Read more