You ought to apply SP4, and it only takes minutes. The install is relatively short.

If you have 4 2008 licenses, depending on edition, I think you can install a 2000 instance and a 2008 instance on the same box with 4 CPU sockets. You...

Or check the event logs, usually the security one.

The reason you might need logs from before the full is if your full is broken.

Backup 1 - Full backup

Backup 2 - Log backup

Backup 3 - Full backup

Backup 4 -...

Let's please keep this professional. There's no need for name calling.

I have learned the hard way that the US system for dates is not applicable or appropriate worldwide. I missed...

There usually are downgrade rights for licenses, however they have never allowed you partially license sockets.

In other words, you could never set affinity for 2 CPUs in a 4...

Chad Crawford (3/17/2011)

---

Ah - I forget about the MCM (Microsoft Certified Master), which is still pretty rare. Our illustrious leader Steve has some experience there that he might...

Congrats, I need to take those exams. Did you find them hard?

builds of 2005 http://www.sqlservercentral.com/articles/Administration/2960/

the thing is that execution plan analysis isn't that simple. Grant's book is good, but it's some work to get through.

You might think about

- look to convert scans to seeks

-...

You are welcome, and if you wouldn't mind, can you show the code that worked for you?

Excellent, this should be an easy one.

Especially in SQL CLR. If you pass in the wrong types for conversions, you might end up with multiple conversions...

What you want to do is compare the inserted and deleted tables. If there is no change, then no insert. If there is a difference, then insert something

So if I...

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/