SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

6/24/2016

Problems When Running DBCC SHRINKFILE On SQL Server Database

Overview of the Situation While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation for users. One such situation occurs when user are running DBCC SHRINKFILE. There are many issues with running DBCC SHRINKFILE on your SQL Server data file. In the information described below, user will get to know the causes of this issue and relevant solutions to overcome from the situation. Reason for Occurrence of Issue The fragmentation plays a major role in the occurrence of an issue with running DBCC...