Huh. Cool. Always learning. That's the first time I've seen that.

I'm not aware of any way to do this. If you're attempting to insert data that violates a primary key, it's a very serious error.

There is no way. There is no requirement that you enter any kind of license when you install SQL Server.

Just know that forced parameterization is only going to be of limited use in getting plans to be reused. You're likely going to have to go to fully parameterized queries...

I'd start yanking that developer's access to anything and everything I could keep them out of. Then, when they go to management, you go in with a set of documented...

This is a SQL Server 2008...

For queries, execution time and the number of reads. I do use extended events for this all the time now. I've found that STATISTICS IO tends to mask changes in...

Kristen-173977 (9/29/2015)

---

Order is not important. I would recommend that you change the call to your SProc from:

EXEC R01OrderForm @Region, @District, ...

to

EXEC...

Also capture the data from sys.dm_os_wait_stats before and after the period of slowness to understand what the server is waiting on.

If you're really spending time and effort learning SQL Server and you intend on making this a profession, the $50 to purchase the Developer Edition is worth every penny.

jasona.work (9/25/2015)

---

Grant Fritchey (9/25/2015)

---

jasona.work (9/25/2015)

---

I've been wanting to pile into that topic, but keep restraining myself...

Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow...

jasona.work (9/25/2015)

---

I've been wanting to pile into that topic, but keep restraining myself...

Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer?...

Pretty much.

Powershell isn't run from the command line?

OK.

Shortest possible answer:

Yes.