.NET Tips: SQL/T-SQL - SharePoint world of ECM and Information Management

Hello, my name is Michael Nemtsev and I welcome you on my blog about SharePoint Infrastructure, ECM systems and Information Management

I'm Microsoft MVP, Web Developer and SharePoint Consultant based in Sydney, Australia.

If you have any questions about SharePoint, then you are in the right place :) Feel free to ask via Contact Form page

Recent Posts

Tags

Email Notifications

Go

Archives

Google Gadget

.NET Tips: SQL/T-SQL

back to content

INFO:

SQL Server starts with row-level locks, but often escalates these to page and table locks, causing deadlocks >>.

new If the physical or logical RID contained in the non-clustered index records needs to change then all the non-clustered indexes need to be rebuilt in case of table structure change . >>

TIPS:

Random selection - "SELECT TOP 1 * FROM [TableName] ORDER BY newid()"

Use ROW_NUMBER for the paging in SQL Server 2005 >>

back to content

Posted: Sun, Jun 17 2007 0:18 by Michael | with no comments

Leave a Comment

Title (required)

Name: (required)

Website: (optional)

Comments (required)

Remember Me?