Do keep in mind that the sys.dm_db_index_usage_stats dynamic management view is reset to all zeros every time the SQL Server instance is restarted, so don't restart SQL Server then disable ...

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some ...

They are most-often caused by a client application not consuming and processing results from the SQL Server quickly enough. From a SQL Server point of view, there’s nothing you can tune. Engage the ...

In addition, Siebel Systems Inc., Unisys Corp. and Microsoft have achieved the No. 1 benchmark result for Siebel eBusiness Applications with 30,000 concurrent users running Siebel 7 on a Unisys ES7000 ...

SQL Server also has separate logs for the SQL Server Agent, as well as other components of the data platform, such as SQL Server Analysis Services. In each case, SQL Server keeps seven rolling log ...

There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task.

Performance increases across a wide variety of workloads are evidenced in recent public benchmark results, including the Transaction Processing Performance Council’s TPC-C and TPC-H, placing Windows ...