Most...

Can you run that and get me the actual execution plan? Way to do that's described in this article.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Roger Abram (2/10/2010)

---

We have a database that we want to shrink. I understand that checking the box to Reorganize files before releasing unused space might take more time to...

If you run a query twice in a row, the second will (very likely) have 0 physical reads because the data is cached.

Why? They identify log records. What's your interest in seeing them?

I wouldn't bother trying to attach it. The damage you have is not repairable in any way. Get out your backups and restore the DB from the latest backup.

The table...

That's not what I asked. Can you get the...

Yes, however that does not fix a suspect database. It brings a database that's in the RESTORING... state Online.

You can move data from one filegroup to another, but SQL manages where data goes if there are two files in the same filegroup. It uses a proportional fill algorithm.

If...

What's the definition of the Employees view?

Which table do you want to index?

Why are you converting dates to strings?

Why are you using NoLock? Are incorrect results acceptable? See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

The add new thread button is visible when you're in a forum. When you're viewing a thread you can reply to that thread.

No, the difference between 32 bit and 64 bit is around memory addressing.

Not enough information.

You can do either, which will work better is another question. There's no way to answer that without seeing the query that you're tuning indexes for. From your...

32 bit, can only directly address 4 GB, has to use tricks to use more memory than that.

64 bit, flat addressable memory of millions of times more than any server...

From what I can see, you have system processes throwing high severity errors (severity 22).

I think reinstall would be a good idea, because I can't tell why or even what...