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 MoreSQL SERVER – Download Frequently Asked Generic Interview Questions
Yesterday I posted article about SQL SERVER – Most Frequently Asked Generic Interview Questions. I always enjoy when I receive emails and comments about my article. Many readers have asked me to write more about this, I suggest that my readers help me here and add their suggestion and answers…
Read MoreSQL SERVER – Most Frequently Asked Generic Interview Questions
Tell me about yourself. What experience do you have in this field? How many years of experience do you have in area you are applying for? Why did you leave your last job? Why are you planning to leave your current job? What do you know about this organization? Why…
Read More
SQL SERVER – Quick Note on CROSS APPLY
Yesterday I wrote article about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. I had used CROSS APPLY in the query. I got email from one reader asking what is CROSS APPLY. In simpler words, cross apply is like inner join to table valued function which can take parameters. This particular operation is not possible to do using regular JOIN syntax You can see example of CROSS APPLY in my article here.