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;...

phual (10/26/2011)

---

I have a need to concatonate the values of ten fields together, but to only include a separator if there are values to separate.

E.g.

@Param1 = NULL

@Param2 = 'Value1'

@Param3...

On the laptop I use to VPN into the office, I have separate boot and data partitions for personal use and then work, where one is not visible to the...

I think the article presents a good enough solution to a specific problem. If I ever have a need to select the TOP X columns from a table, then it...

sanjay.patel 30254 (10/25/2011)

---

Have you ever worked up a example to display dynaimc source to destination data column mapppings using the same technique, and also the matching of data items from...