All Questions
3 questions
2
votes
0
answers
756
views
SQL Server : the partition scheme cannot be changed because there exists one or more incremental statistics on the table
I get this error and I cannot find solution for it
The partition scheme cannot be changed because there exists one or more incremental statistics on the table
The background:
SQL Server 2017
I have ...
- 21
1
vote
1
answer
5k
views
How to visually see partition schemes in SQL Server Management Studio?
How can I visually see partition schemes in SQL Server Management Studio? I don't see them anywhere in the database.
- 1,671
6
votes
3
answers
34k
views
Find Partition Schema Definitions in SQL Server Database
I have access to a database and I need to know the Partition Scheme definitions in the database. i.e. I need to know the partition scheme name, which Partition function is it using, what file groups ...
- 171