Steve Jones - SSC Editor (11/6/2010)

---

I believe the guidance that I saw from Paul Randal this week (Again, subject to testing), is 10% < fragmentation < 30% - Reorganize. >...

TheSQLGuru (11/5/2010)

---

1) if you check the code for sp_updatestats I think you will find that it isn't so selective as you imagine. It updates anything with 1 or more...

Smellypom (11/5/2010)

---

As for monitoring, we are tracking index state on a daily basis. Page splits was a no but will soon be a yes 🙂 anything else we should be...

Smellypom (11/4/2010)

---

Thanks for the feedback everyone.

So the plan is, select all indexes that are fragmented more than 10% and have more than 250 pages. Split these into 2 separate groups,...

(I know the last post on this thread is over 2 months old but no one answered the last question posted.)

You will most likely find the enabling or disabling of...

MysteryJimbo (10/21/2010)

---

GilaMonster (10/20/2010)

---

I have personally brought down a busy production...

In addition to being my company's DBA, I'm also a certified Compellent SAN administrator.

If you want to achieve optimum performance on your database server(s), separate each of your database files...

Americans live in a unique and interesting time.

We have the worst possible economic scenario:

1. Deflation of assets

2. Inflation of consumables

Ultra low interest rates are creating another stock market bubble....

If you're interested, here are some sources I consult regularly to determine which way the economic winds are blowing:

http://money.cnn.com/2010/10/28/news/economy/quantitative_easing_consumer_impact/index.htm - This article explains how the Federal Reserve is getting ready...

CNN Business, Bloomberg, my local newspaper, and many other sources.

I read many sources of business and economic information.

LC

http://money.cnn.com/?hpt=Sbin

http://www.bloomberg.com/

Actual unemployment in the United States is somewhere over 20% and less than 25%. During the Great Depression of the 1930's, unemployment was ~25%.

The United States needs to create...

SQL Server is a vast product. And there more than a few types of DBA's (Operations, Development, BI, Data Mining, Performance Tuning specialists, Reporting specialists, SSIS specialists, SQL coding specialists,...

The "Great Recession" is a euphemism.

This is the Second Great Depression and it will eventually, and correctly, be referred to in this manner at some point in the future.

LC

There may be something I don't know about this subject but I'm going to add my comments anyway.

Over the years, it has been my experience working on several different SQL...

We had a similar problem on our 2 database servers.

The CHECKPOINT command below fixed the problem. Our TempDB database was not being checkpointed frequently enough or at all. Why...