Identify the problems that you're having, pinpoint the causes and address those directly. Just throwing hardware at the problem may well have no effect or may make whatever problems you're...

You have a server-scoped DDL trigger on CREATE DATABASE?

Well, they're fast drives, what other kind of problem are you expecting them to help with?

So you have procedures running very often, doing a lot of reads from memory...

Again, what is making you think there's an IO-related problem here? You're talking about getting SSDs, but...

Why are you looking at SSDs? What suggests that you have a IO contention?

On a slightly different topic... your procedure has a race-condition. Two people run this at the same time with the same key, one to insert the key and the other...

WayneS (12/1/2014)

---

SQLRNNR (12/1/2014)

---

Koen Verbeeck (12/1/2014)

---

SQLRNNR (12/1/2014)

---

Sean Lange (12/1/2014)

---

Is it just me or is LinkedIn quickly becoming the most useless website in existence? It seems that all that is there is...

If you rebuild the system databases, all 4 get rebuilt. There isn't a 'rebuild master alone' feature.

Clustered index column can be nullable. It's the primary key which does not allow any nulls.

Uniqueidentifier however is generally a bad choice for clustered index because of the randomness. But...

Or maybe a temp table, since the Row_Number function doesn't exist in...

arrjay (12/1/2014)

---

You don't need the .ldf when attaching the .mdf. There is an option in the attach screen you need to tick so SQL creates a new blank .ldf...

Yes.

I'm imagining a server being thrown off a roof... 🙂

If the initial database restore succeeded, they should.

You have done all necessary upgrade testing?

steven 44886 (12/1/2014)

---

Looks like I am out of luck. I don't have the logfile for the database (it was on local storage on the dead server - so probably lost...