tag:blogger.com,1999:blog-1416983219169300553.post2663642831929107735..comments2024-01-30T04:40:32.833-08:00Comments on SQL Server Performance: ContextJeff Garbushttp://www.blogger.com/profile/09795382811630904379noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1416983219169300553.post-83947611401479056232009-04-15T13:29:00.000-07:002009-04-15T13:29:00.000-07:00From the perspective of someone who supported an A...From the perspective of someone who supported an ASE database that processed millions of inserts a day to multiple tables, having row level locked partitioned tables with non clustered indexes is a better solution. The partitioning (this is the old partitioning prior to 15) gives you multiple insertion points and the row level locking reduces contention on the indexes (latches verses locks).Unknownhttps://www.blogger.com/profile/12492060911248033993noreply@blogger.com