Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new databases which gets created will have page verify =…
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information within SQLServer. Today I was running the ‘Disk Usage’ report…
Today there was an interesting question posted on twitter, and that made me think about ways on how we can play around with SQL Server features/options to find solutions for…
There are instances where in we need to rename the files and below simple Alter command will do that for you : ALTER DATABASE <Database> MODIFY FILE (NAME = <Current…