GilaMonster (11/1/2011)

---

The 8-byte RID is only used in...

If the clustered index is on a non-unique key, then...

dva2007 (11/1/2011)

---

if there are more records with the same date in the table, can i create clustered index on that field?

We have 5 years records and the same day have...

As for comparing the cost of hiring a fulltime staff DBA versus the cost of purchasing higher end hardware, the DBA has more value if he/she has expertise in other...

dva2007 (11/1/2011)

---

thanks all for your comments.

As i said i do understand how the table is structured with the index but i am still bit confused.

I have a table which doesnt...

L' Eomot Inversé (10/31/2011)

---

Eric M Russell (10/31/2011)

---

As for the remark

EdVassie (10/31/2011)

---

"The rise of large-memory and large-corecount servers, coupled with the impending tidal wave of SSD storage, means that good...

EdVassie (10/31/2011)

---

Going back to the OP "Where are the good Senior Level DBAs", my experience is there are less people who fit this category than there used to be.

The industry...

L' Eomot Inversé (10/30/2011)

---

Eric M Russell (10/28/2011)

---

If someone has experience performance tuning databases or with disaster recovery, then the first clue is their resume. A candidate will typically provide a...

Ruprecht (10/21/2011)

---

That's exactly the problem I'm having. We don't know what all of these applications are going to be and they might not always be related to our POS...

If someone has experience performance tuning databases or with disaster recovery, then the first clue is their resume. A candidate will typically provide a succinct overivew of previous positions they've...

IceDread (10/28/2011)

---

Even with the perfect security system there is always ways around it. Social engineering, bribery, threats. Someone wants to know something and perhaps you as DBA execute the query...

Any PC side security measures, whether it be software, configuration, or hardware, can be circumvented by a determined user. The most effective security measures are those implemented on the back...

dva2007 (10/26/2011)

---

Steve, Gail,

I always assumed that clustered index put the data in the physical order in the table.

------------------------------------------------------------------------------------------------------------

Again according to this article here it says following:

http://www.sql-server-performance.com/2007/clustered-indexes/

Here are some more...

Revenant (10/27/2011)

---

On apps that contain sensitive enterprise data it common (at least where I am) to have a "DMZ server" ("demilitarized zone") which also acts as a decoy server for...

Since col2 is a varchar column, it's best to treat it like a varchar and use pattern matching. Try this;...