Can you post the definition of your sql audit that is failing with the sql login?

You can script it and post that script.

Do you have code and/or execution plan for this procedure?

Can you run the dmf to get index frag info for a larger table alone? While this one is running?

Wondering if it just decided to get hung and stalled.

I...

dwain.c (2/18/2014)

---

Now you're going to need to help me out a little. Can you explain how the first 2 rows of that sample data gets translated to this (your...

How is your memory looking on that server?

Do you have any signs of some memory pressure?

Jeff Moden (2/18/2014)

---

SQLRNNR (2/18/2014)

---

The real answer is "It Depends"

How important is the data to your company/client? Do they have an RTO/RPO specified? In other words, what is the...

Here is a script that I use for that kind of stuff

http://jasonbrimhall.info/2014/01/21/table-hierarchy-updated/

The real answer is "It Depends"

How important is the data to your company/client? Do they have an RTO/RPO specified? In other words, what is the maximum allowable amount...

Greg Edwards-268690 (2/18/2014)

---

Koen Verbeeck (2/18/2014)

---

Steve Jones - SSC Editor (2/18/2014)

---

Ed Wagner (2/17/2014)

---

EL Jerry (2/17/2014)

---

G'Day Everyone!!

Have you noticed the community has grown over 1.7M members?

Congratulations to Steve et al...

Luis Cazares (2/18/2014)

---

Sean Lange (2/18/2014)

---

OCTom (2/18/2014)

---

The following was in 1991 and in response to the question, "How many seminars or classes have you attended to keep up on technology?"

Answer: "I'm...

What patch level and edition of SQL Server 2012?

Is this just opening the queries in a disconnected state or is it disconnecting all open queries?

I agree, the second is joining incorrectly on detailid instead of orderid.

In addition, I would through an Order By on both of those queries so the results are easier to...

saw

I love getting stammering responses to questions like "What do you like to do?"

Well done on the first article. Also, very useful information from Grant.