darshan (12/6/2013)

---

Hi,

Consider the following scenario:

1. Application x has a few transaction tables as very huge tables say tables t1, t2, t3, etc.

2. Application is only in maintenance mode and no...

peter-757102 (12/5/2013)

---

You can create multiple filtered statistics yourself that do not overlap in key range, this way you can get multiple blocks of 200 entry statistics, even on a single...

Thanks to all for your comments 🙂

Leo Peysakhovich (10/31/2013)

---

Thanks, nice article. Few comments:

1. Threads can interfere with each other if there are records on the same pages. And this will be a reality unless split is...

Hi Patrick

Thanks for your feedback! I have...

Thanks Patrick for your help. In fact now...

OK made progress, not surely what I did BUT the reporting option is now visible in both SSMS and Excel, however I clearly now have a problem with the report...

SQLkiwi (8/1/2011)

---

brian118 (8/1/2011)

---

Found this white paper. related to SQL Server 2000.

To avoid long term maintenance of unused statistics, SQL Server 2000 ages the automatically created statistics (only those that...

Ninja's_RGR'us (8/1/2011)

---

brian118 (8/1/2011)

---

Ninja's_RGR'us (8/1/2011)

---

Well for sure editing an index could cause this.

This is the first I hear of stats being dropped. Tho I can understand the decision behind the...

ALZDBA (8/1/2011)

---

So, where/how does it keep track if stats are no longer being used ??

SELECT quotename(object_schema_name(OBJECT_ID)) + '.' + quotename(object_name(OBJECT_ID)) as ObjectName

, quotename(name)...

Ninja's_RGR'us (8/1/2011)

---

Well for sure editing an index could cause this.

This is the first I hear of stats being dropped. Tho I can understand the decision behind the behavior.

Other than...

Ninja's_RGR'us (8/1/2011)

---

That actually can't happen. The restore of a backup is a perfect copy of the DB (including index and stats).

Either the backup is older than the db itself...

One of our clients restored...

scottichrosaviakosmos (5/9/2011)

---

ok this will work fine to single action, like here for removing commas. but what if i have some other special character to remove then again i have to...

drew.. (5/8/2011)

---

Hi all

I am new to BI and I need some help. I have seen similar links to my question but they don't seem to work so please provide a...