I have already shared hundreds of SQL Server Interview Questions. Here, I would like to share one more common and important SQL Interview question for SQL Beginner. Whenever I am taking the SQL Beginner’s Interview, […]
How to check server side configuration?
SELECT * FROM sys.configurations;
How to check the current location of data and log files for the system databases?
SELECT name, physical_name AS current_file_location
WHERE database_id IN (DB_ID('master'), DB_ID('model'), DB_ID('msdb'), DB_ID('tempdb'));
What are the types of CHECKSUM? SQL Server supports three types of […]