Ed Wagner (7/9/2015)

---

Matt Miller (#4) (7/8/2015)

---

Alvin Ramard (7/8/2015)

---

WayneS (7/8/2015)

---

Alvin Ramard (7/8/2015)

---

Sanity? Oh Sanity? Where are you hiding?

I've had it. Enough is enough! When are people gonna stop hiring people...

Quick questions, what is the .Net version on the box? Can you install the latest .Net if not already there? It's just a hunch but have the latest (4.6) on...

Further on to Lynn's answer, and coining an oxymoron, the more you spend the less you loose, simplified ((Transaction Volume/Time) x (Cost of backup)) * (1 / (Allowed Data Loss))....

Quick suggestion, have a look at https://ola.hallengren.com/%5B/url%5D

😎

j.grimanis (7/8/2015)

---

Hi,

I want to create an XML file with the below format.

office_tel and mobile are fields of a table.

<fields>

<office_tel>

<value>1234</value>

</office_tel>

...

Quick question, any reason for not supplying the information needed to answer the question?

😎

Alvin Ramard (7/8/2015)

---

WayneS (7/8/2015)

---

Alvin Ramard (7/8/2015)

---

Sanity? Oh Sanity? Where are you hiding?

I've had it. Enough is enough! When are people gonna stop hiring people that don't have a clue...

Piling on to Steve's reply, how, what and on what are you trying to do this? Please give us all relevant information as holding back is a waist of everyone's...

TomThomson (7/7/2015)

---

I suspect you didn't mean that.

Or maybe Alvin's question...

a4apple (7/6/2015)

---

Hello everyone,

I have a stored procedure which is nested. I have local variables defined to avoid parameter sniffing in both the procedures too.

Proc A calls PROC B, PROC C,...

Hierarchy

Tom

To quickly grab the blocker's information you can use a tool like SQL Performance Monitor - v3.1, very handy to have on your USB stick

😎

krypto69 (7/2/2015)

---

Hi,

We have a vendor supplied SQL2014 DB. This DB creates blocking but only when running a stored proc the first time with the parameters.

So, for example when my...

USMC