Looks like you have Heaps (which will show as indexes in the views). To defrag these, you will need to create a clustered index on the table.

However, it may...

Do you have good backups?

Are you able to start in single-user mode?

Are you able to start the DAC?

Yes. Depends on the DBA though. Not all people are management types. Many DBA's are hands on...

It depends on where you are a Production DBA. Production DBA is not the same thing from company to company. The depends part, comes down to how well...

Could you provide the error message? There are a few different issues with Express and SP3 not installing properly that I have come across.

For what it's worth, I agree with Steve. Even if you query AD multiple times throughout the day using this process to update the table, it would be better...

Could you describe your situation a little more please? What is it that you are trying to accomplish?

Good points. It is only 16 games and 1 game a week. I am thinking more from the perspective of having the season last just a little bit...

It will never complete if you leave SQL Server running (past experience) and you would end up cancelling the defrag.

For best results, defrag while SQL Server is offline. Secondly,...

I was thinking that it could be...

Pro-bowl should be in the middle of the season.

I would start by removing the login and the user from the database (make sure it is gone). Even so far as to remove all the new users you...

A good interval is sometimes dictated by compliance to some outside authority. For us, it was made clear that we must rotate the keys every 90 days at minimum....

Lynn Pettis (1/29/2010)

---

Has the question been changed? I just answered it and it specified SQL Server 2005/2008, in a just opened connection (no other commands run).

I was surprised that...

bitbucket-25253 (1/29/2010)

---

To malleswarareddy_m, Rick-153145 and bluesbiker let me issue you a...