you can use a script like the one below to just do rebuilds setting it back to 100 if that's your goal.

SELECT object_Name(i.object_id)

AS TableName, i.object_id,

Schema_Name(o.schema_id)

AS SchemaName, i.name, avg_fragmentation_in_percent, page_count, partition_number,...

Lots of good advice here. the books section is useful on SQL Server Central. Accidental DBA[/url] is a good book to look into. There are a lot of training sites....

Glen Barry wrote a good set of scripts that you might find use in.

Here's the link[/url]

the below script tells you well... what his comments say. Buffer Usage by database. If...

What Gail said. If you're not allowed access to the database, It's best not to just take it upon yourself and try getting in. Do you have more information? Did...

does this sound like your issue?

http://connect.microsoft.com/SQLServer/feedback/details/354939/cannot-open-dialog-in-job-activity-monitor

Posted by Agrapha on 9/29/2010 at 11:26 AM "

Confirmed. The full version of 2008 R2 express is unable to open the Job Activity Monitor on...

Have you considered using the script that's reading the files into the table to then move said file to an archive folder? Powershell may help you with this if it's...

Is this production that's down now?

Do you have backups of all of your databases?

Do you have the ability to reinstall SQL if needed?

And here's a 4th Gen i7 with 32 GB of ram ^.^; waaay too expensive.

http://www.newegg.com/Product/Product.aspx?Item=N82E16834152430

this one is only 1840$

http://www.newegg.com/Product/Product.aspx?Item=N82E16834227050

These look like my next laptop.

a DC can run off of 512MB... though 1GB loads faster. if it's not a production use File system, i'd go with 1GB or so. you can run SQL off...

As a side note, the 70-432 Is being replaced by the 70-461 through 70-465. I would figure the specs would remain the same.

No. SQL requires 1 GB, windows wants 1GB and running anything may take more. I personally use 4 GB of ram. it will run off 2GB but you will notice...

There's also a Yammer MCM Study group that adds alot of good information and resources.

Below is a document we created in house for this. It should work without issue. of course edit the information to meet your server.

How to Restore Master from Backup

1) Ensure...

We found that the hard way and I wish we had seen the blog prior. We resolved it with a like system doing exactly what the blog shows.

in our clustered environment, under sql server config, we set our IP's (we have 3 per box) in as normal... and we set IPAll to show port 1433. so exactly...