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

If possible, try running a schema comparison including indexes and statistics between the new database and the previous database instance. Perhaps in the process of migrating to the new server...

On a slow day, even the best of us may become so distracted by the challenge of solving some small...

For more complex type record matching problems, I turn to the ranking functions.

Example:

select * from

(

select *,

...