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
Six months ago I wrote article about SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility. Yesterday I received an email asking that one of my blog reader is not able to use the sp_dbcmptlevel command with error that database is in use. He has asked me to…
Read More
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.
SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table
One of my friend involved with large business of medical transcript invited me for SQL Server improvement talk last weekend. I had great time talking with group of DBA and developers. One of the topic which was discussed was how to find out Fragmentation Information for any table in one…
Read MoreSQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO
Following question was asking by one of long time reader who really liked trick of SQL SERVER – Explanation SQL Command GO and SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL. She asked how can I execute same code multiple times without Copy…
Read More
SQL SERVER – Export Data From SQL Server to Microsoft Excel Datasheet
Question: How to Export Data From SQL Server to Microsoft Excel Datasheet?
SQL SERVER – 2005 – Introduction and Explanation to SYNONYM – Helpful T-SQL Feature for Developer
One of my friend and extremely smart DBA Jonathan from Las Vegas has pointed out nice little enhancement in T-SQL. I was very pleased when I learned about SYNONYM feature in SQL Server 2005. DBA have been referencing database objects in four part names. SQL Server 2005 introduces the concept…
Read More