What's the size of a pointer to a variable width column?

Thanks Scott, but "present" how? They don't show up in storage.

And if NULL is set as 1 bit per column, then I should be showing the size of the table...

Thank you all for the input. I know I was vague, but I can't be disclosing company-sensitive stuff.
I'm glad I can come here for more opinions of people who...

They say it is scalability and rapid development.
I believe it is because someone heard buzzwords & they don't understand the technologies involved.
They have not done any study. They...

Hi everyone,
It has been awhile since I posted here and I hope you're all doing well.
I have a weird situation and I was wondering about the opinion of...

The child information gets created first as it is configuration data. Parent records might not get created for hours or days after.
Basically I want to create orphans and have...

Since the person in question was transferring a terrabyte database on a laptop, lack of RAM is likely it. Thanks all!

Jeff Moden (12/27/2016)

ScottPletcher (12/27/2016)

Jeff Moden (12/26/2016)

Sergiy (12/15/2016)

ScottPletcher (12/15/2016)

I guess I don't see why that's so much worse than a non-bit comparison...

Jeff Moden (12/26/2016)

Sergiy (12/15/2016)

ScottPletcher (12/15/2016)

I guess I don't see why that's so much worse than a non-bit comparison of "status =...

squvi.87 (12/14/2016)

Need to generate random number based on ID3 column. Have mentioned each rows logic in remarks. Note: This is a sample data I need to apply on big set...

ScottPletcher (12/15/2016)

I guess I don't see why that's so much worse than a non-bit comparison of "status = 8" or "code1...

Jeff Moden (12/15/2016)

Sioban Krzywicki (12/15/2016)

Jeff Moden (12/14/2016)

Who's...

Jeff Moden (12/14/2016)

Who's going to read the...

Of course...

What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?