homebrew01 has a good point. Check free space in logs/data files, and see if you can make some.

However if you are truly out of space and need to extend things,...

I still prefer the ID. I see the point that countries are standard, but in my lifetime, names have changed quite a bit. That's not a huge problem for updates,...

Yes, potentially. Do you have a filegroup backup?

http://msdn.microsoft.com/en-us/library/aa337540.aspx

Check the default trace: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

Alvin Ramard (8/27/2010)

---

This one really boggles the mind.

Mistake #1: No regular backups

Mistake #2: Cut & Paste DB files (Always COPY, never CUT)

Mistake #3: Deleted records from all the tables

Mistake...

BTW, to a large extent, Monday's editorial (Aug 30) is meant for you citizens of The Thread.

Thanks for the support.

That post kills me. Posted in it, but no backup, and I don't have any money.

If it's important, buy the tool. If it's not, move on.

I assume you mean deleted.

If you don't have a backup, and you don't have the older mdf files, you're stuck. I would take a log backup immediately, and save that.

Your...

Add a

WHERE CHARINDEX(...) > 0

Some of your rows don't have the '.', so the substring throws an error.

And much love for Mr. Pujols. I'm surprised he took longer than A-rod, but I guess he didn't have as much outside help.

There are kids getting the Tommy John without needing it to build strength, or as a preventative measure. Strasburg will be fine.

Moving to SQL Server 2005 forums.

Can you provide more info about what DBCC you ran? what commands and scripts?

There's documentation on the commands here: http://msdn.microsoft.com/en-US/library/ms188796%28v=SQL.90%29.aspx

CirquedeSQLeil (8/27/2010)

---

You...

Stefan Krzywicki (8/27/2010)

---

One thing I've noticed as a consultant is that non-IT hiring managers and most consulting agencies have no idea what a DBA is. If they want someone to...

I have to say Batman as well. He's rich, successful, a normal guy, but he goes out of his way to help others. Good karma.

If we are looking for super...