Bummer. I am in the same boat...

Nothing for spaceusage...

Run DBCC UPDATEUSAGE then everything Gail said, in that order:

GilaMonster (7/8/2012)

---

Update all statistics

Run...

I agree 100%. Those numbers are nothing more than a fair starting point for most systems.

clayman (7/10/2012)

---

baabhu (7/10/2012)

---

Recommendation by Microsoft.

1) Fragmentation less than 30%. Reorg.

2) Fragmentation greater than 30% Rebuild.

3) If the table has got less than 8 pages don't take...

Duplicate post (please do not do that). Direct all replies here: http://www.sqlservercentral.com/Forums/Topic1325182-360-1.aspx

For clarity sql01\sql01 is a named instance, not a default instance.

You cannot rename a named instance, and similarly you cannot make a named instance the default instance, or change a...

Jeffrey Williams 3188 (7/8/2012)

---

GilaMonster (7/8/2012)

---

It got fixed in SQL 2005, in 2005 SP1, in 2005 SP2, in 2005 SP3 and in 2005 SP4. Basically most of the issues were fixed...

Here is a good one that I use it on a lot of instances. It only rebuilds or reorgs indexes as needed, based on fragmentation levels you control. The defaults...

I had a little time and got the Cherry City MySQL OLE DB driver (v 5.60.82) working in BIDS 2005, i.e. I can load data from a flat file into...

Run this on your secondary instance, replacing the DB name with your own, and refer to the file_retention_period column in the results.

USE master;

EXEC sys.sp_help_log_shipping_secondary_database

@secondary_database =...

Sorry, my last post was submitted prematurely...

I am not aware of any way to implant a macro into a csv file. Into a xls or xlsx file sure, but not...

...

Just so you can rule it out, adding (or dropping) an index will not modify data in your table in any way shape or form.

I am not sure if this is what you're asking, but it sounds like you would like to add a VBA Macro to each csv file that will fire when...

That's true. It is known as a uniqueifier. Whether you provide the uniqueness or whether SQL Server must help, a clustered index entry must uniquely identify a row. So, if...