Brandie Tarvin (10/12/2016)

---

A couple of things to remember. You want separate environments for Dev, QA (QC or Test or both), and Production. The different environments should mirror each other as...

You hope. That's why we verify everything. A little paranoia goes a...

If you have questions, just ask. I'll do what I can to help out. This is a huge topic.

jasona.work (10/12/2016)

---

Now this sounds like it has an interesting story behind it...

Grant Fritchey (10/12/2016)

---

I'm the guy who helped a developer send porn to our client list (I didn't clean up...

lindsayscott23 (10/12/2016)

---

Hi,

Firstly I hope this question is in the right forum. I usually ask pretty standard TSQL questions, and this is the first time I've really had to think about...

It's not big growth, at all. That's .05gb/day. In 50 days, two months, you'll grow 2.5gb. In 500 days, you'll grow 25gb. Storage currently costs about $0.019/gb. To support almost...

Do you test the backups from your primary production servers? By test, I mean, the full range of tests[/url], including a restore? If so, toss those secondary backups. They're not...

Set up auditing. You're in SQL Server 2014. You can use extended events. It won't help you now, but it will help you tomorrow and next week and...

wendy elizabeth (10/11/2016)

---

I like your idea of using the output clause from the insert statement. However, I will still have the same problem of trying to obtain the unique lockid...

Instead of trying to query to retrieve the inserted values, how about using the OUTPUT clause to save them to a temporary table or a table variable and then use...

Check the execution plans for each query to see how they're being resolved.

This is the 2008 forum, so I suspect this won't help, but if you're on 2012 or better, you could look at using SEQUENCE to possibly do what you're looking...

DesNorton (10/11/2016)

---

Grant Fritchey (10/11/2016)

---

What everyone else has said, plus.

If you're going to attempt to tune the query, you absolutely have to have the execution plans. There is no way you...

rodjkidd (10/11/2016)

---

Grant Fritchey (10/11/2016)

---

rodjkidd (10/11/2016)

---

Grant or anyone else in Boston or NY,

I'm assuming its easier to take the train for that leg of my trip.

Should I pre book, or is...

rodjkidd (10/11/2016)

---

Grant or anyone else in Boston or NY,

I'm assuming its easier to take the train for that leg of my trip.

Should I pre book, or is it just the...