Today I installed SQL Server in my environment. Everything well good SQL Server installed successfully. I connected to the SQL Server and was able to login. So happily logged off and was resting happily. Than thought of doing one more
As BOL “A Suspect table contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect
Log shipping creates jobs for Backup, Copy and restore. We need to create folders for the Backup and Copy. Backup folder should be on the network and SQL Server Agent service accounts of both primary and secondary server should have
Trace Flags are used to switch On/Off a specific characteristic in SQL Server. A trace can be either set for global scope or session scope depending upon your choice and requirement. A Trace flag enabled on the sessional scope will remain
PAGES: As per BOL “The fundamental unit of data storage in SQL Server is the page. The disk space allocated to a data file (.mdf or .ndf) in a database is logically divided into pages numbered contiguously from 0 to n.
Better late than never. For the last 2-3 years I was thinking to create a blog of my own, but always something or the other comes. Job changes (3 to be precise in the last 3 years), getting married and