Kwisatz78 (7/2/2014)

---

Well I am glad you are talking about things I generally look at when configure a SQL server instance, makes me feel I am on the right track.

In regards...

Did you hear, for a little while Tim Howard was listed on Wikipedia as the US Secretary of Defense. That's awesome.

yeah, I don't have a precise checklist that I use. I'm not sure of one either. Brad McGeehee may have one.

All things you need to do when designing a database fills books. In fact, if you're just getting started at database design, I'd strongly recommend reading a bunch of books....

Kwisatz78 (7/2/2014)

---

Hi Grant

I actually have your book SQl Server 2012 Performance Tuning. The flow of the book seems to be arming the reader with techniques for tuning queries followed...

All performance tuning should start at the server. Ensure the server is well-configured first. Then start gathering metrics, again, at the server level to start. Wait stats, etc. Be sure...

Back to your basic argument, I'm with you. Using the language in the standard mechanism by default is usually the better approach. There are any number of valid reasons to...

GilaMonster (7/2/2014)

---

No, it doesn't. It is not a count...

You could capture a lot more information using extended events. You can usually capture machine name and other information with it. I'm not sure which event I'd set this one...

Just piling on a bit so you have some reinforcement. I'm with Sean and Jeff. Create the tables, but put them in a different schema. Separating function by naming convention...

Why is my log full.[/url]

Sounds like you have it covered. Lock escalation occurs, but I don't find it's a common thing. If you're doing the type of data load that's going to benefit from...

Sarah Wagner (7/1/2014)

---

This was my first article. ...

I've been hearing a lot of mixed stuff lately on the need to update statistics. Personally, I'd do it. It's not going to hurt anything and might help.

You can switch...

michael.minarzick 97083 (7/1/2014)

---

Thank you for the suggestion on the Cost Threshold for Parallelism setting. I'm going to change the value and see how the system performs.

There's no doubt that...