Unless you actually need more the 8000 characters.

Jeff is right. VARCHAR(N) is faster than VARCHAR(MAX), but...

Snargables (8/16/2016)

---

This is a one off and will probably need to be done every 2 to 3 years. It's 80 percent one table. I'm going to be breaking the table...

Also worth mentioning is that the rowmodctr value after 2005 is just an estimate. Microsoft says it will be, something along the lines of, "mostly the same values" as it...

Yeah, pretty much....

ScottPletcher (8/16/2016)

---

Grant Fritchey (8/16/2016)

---

MyDoggieJessie (8/16/2016)

---

I've always been a little fuzzy on this one - So, is just executing sp_updatestats a safe bet after indexing? Realizing that rebuilildng indexes will...

MyDoggieJessie (8/16/2016)

---

I've always been a little fuzzy on this one - So, is just executing sp_updatestats a safe bet after indexing? Realizing that rebuilildng indexes will only affect the...

crazy_new (8/16/2016)

---

Hi Guys thanks for the replies it was very helpful. Just one more thing, If say I have a clustered index on ProductID, and ProductID is the first column...

yujinagata72 (8/16/2016)

---

Hi,

If I get a query plan XML, what kind of information will make it to be considered as a 'bad' plan?

I can think of the following:

- PhysicalOp="Clustered Index Scan"

-...

Snargables (8/16/2016)

---

Everything i read goes on and on about how bad it is. One of our sql instances houses a database that uses mainly batch processing and as a result...

You can capture plans using extended events (or trace, but I wouldn't suggest trace since it's filtering mechanism is so weak and capturing execution plans is so expensive), but be...

Brandie Tarvin (8/16/2016)

---

Has anyone here used GitHub?

If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?

We're apparently getting it...

You will see some performance gains, but they're not astronomical.

Use powershell. You can identify the date and just bring back the ones you need that way.

Fundamentally, a deadlock is a performance issue. If the transactions complete fast enough, you won't see a deadlock. The trick to fixing them is to address both sides. Yeah, you...

The main difference is over the use of in-row storage. VARCHAR will always have it, VARCHAR(MAX) will bias towards it, but then move to LOB storage when it needs to...