sven bouapha (8/4/2012)

---

This is really is very interesting!!! This ReFS reminds me of ZFS for Oracle/SUN. ZFS is very nice compared to UFS. When SUN first introduced ZFS, it wasn't...

Put what you wrote here, "We need a senior-level, generalist DBA that can work with three other entry- to mid-level DBAs to maintain a fairly large SQL database infrastructure and...

patrickmcginnis59 (8/3/2012)

---

Michael Valentine Jones (7/30/2012)

---

I'm really not sure exactly what you want to discuss.

There are plenty of people that create denormalized databases and claim they did it for speed, and...

Of course, if you really want to see how complex this kind of thing can get, try to make it deal with things like "USA" (or worse, "USA's"), or names...

Abu Dina (8/3/2012)

---

Thinking about this more, I wonder if the following will work.

Street names in the UK tend to end with words like Street, Avenue, Crescent etc, if I replace...

It's not a substitute for a View. Whoever wrote that doesn't understand what a CTE is.

A View is a stored Select statement. A CTE isn't stored separately, it's...

The Stuff() function can take a variable as the position.

For example:

declare @Position int = 2;

select stuff('mystring', 2, 0, '-');

There are technical means of trying to prevent access. Data encryption outside the database is probably the best for keeping a DBA away from data, but even that may...

Might want to add that to the submission rules on the Write for Us page for QotD.

Two possibilities. Not sure if either is applicable.

First, a RowVersion column. If the data in the source table changes, the RowVersion will be updated. They're sequential (within...

It's one of those things that sounds trivially easy until you start trying to do it.

You could set it to remove subsets, but then you end up with Address2 =...

delete from Table1

where ColumnName in (select ColumnName from Table2 where ...)

That's usually the easiest way to do that kind of thing.

A guy I know recently had something similar in an interview. The interviewer wanted him to test if a word was a pallindrome without using a reverse function. ...

Grant Fritchey (8/2/2012)

---

GSquared (8/1/2012)

---

Ooohhh! I bet that made you popular!

Not that the consultant did anything wrong, but I bet a few people took his comment as a kick to...

Do you mean the part where I said this:

It's been a while since I used Erwin, but, last time I used it, it was a serious PITA. Visio works just...