Browse by Tags

• auto
• biztalk
• blocking
• contribution
• database
• enterprise
• kba
• performance
• query
• SQL Server
• statistics
• stats
• stored procedure
• tuning
• x64

• TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

  PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query Read More... Posted Wednesday, September 05, 2007 12:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, blocking, statistics, stored procedure, tuning, parallelism, contribution, stats

• The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 or SQL Server 2005 database instance that hosts the BizTalk Server 2004 or BizTalk Server 2006 BizTalkMsgBoxDB database

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Read More... Posted Thursday, August 23, 2007 9:24 PM from SSQA.net | (Comments Off) Filed under: SQL Server, x64, database, statistics, kba, enterprise, parallelism, biztalk, auto