All Questions
3 questions
0
votes
1
answer
615
views
Questions on database table and index partitioning in SQL Server
I have developed Transact-SQL script to partition the table. To apply the partition, I am creating one non-clustered index for my partition key column and associating it to partition scheme. I have ...
1
vote
1
answer
5k
views
Selecting rows from same name table from multiple databases in single result set
For some reason, I have a table Table_1 in n databases (same name and schema structure) instead of one single databases. The columns are like this:
| Column_1 | Column_2 |
I can select data from ...
- 911
4
votes
1
answer
1k
views
Table Data Space Used Confusion
I have a heap table with around 700k rows. The rowsize is 34 bytes: (1x BIGINT, 2x SMALLINT, 2x BIT, 4X INT, 1x SMALLDATETIME). Why does Data Space Used say this table is taking up nearly 4000000KB (...
- 943