Index 255 is the Large Object data for a table. For sysindexes, it's going to be the data in the column statsblob, as that's the only LOB column in the...

Please run the following and post the full results.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

Take a look at this article. http://www.sqlservercentral.com/articles/65804/, specifically the section on 'irreparable corruption'

How...

Are you talking about deadlocks or are you talking about blocking? With deadlocks, SQL will automatically find the involved processes, pick one and kill it. You don't have to do...

Use MyDatabase

GO

SELECT 1

If the DB isn't available, that will fail

You sure about that?

An offline index rebuild takes locks on...

It's not a tool. It's a service offered by Microsoft's Premier Support people. I don't know if you can get an...

What do you mean by 'availability'? Precisely what are you looking for?

Ask to be involved in the data capture for it. You probably would be anyway.

It won't cause problems, but it's unnecessary. If the indexes are identical in columns then they are redundant and you're paying the cost for updating both while getting the benefits...

Manie Verster (5/11/2009)

---

No, you're right, I just get the feeling that developers are getting slaughtered over here. I see blood all over the place and people seem to forget that...

Because people use it. It wasn't intended to be used for concatenating a...

Not something I've ever heard of, not something I can find any reference to on google.

Ask him if, next time it happens, he can check a few things:

log_reuse_wait_descr in sys.databases

DBCC...

Database consultant specialising in performance tuning, SQL development...

The portion of the article that I was mostly referring to was the last paragraph.

If you’re a developer or Windows admin, try to get promoted internally rather than switching companies....

http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/