When I see that list, I'm not at all scared. I've seen many descriptions, not just in tech, but in medicine, legal, hospitality, etc. where a job ad is...

Presumably you are defining the PRIMARY KEYs as such, rather than using UNIQUE constraints?  PRIMARY KEYs 'default' to being clustered.  Broadly speaking clustering improves performance.  These days, for permanent...

Ok... I'm pretty sure that I was correct so here it is again.

You can't actually define a "field" as being unique.  Instead, an unique index must be created.  That can...

Post withdrawn... gotta check on something...

Thank you all!

One more question though not fully related to this topic, for UNIQUE fields, is there a difference to define UNIQUE at column definition and/or while defining index?...

That might also be the reason why they've done the RBAR thing in the trigger.  They don't want to have everything during and Insert or Update...

I guess I don't understand two things...

1. Why you would ever want the documentation to be separate from the database.
2. Why on Earth you would want the result...

I want to design a database for an OLTP app where it mainly involves customer and transaction. I know we have up to 1024 columns in a table, but...

I guess I don't understand two things...

1. Why you would ever want the documentation to be separate from the database.
2. Why on Earth you would want the result to be...

None of that actually has anything to do with the OP's table except that you've done the same unnecessary expansion of a column like you claim he did with the...

Some good but with little to no experience???  Dude, suck them up and train them before someone corrupts them. 😀

Ok... so let's see your final output as an attached file, please.

Brent Ozar wrote an article about how they can force you query to go single threaded even if you're query is absolutely perfect in every other way and even when...

Man... talk about a worse practice ever.  If you're going to do something this silly, use a GUID... at least...

@jeff  When I ran your code and seeing what @sql has in it, that's exactly what I was trying to achieve. How to you get that into an email...