Iwas Bornready (8/31/2015)

---

This was fun to read. I saw myself through out the brief article. Keeping in mind that not all problems presented to us are done so to get...

Welsh Corgi (8/31/2015)

---

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless your TEMPDB is...

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless your TEMPDB is competing for storage with other...

I guess there will always be differences of opnion between those who see a database as basically a data reposity for an application, versus those who see a database as...

Orphan records can pose serious problem in an operational or OLTP database. However, they are less of an issue in a data warehouse. There is this thing called "late arriving...

Complaining about foreign keys is sort of like when folks complain about those cement barrades that divide north bound and south bound lanes on a highway or the speed bumps...

What is the source for the parameter values that should be included in this dropdown list?

JustRightOfCenter (8/28/2015)

---

@matt-2 Algate, thank you for pointing out the book. Just ordered two copies.

@eric M Russell, example: I once had a user base whose performance reviews included a metric...

g.britton (8/28/2015)

---

Eric M Russell (8/28/2015)

---

g.britton (8/28/2015)

---

SQL Server has been tightly integrated with various forms of NoSQL data storage and query...

g.britton (8/28/2015)

---

SQL Server has been tightly integrated with various forms of NoSQL data storage and query access for decades. Analysis...

jay-h (8/28/2015)

---

PAH-440118 (8/28/2015)

---

.. I understood was when a woman tells a man a problem she doesn't necessarily want it fixed she wants him to understand what she has to put...

I'll admit that, if what someone really needs at the moment is a sympathetic listener, then I'm probably not the guy they want to turn to. It's doesn't come naturally,...

The best problem solvers don't just fix, we adapt and innovate.

Take for example a scenario where office staff routinely print purchase orders from one application just so they can...

tim_harkin (8/27/2015)

---

Jeff Moden (8/19/2015)

---

There are very few places in SQL Server that have nearly absolute rules but one of them is that you should never store dates or times in...

TheSQLGuru (8/27/2015)

---

You cannot time the restores based on no current connections to the database because in the finite time between determining no connections and getting the restore job kicked off...