SQL Server Aggregator

Filtered indexes and filtered stats might become seriously out-of-date

Time flies when you're having fun, eh? This week Paul and I are in Dublin, Ireland delivering a deep technical "SQL Immersion Event" on Internals, Performance Tuning and Maintenance with our partner ProData (and having a blast - we have Read More...

Posted Friday, September 25, 2009 2:45 AM from Kimberly L. Tripp | (Comments Off)

Filed under: indexes, statistics, SQL Server 2008, Inside the storage engine, Filtered Indexes

Connect digest : 2009-07-24

I'm a day early; sorry. But I have a lot of interesting items to share this week. ======================================== More control over TOP (n) in DML This week I realized that the workarounds for affecting which row(s) are impacted by UPDATE/DELETE...( Read More...

Posted Friday, July 24, 2009 10:00 PM from Aaron Bertrand | (Comments Off)

Filed under: statistics, connect, MERGE, TOP, permissions, minimal logging

Connect Digest : 2009-07-18

I missed last week because I was having fun up in Canada... mostly without any kind of computer access at all. It was a nice break, but now I'm back in the thick of things again. So this week, I am going to try to beef it up a bit to compensate for last...( Read More...

Posted Sunday, July 19, 2009 12:54 AM from Aaron Bertrand | (Comments Off)

Filed under: security, Open Table, SSMS, statistics, connect, cdc, Management Studio, index maintenance, paths, date formats

Connect digest : 2009-06-20

Here are the Connect items I'd like to draw your attention to this week. I have abandoned the idea of trying to keep track of vote counts and overall rating. Being lazy might be a small part of it, but it is mostly because I just don't think it makes...( Read More...

Posted Sunday, June 21, 2009 1:11 AM from Aaron Bertrand | (Comments Off)

Filed under: Analysis Services, statistics, trace, connect, usability, partitioning, shrinkfile, error messages, connection pooling, distributed transactions

Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint

OK, it seems as though there's A LOT of confusion about what steps are required for proper database maintenance. And, it seems as though some recommendations are being given as "quick fixes" without any real recommendation for root cause Read More...

Posted Friday, March 13, 2009 9:01 AM from Kimberly L. Tripp | (Comments Off)

Filed under: TFS, indexes, statistics, sharepoint, SQL Server 2008, SQL Server 2005, Opinions, Manageability, Database Maintenance

What you should know if you are using Logical IOs to measure query plan quality

One of the presenters at recent SQL Server Open World conference in Denmark ( http://www.miracleas.dk/index.asp?page=168&page2=323 ) suggested tuning SQL queries using logical IOs to measure quality of query plan. The IO count is returned for each Read More...

Posted Friday, April 11, 2008 12:36 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off)

Filed under: statistics, logical reads, optimizer

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

How do I find all the statistics and statistics columns on a specified object?

Run this TSQL on the database where you want to obtain the statistics information: SELECT s.name AS statistics_name ,c.name AS column_name ,sc.stats_column_id FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id Read More...

Posted Thursday, August 09, 2007 7:59 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, tsql, columns, statistics

DTS package, how will optimizer treats the transactions?

With the SQL Server 2000 DTS has very good capability of treating the huge processes as transactions, let's assume these parameters: DTS Package with "Use Transactions" and "Commit on successful package completion" boxes checked. No transaction related Read More...

Posted Thursday, August 02, 2007 10:52 PM from SSQA.net | (Comments Off)

Filed under: performance, statistics, table, dts, transactions, join

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be Read More...

Posted Monday, July 23, 2007 8:39 PM from SSQA.net | (Comments Off)

Filed under: security, performance, query, tsql, dmv, optimization, statistics, update statistics