I have it installed on my XP workstation and I think it came with the Admin Tools Pack. I installed it so I could easily look up AD group members...

Booo 😛

You could explore the possibility of using the command line tool dsquery which is available on XP. I have used it before, but never for automation. However with...

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.