Browse by Tags

Quick tips & tricks on fine tuning performance problem on a SQL Server instance.

Published 6 October 8 4:51 AM | SqlServer-QA.net

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself...

Filed under: sql server, performance, query, optimization, best practices, hints, knowledge, performance monitoring, engine

FIX: An access violation may occur when you run a query that uses a hash join hint in the x64 version of SQL Server 2005 Service Pack 2

Published 22 September 7 7:4 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, query, kba, service pack2, hints, access violation, hash join

XLOCK Hint is ignored even though specifying explictly?

Published 11 September 7 5:21 AM | SSQA.net

Interesting newbie question on the forums to share. I am selecting a value from a table(column).I do not want any 2 users can select same value at the same time..in other word 1 value only be selected by individual user. in order to do it I am simply...

Filed under: sql server, performance, optimization, hints, statistics, locking, results, xlock

SQL Server Cursors usage and performance - cursed

Published 19 June 7 9:34 AM | SSQA.net

If you have a requirement to poll through 'n' number of rows then immediately you would think about Cursors in SQL Server. As the solution using any programming language that loops recordsets to build the attendance list that works ok, but really...

Filed under: sql server, performance, databases, dmv, hints, usage, cursor, table