Yeah, I think that would be the easiest. Just drop the index and recreate it with my example. This will also ensure that when the data in the...

Has the full text index been populated? When you create a full text index you have three options to track changes, Automatic, Manual, or Do not track changes. ...

I attended a user group meeting in which we had two speakers talk about and show some examples of both Cassandra and MongoDB. Let me tell you I was...

Thanks, Gail. You're always very helpful.

Steve, it's very nice of you to publish information like this about the SQLServerCentral.com system. I've always been curious as to what powers the site and how well it...

Mike, where do you get...

I'm pretty sure we've talked about this before on this site. Maybe not in the exact context of whether or not to write down a password, but password policies...

Ha. This is my exact situation right now:

http://www.sqlservercentral.com/Forums/Topic926228-266-1.aspx

I've known about the error for over a month now, but management doesn't care because "the application still works for them". ...

Charles broke down some of the figures, but still nobody has mentioned what I feel is the highest cost... each person's time. Andy didn't mentioned how much time those...

OK, thanks for all the help, Gail. We'll schedule some time to try and get this fixed.

OK. 🙂

Thanks, Steve. I did try dropping and rebuilding several indexes (just like you suggested, on a backup server using a recent restore of the database). But it didn't...

Thanks, Gail. The complete output from CheckDB is:

Msg 8904, Level 16, State 1, Line 1

Extent (1:20155592) in database ID 5 is allocated by more than one allocation object.

Msg 8904,...

Thanks.

Thanks for the additional clarification, Raj.