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 *,

...

Ideally all relevent legacy...

Know the the Standard Model, the six types of quarks, their intrinic properties and interactions. Also know at least the Wizard's First and Second Rule.

Sending out a broadcast email asking if it's OK to retire a database is good, but depending on the size and organization of the IT department, it's entirely possible for...

If this were Oracle, I could do it all with an inline expression using the DECODE() and LEAST(<value>, <value>, ....) functions.

However, after deriving a version of your table that...

I agree that, if your application needs to reference very large entity-attribute-value datasets, then it would perhaps be best to move those specific tables out of SQL Server and into...

It is possible to remove or hash the personally identifying attributes (name, ssn, contact info, etc.) from a flat dataset or...

Steve, this is just a guess, but has Red Gate offered you a lofty executive position?

Several years back, I was working on a government contract to develop the database backend for a web application that would query a large accounting datamart, and then build a...