GUIDs can work, but they aren't the answer. Nor are they likely the problem.

I'm sure we can all find edge cases where they work or don't work, but the point...

Mike Toole (10/13/2010)

---

Rest easy Steve, a quick perusal of comments added to the linked report will establish that malware was certainly not the cause of the crash, and that the...

:), the DBA's Dilemma.

Hyperdata (10/12/2010)

---

All of your comments are great! I would like to add one that I don't believe has been mentioned. Suppose a business has a database application that...

Wayne,

good to hear you're considering the Rally. Hopefully I'll be there as well. Working on pre-con submission right now.

OK, I'm confused. Any ideas? Difference in performance after copying the mdf to a new server.

http://www.sqlservercentral.com/Forums/Topic1002991-360-1.aspx?Update=1

It's possible that the data set exceeded a size and the query will no longer function well. There are lots of queries that do work fine for years and then...

Everything should be the same if you copied the files.

It couldn't hurt to rebuild them. Have you checked the execution plan?

Rays/Rangers, still a chance for them to prove me right that Texas will win.

Good to see the Giants win last night.

I'm rooting for the Yankees since I think this is...

AFAIK, MysteryJimbo is correct. I've had error logs grow into the GB, which makes looking through them hard. Typically I've cycled them every week or so in order to keep...

It's not unusual to have SQL spike the CPU for short periods of time.

Have you checked the execution plans to see if they're the same? Rebuild statistics? Is the data...

Nice idea, but I'm not sure it will drive...

What are you trying to accomplish? Recreate an empty db? SQL Compare will work, as will a backup and restore ,and truncate all tables.

Anyone is welcome with a ticket. Spouses included. You can paypal $30 or pay at the door.

I have found that single rooms are the best earplugs 😛