Brandie Tarvin (3/24/2016)

---

<headdesk>

One of my coworkers just came up with the worst joke ever.

Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!

Will...

I was curious and looked at the thread.

ChrisM@home (10/22/2012)

---

yuvipoy (10/22/2012)

---

ChrisM as...

db8 (3/23/2016)

---

preparing T-SQL ,

they told me we can sort by using ,with index clause.

don't know what exactly use of this with index clause I will confirm on this...

It's a custom, user-created function which...

Let's reformat the code to make it more readable:

SUBSTRING

(

(

SELECT ', ' + gen_Firstname + ' ' + gen_Lastname

FROM...

Ray K (3/23/2016)

---

Interesting.

I won't say whether or not I believe it, but whether or not he actually does, that's his prerogative. ...

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The idea of presenting...

This is my "get numbers" or "fntally" function which has served me well.

I started with what I've learned from Jeff Moden including the 0 or 1 start functionality. Then added...

Stephanie Giovannini (3/23/2016)

---

David McKinney (3/23/2016)

---

A slight variation (although I've not got SQL installed to test it.)

CONSTRAINT ck_xxx CHECK ('' not in (c1,c2,c3,c4,c5))

Would you kindly check and let me...

I finished your execution plan book while I was on vacation last...

There's a bunch of ways. Easiest would be:

In SQL Server Management Studio right-click the table then navigate to "export" and walk through use the wizard. The most common format/output is...

I love the precision in these errors....

Also, try to post the DDL and some sample data for the tables referenced in your query. Note the link on how to get help in my signature...

In the...

Can you post the actual (not estimated) execution plans?

Interviewing for what position?... DBA? SQL Developer? Data Architect? BI Consultant?

What kind of interview?... Purely technical, e.g. "what's an index?" Strategic, e.g. "why would you create an index"?

More...