Ah, but it appears that may be operating under a really bad premise.  Changing a VARCHAR(200) to a VARCHAR(100) will, by itself, DO NOTHING to save on space.  The...

Thank you but the question above is...

Thank you but the question above is basically just...

we can use sp_spaceused to know how many space reservred by a table and know how many spaces for data space and index space, but if there is...

Thank you Anthony.green!

Jeff  Moden, thank you for your help and guidance !

Yes, I know sql...

In the main table storage area, a row will be on one and only one page.  Any other data for that row must go to overflow pages.

-1- There's not...

Slight bit of misunderstanding there. Let's say we have a VARCHAR(50). Now let's say that our data stored there is 'dog'. It doesn't use storage out to 50 characters....

For most of us, most of the time, that's way too much detail. It begs the question, what problem are you really trying to solve.

However, if you want crazy...

Additionally understanding that the WHERE clauses and JOIN criteria (if any) for data manipulation queries are subject to all the same rules as a SELECT query. Something like a...

about this topic , do you have any other solution? thanks!

Thank you Jeff Moden for you kind help!

you said "Understanding that there are at least 6 different Insert/Update patterns and the 4 of them are seriously affected by "ExpAnsive" updates....

I used SQL profile to trace SQL Statement and found user use insert bulk to insert data for a table, but the sql statment is too long (over...

INSERT BULK is from .Net SqlBulkCopy class, so someone has coded an application which is using that class to load in some data

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlbulkcopy?redirectedfrom=MSDN&view=dotnet-plat-ext-3.1%5B/quote%5D

Thank you, this article of...