Jeff Moden (3/30/2010)

---

No... you're quite correct about SSIS and SSRS. The difference between myself and many managers is before I'd conduct interviews for a position that required either or...

bpowers (3/30/2010)

---

How do search a table for anything containing an underscore? Since this is a wildcard in SQL I can not find a way to search for it.

SELECT ID FROM...

Per MSDN:

The effective permissions that a principal has on a securable are the result of the explicit permissions defined for that principal on that securable, the permissions defined on the...

dma-669038 (3/30/2010)

---

GSquared (3/30/2010)

---

Jeff Moden (3/30/2010)

---

GSquared (3/30/2010)

---

There is no way short of hiring someone and putting them to work, to fully verify that someone knows the skills they are claiming. None...

The reasons I can think of are:

It can make scaling the database out more difficult. If one application eventually ends up needing its own server, due to size and/or...

Is that script dynamically generated? It seems to run on its own.

Kit G (3/30/2010)

---

I just realized I'm not understanding the context of a word being used here. That word is "gamer".

From the search I did on the Internet and various...

Jeff Moden (3/30/2010)

---

GSquared (3/30/2010)

---

There is no way short of hiring someone and putting them to work, to fully verify that someone knows the skills they are claiming. None that's realistic,...

Are the indexes used for range scans, or for selecting single rows?

You can do that. Would be dynamic SQL, and you'd have to take all usual efforts to prevent injection attacks.

We use XOSoft at the company I currently work for. It's quite good at failover, and horrible at failback.

If we want to start using the DR servers, it's very...

If that's an interview question, then the correct answer is "I don't know, but I can research it", and then tell the interviewer how you'd go about researching it. ...

Add a drop-down to the report parameters with the various comparison operators in the drop-down. Then use that parameter in the Where clause.

Where @Operator = '>' and MyColumn >...

C.J. (3/30/2010)

---

How do I unsubscribe from e-mail notifications of comments to THIS thread only?

Since last week, I'm spending the first several minutes of each morning deleting notifications of comments...

dma-669038 (3/30/2010)

---

GSquared (3/30/2010)

---

Jack Corbett (3/30/2010)

---

Good points Gus.

Since most businesses aren't willing (at least in the US) to even pay to train people who already work for them, it would be...