SQL Server Question Bank

CodeBalance: 20 Database Design Best Practices : Use well defined and consistent names for tables and columns (e.g. School, StudentCourse, C...

6.5 Million LinkedIn Passwords May Be In Hands of Hackers | Enterprise Security Today

/3GB is a boot.ini switch that restricts memory usage of kernel mode to 1 GB. Windows Server 2003 includes support for a startup switch t...

This script is with a small modification to include the backup file name from the article published in SqlServerCentral.com   This script wi...

Performance monitoring is an essential task for every DBA. Windows system monitor, Performance Logs and Alerts can be used for performance ...

The Microsoft SQL Server 2005 Mainstream support has ended by 12-April-2011 . Therfore the certification exams associated with the product ...

TRY…CATCH construct is used for error handling in side T-SQL code. A TRY…CATCH construct consists of 2 blocks. One is TRY block that is imm...