Tag Info

New answers tagged

4

First and foremost thing, SQL Server in picture is SQL Server 2008 R2 RTM which is not supported by Microsoft in any way please apply SQL Server 2008 R2 SP3 to at least get extended support I analyzed and found that one of the User DB A was using 8 GB RAM I don't think there is any issue because of this, this is totally normal looking at this you ...


1

That's a tough question to answer without more schema and workload information, but the key benefit to a clustered secondary index is that it contains not just the indexed columns and all other columns in the table. "Normal" secondary indexes contain the indexed columns and the primary key (which is used to look-up the other columns for your SELECT ...


3

This behavior for large objects storage can be controlled by the table setting: exec sp_tableoption N'MyTable', 'large value types out of row', <'ON' or 'OFF'> The reference in the SQL Server 2012 documentation is at: http://msdn.microsoft.com/en-us/library/ms173530.aspx Therefore you can control where the space is used, in-row or stored out of row. ...


12

I know that when VARCHAR(MAX)/NVARCHAR(MAX) columns are used the data is stored out of the row... Actually, that depends on the setting of the large value types out of row option, which can be set using sp_tableoption. From the documentation: The default is for MAX values to be stored in-row, up to 8000 bytes, if they fit. Unless you have used ...



Top 50 recent answers are included