2 & 7. Yes.

The rest, I don't know. I'd have to go look it up. I'm sure Sean will be haunting this discussion though.

What it's like, at this exact moment, everywhere in Massachusetts.

ChrisM@Work (1/26/2015)

---

Grant Fritchey (1/26/2015)

---

Thanks! But I've already spent the money to build the other costume. Might...

Thanks! But I've already spent the money to build the other costume. Might as well go...

ChrisM@Work (1/26/2015)

---

GilaMonster (1/23/2015)

---

Luis Cazares (1/22/2015)

---

Brandie Tarvin (1/22/2015)

---

rodjkidd (1/22/2015)

---

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes...

You can't restore a table. You can restore a filegroup, so if you put the table into it's own filegroup, that can work. But otherwise, you have to restore the...

sm_iransoftware (1/24/2015)

---

Please say me more about :

"but that means you need to be prepared to deal with a lot of data. You should probably add the query_hash to your...

If your server is already under stress, don't use Profiler on it. Since you're on 2014 (assuming this since you're in a 2014 forum), use Extended Events. They inherently cause...

Pulivarthi Sasidhar (1/22/2015)

---

Below is for your information..... It may be depends on Server Envioronmrnt also....

1. In-place upgrade

Easy to implement

...

If you already have updated hardware, I'd say the problems are probably code and/or data structure related. You need to understand what exactly is running slow and exactly why it's...

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters...

Jeff Moden (1/23/2015)

---

Grant Fritchey (1/23/2015)

---

If you really want to get into all that, I'd suggest picking...

Steve Jones - SSC Editor (1/23/2015)

---

Sioban Krzywicki (1/23/2015)

---

GilaMonster (1/23/2015)

---

I haven't got any clue for a costume. Maybe cheat, buy a green hoodie and go as Arrow (but without a bow...

If you really want to get into all that, I'd suggest picking up a copy of...

Sioban Krzywicki (1/22/2015)

---

Grant Fritchey (1/22/2015)

---

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday...