My apologies! I discovered that I was rebuilding indexes on the non-production version of the database (which has a nearly identical name as the production DB) and checking stats...

Follow-up:

The 2 rows in the DMV per index differ as follows:

The row in the DMV with the original fragmentation % has an index_level=0, and the new row (with avg_fragmentation_in_percent=0) has...

Thanks sturner. Two questions:

How long is "a while" and how do I force a recalculation of those stats? It's a real problem if I'm trying to verify a...

Thanks, Toby, but that won't work: the DMV has 2 rows per index. Two rows with index_id=1, two for index_id=2, and two for index_id=3.

This sounds suspiciously like what I ran across in creating a VIEW that was based on a table that I added columns to. The additional columns don't show up;...

Lowell, that's fantastic, thanks!

As for the GUI options, turns out those options aren't available in SSMS Express, which is what's installed on my desktop, only in the full...

Looks like says that FoxPro 2.6 uses blanks, not a NULL token, and that later versions of Visual FoxPro have columns whose NULL values will import in SQL as...

Not sure why NULL would import as False with SSIS. If you create a linked server from SQL Server to your FoxPro database, you can run queries from within...

Having used FoxPro for a long time, there was a good reason to use RBAR: step-wise code in FoxPro on an index could execute extremely fast. It was intended...

When I started at my present job a year and a half ago, there was somewhat worn but still serviceable chair at my desk. "Replace that piece of crap,"...

Thank you both very much. I didn't want individuals domain users to own databases, in case they leave the organization.

'Preciate the quick reply!

Rich

Steve, bravo for speaking plainly about something we all probably fear - unnecessarily, perhaps.

I'm in my late 40's and only a few years into my second career, in IT. ...

Steve, first thank you, thank you, thank you - for the best SQL Server online resource to help this newish DBA get up to speed on the myriad features, capabilities...

Thanks very much to everyone who replied. I appreciate not only the answers but the explanations/recommendations.

Yours,

Rich

OK, now I'm confused. If a database regularly creates, say, 50 Mb a day in transactions, but once a year I create 500 Mb of transactions, then every day...