C'mon, that must be trolling.

+1

Unfortunately not easy for...

I already am 😉

By the way Jeff, you had this wonderful...

Sean Lange (9/29/2014)

---

I know that this is not neccesarily your design but starting all your table names with tbl_ and storing the datatype used in the column name is a...

If you put that TSQL statement...

Zero, as the first RAND() is seeded.

The thing is that in Excel you are not actually comparing 3 columns, you are comparing 3 values (which happens to be in 3 different columns).

There is a VAR function...

Hire an overpriced consultant. Chances are they'll listen to him/her...

Went over 13,000 points today. Seems like a déjà vu 😀 😎

arrjay (9/29/2014)

---

OK, thanks for the advice. Are we saying that without making significant structural changes to the table I won't be able tot increase the number of characters in...

My first thought is to get rid of the GUIDs and replace them with integer foreign keys.

I fixed the link 🙂

NVARCHAR(MAX) values are not stored inside the table but in LOB pages. However, a 24-byte pointer is still stored in the regular pages.

What's the Point of Using VARCHAR(n) Anymore?[/url]

This means...

The retry option will launch the job again at the same step.

Did you use variable length columns such as varchar and varbinary?

Why don't you post the table DDL so we can have a look?