score:2
That depends on your access patterns. Do you often need to access data from multiple partitions at once? Then you should probably combine them.
Anyway, development is probably easier when you only have one table (without one-to-one joins). If there is no particular reason to split them, combine them.
Attention: I think there is a column limit in SQL Server.
You can expose subsets of the columns by creating indexes. Each index would be set on the ID column with an arbitrary subset of columns as "included" columns. This will leave the choice to the optimizer. It will choose the best possible way. It can also join between indexes so you are in a total win situation that way.
Recommendation: Combine the tables into one and create one index for each table you previously had.
More questions
- SQL Server 2012 Table Columns & Performance
- How to get all columns from first table when there is no matching column in SQL Server 2012
- SQL server performance when table has many columns
- SQL Server Performance New Table vs New Columns
- SQL Server 2012 Retrieving Attributes for 2 Columns of a Table
- How to select all the columns data except few column in a table - SQL Server 2012
- How to find sum of multiple columns in a table in SQL Server 2005?
- SQL Server 2008: The columns in table do not match an existing primary key or unique constraint
- SQL Server Determine Physical Size of Table Columns
- Performance of User-Defined Table Types in SQL Server
- How to remove auto increment from table in sql server 2012
- Sql server update multiple columns from another table
- Is there any performance issue using Row_Number to implement table paging in Sql Server 2008?
- Slow performance when using OFFSET/FETCH with Fulltext in SQL Server 2012
- Does order of the columns in columnstore index matters in SQL Server 2012
- Table alias ignored for columns specified in INSERT statement in SQL Server
- Allowing a stored procedure to select from a system table using a certificate in SQL Server 2012
- DELETE performance in SQL Server on clustered index, large table
- Get list of columns in a temp table in SQL Server
- Create a table from CSV columns in SQL Server without using a cursor
- SQL Server performance and fully qualified table names
- SQL Server 2012 Bulk Insert from CSV into temp table
- How to find columns count of any table in any database from sql server master database?
- SQL Server performance for alter table alter column change data type
- SQL Server passing table columns to a function's parameter
- Access columns of a table by index instead of name in SQL Server stored procedure
- How to improve performance in SQL Server table with image fields?
- SQL Server 2012 - Insert into linked server table using openquery
- Can i monitor performance of particular table in sql server 2008 profiler
- How to unpivot columns using CROSS APPLY in SQL Server 2012
More questions with similar tag
- Return array in CLR function
- Union All Help Needed
- take count of item depend on the specific calulation
- SQL Transpose row data into columns
- simultaneous requests time out from same browser
- The Integration Services component is not installed or you do not have permission to use it
- SQL Server and auto conversions?
- Why does ASP.Net Identity 2 store in UserId in a NVARCHAR?
- Min/Max Date Values over Large Date Range depending on Value
- Query with row_number() taking too much time
- VB.Net: Escape singles quotes in query string that uses a variable with single quotes
- Using SQL Server Express edition instead of Compact edition as local database cache?
- How to get Ruby on Rails to generate a model using sql server 2008
- Alter WHERE clause based on parameter
- Operand type clash: int is incompatible with uniqueidentifier in sqlsever 2012
- SQL query to return Json including array
- Saving Japanese Text to SQL Database
- Replace Unicode characters in T-SQL
- Echo html code from php to html
- Using STIntersects to update a table
- SQL Server: date function in group by clause
- How can I deploy the SQL server database with my setup and deployment project in Visual Studio 2010?
- Why ISNumeric() Transact-SQL function treats some var-chars as Int
- How to use Key {Key:pair} passed from Python to SQL server query
- Will SQL Server consistently short circuit in this specific case?
- What does the GO command do in an SQL script?
- Copy of certain fields from one table to another in MSSQL
- C# - How To Retrieve SQL Server Time(7) Into TimeSpan
- MSSQL Check If From, To Date will fit between time range
- Else statement bug or transaction effect?