SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

Read more

1 comments, 1,160 reads

Posted in Vinay Thakur on 30 November 2010

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

Read more

0 comments, 819 reads

Posted in Vinay Thakur on 10 November 2010

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

Read more

1 comments, 409 reads

Posted in Vinay Thakur on 2 November 2010