All Questions
3 questions
0
votes
1
answer
171
views
Identify table usage in sql server before we stop the load
I tried browsing this across lot of links but cant get much of help so i am posting this question which sound bit similar.
We have quite some tables which are being planned from our app team that they ...
- 9,244
0
votes
1
answer
733
views
Changing Column Data Type with FKs
I want to change my column data type from "Datetime" to "Datetime2(7)". If I try to do it with the GUI SQL Server 2014 asks to save all FKs table dependencies and then I get a lock timeout because ...
- 29.8k
4
votes
3
answers
1k
views
Unable to create / Move data to New Partitions from the existing partition SQL Server 2014
We have an SQL Server 2014 Enterprise Edition and a database around 6 TB in size.
Just to give quick background of infra as Server is in Azure and having premium disk of 9 TB for datafiles.
Have a ...
- 28.5k