SQL SERVER – 2005 Best Practices Analyzer (January 2008)
SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer
SQLAuthroity News – Microsoft SQL Server 2000 Assessment Configuration Pack
SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples
SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet
SQLAuthority News – Good Motivational Quotes for Interviews
Here are few motivational quotes for candidates who are appearing for interview. I have collected this throughout the years and it is running list of the interview. Please feel free to let me know if you find any such good interview quote and I will update in this list.
SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure
SQL SERVER – Reclaim Space After Dropping Variable – Length Columns Using DBCC CLEANTABLE
All DBA and Developers must have observed when any variable length column is dropped from table, it does not reduce the size of table. Table size stays the same till Indexes are reorganized or rebuild. There is also DBCC command DBCC CLEANTABLE, which can be used to reclaim any space previously occupied with variable length columns. Variable length columns include varchar, nvarchar, varchar(max), nvarchar(max), varbinary, varbinary(max), text, ntext, image, sql_variant, and xml. Space can be reclaimed when variable length column is also modified to lesser length.