For clarity, the problem was originally reported here -

http://www.sqlservercentral.com/Forums/Topic560965-391-1.aspx

I'm more surprised this survived all the testing that was done on 2008. Seriously, in all the automated tests that were...

Update stats isn't needed (and can be counter-productive) if a full index rebuild is done. Update the stats only of tables that have been reorganised.

What exactly do you mean by...

The performance of adhoc SQL and Stored procedures is pretty much the same. What procedures give you is better plan cache reuse (and if your server has lots of memory...

Could you be more specific please?

You can use DROP USER to remove database users

If you can explain a bit more about your problem, someone will be able to help you more.

Alter Index ... Rebuild

You can get all the details of the various options from Books Online

SQL Server does that automatically. If a user is updating a row then that row is locked exclusive and cannot be read or changed by anyone else.

Have I misunderstood what...

If the DB is in full recovery, then the log backups probably won't be able to run due to the single user mode.

If the DB is in simple recovery, then...

There's a proportional fill algorithm that's used. It doesn't matter what the file's max size is, just how much free space is in the files.

If you have three files...

Please find the SQL error log on the rebuilt node and have a look at what it says. Providing the service is getting started at all, there should be a...

jerryhung (9/13/2008)

---

Good, that's smaller scope. After noticing previous posts, we do also observe high IO and CPU as well

so my next step is perhaps change all TABLE VARIABLE -> TEMP...

rian67 (9/13/2008)

---

>> Are DBAs capable of writing front end applications?

According to the job description of DBA, they are responsible for Security, Performance, Recoverability, High Availability of RDMS. For...

And check that there isn't a job somewhere that runs shrink on a regular basis

I'll give it a try, however, since the policies are implemented as DDL triggers behind the scenes, I don't think it's possible.

Are you talking about a policy that prohibits a...

Table variables has the same scope as normal variables. Much less than a temp table. Their lifetime is limited to one set of commands (batch) sent to the server.

So,...