Most likely cause is simply that you are reorging wth too much fragmentation. The page swapping can CRUSH you (and the tlog and data files with writes) when you...

No one uses them.

They are half-baked.

Significant caveats, limitations, provisos, gotchas, etc.

The better question is why...

Ozzmodiar (10/17/2014)

---

Unfortunately SQL Server authentication does not work with Always-On. The accounts have Security identifiers(SID's) that are unique to each server.

Even if you've created the account on both sides...

You need to create logins on all secondaries with the same SID as the primary logins have. You can find various means of doing this online.

Something is COMPLETELY screwed up if you have SSDs for tempdb and it is seeing 6-8 SECONDS of write stalls. Possibilities:

1) left 1MB growth factor and it has a...

ScottPletcher (10/16/2014)

---

From a purely performance stand-point, we'd almost certainly want to process Countries prior to it being JOINed:

SELECT A.City_Name, B.Country_Code, B.Country_Area

FROM Cities A

INNER JOIN (

SELECT...

Lynn Pettis (10/15/2014)

---

I am using IE10.0.9200.17089 and...

Sound like you are well on top of things. Nicely done!

Fortunately you get to call that "JOB SECURITY"!! 😎

My issues were hard crashes of the browser. However, I have noticed them on 2 other sites too, so something has indeed zigged on my machine. Sigh ...

Have you adjusted fill factors down to combat the fragmentation problems? This is about the best you can do. There is obviously a tradeoff of taking more disk...

Someone just did a nice blog post on this, but I can't find it!! 🙁 Itzik Ben-Gan or Dwain Camps or maybe Aaron Bertrand?

Grant Fritchey (10/15/2014)

---

TheSQLGuru (10/15/2014)

---

GilaMonster (10/15/2014)

---

And an extended events session will...

The team that designed the Dynamix app (especially the SQL Server side) should be taken out behind the wood shed and soundly thrashed!! 😀

There have been a number of flaws,...

It may just be a butterfly flapping his wings in China, but I am getting routine crashes on SSC.com forums using IE10.0.9200.17054.

Can't...