polkadot (9/4/2014)

---

Thanks Grant.

By extensible I mean, current practices that will allow maximum future flexibility to rearranging server and network infrastructure. For example, in the near future we may acquire...

SimonHolzman (9/4/2014)

---

Sadly, at $350 per user, I...

Can you further define what you mean by "extensibility of environments"? Are you talking about a scale out scenario? Scale out means that in order to support an increasing load...

a2zwd (9/4/2014)

---

Hi Friends,

I have worked on different DB projects. All the companies I worked will design DB/tables directly in sql server management studio. Means they do...

Here's the issue:

dbo.NEW_ORDER WITH (serializable updlock)

You need to change it to:

dbo.NEW_ORDER WITH (serializable, updlock)

BWFC (9/4/2014)

---

Grant Fritchey (9/4/2014)

---

The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry level data...

The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry level data professional positions. It's...

Ha!

I wasn't aware that was an event, especially with all these people.

SQLRNNR (9/3/2014)

---

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just...

Sean Lange (9/3/2014)

---

Gazareth (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to...

HowardW (9/3/2014)

---

Grant Fritchey (9/3/2014)

---

Pretty much that whole WHERE clause is an issue. Functions on columns or functions to determine values within a WHERE clause, JOIN criteria or a HAVING clause...

Core problem there is that you may not know what you don't know, meaning, it's entirely possible for there to be queries coming from sources that you don't know that...

I'd simply set up a test to show it. Create a copy of your tables and show queries with and without Column C. Specifically, focus on the execution plan to...

Pretty much that whole WHERE clause is an issue. Functions on columns or functions to determine values within a WHERE clause, JOIN criteria or a HAVING clause will all impact...

Adding a new table, no. If we're just talking about adding a blank table to the database and nothing else.

Adding that column to a table, well, it depends. If it's...