Alvin Ramard (5/15/2015)

---

Eric M Russell (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL,...

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift,...

Consider replacing the "SELECT TOP 1500" with "SELECT TOP 0".

Luis Cazares (5/14/2015)

---

You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning. How...

Define "working correctly".

When using a local or development envisonment to troubleshoot a performance issue in production, I focus my efforts on reducing logical reads or maybe CPU.

A small box with 2...

mdsantos (5/13/2015)

---

Hi to all,

In my company we are dealing with a very strange problem in the last couple of week in a SQL 2012 server. And maybe you could give...

Some unit tests are derived from high level assertions (ie: each active sales person should be assigned to at least one but no more than three sales regions), and these...

TrailRunner,

You mentioned training for DB2, MySQL, MongoDB, AWS (EC2 + RDS), Netezza, Linux, and Attunity within the past year. Are all these platforms leveraged on the same project, or do...

Iwas Bornready (5/13/2015)

---

TrailRunner (5/12/2015)

---

I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good...

Jeff Moden (5/13/2015)

---

Eric M Russell (5/13/2015)

---

In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition...

Use this to get more detail about the internal storage of your table (clustered index) and non-clustered indexes, which includes avgerage fragmentation percentage and average page density.

select

schema_name(o.schema_id)schema_name,

...

In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which is about $50...

We really should setup a file share...

TrailRunner (5/12/2015)

---

I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good thing is...