Talking about military. I'm sure a lot of people know this (twitter, blog), but for those who don't...

Jonathan Kehayias, who posts here from time to time, serves in the US...

I'm not a moderator. Only Steve can delete threads here.

The root cause will be IO subsystem problems. Corruption is (99% of the time) the result of problems somewhere in the IO path. Check anti-virus, check drivers, check HBAs, check...

All columns referenced in the outer select have to be referenced in the inner select as well. The columns in the outer select must not have table names, as the...

Serious? Thought all of those had been changed 15 or so years ago. I know that up here, a registration plate in the old format, regardless of what province it's...

Ah, in that case, your syntax for the cursor is almost right, you just need another FETCH within the Begin.. end of the while loop.

Pretty much the only thing I...

Why are you using a cursor for this? It's a straightforward insert ... select

This will do the same as your cursor and very likely much faster.

INSERT INTO war_ConferenceRegistations

SELECT r.createdbyname,...

Based on just what you posted, the second. I don't see a primary key definition (did you leave it out) and hence there's no index on id.

Not good, absolutely essential. If you're not running CheckDB, how do you expect to find these kind of...

Jan Van der Eecken (7/27/2009)

---

License plates again. Saw a gorgeous blonde driving around in some two seater black cabriolet a couple of months ago. Wouldn't touch her with a ten...

Which is included in SQL 2005 solely for backward compatibility, is deprecated and will be removed in a future version of the product.

shripati (7/27/2009)

---

It's a info message displayed after DBCC command run on your database.

If you get this message regularly check if there is any job created for it in maintenance plan...

Have you done some root cause analysis? Corruption is typically an IO subsystem problem.

Have you scheduled regular CheckDB jobs?

Roy Ernest (7/27/2009)

---

I think the company will shell out money...

Well, they'll be considered for reindexing, and SQL will run the reindex on them, but the eway pages are allocated for very small objects means it's unlikely that they'll get...