SQL Server Interview Questions

[coolinterview]

SQL SERVER INTERVIEW QUESTIONS   Download Free Interview Questions eBook of 500 Questions (If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolIntervi...@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.) SQL Server Interview Questions How will you copy the structure of a table without copying the data? http://www.coolinterview.com/interview/14933/   What is the difference between weak entity set & strong entity set? http://www.coolinterview.com/interview/16561/   Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no. http://www.coolinterview.com/interview/14947/   Which RAID levels store parity information? http://www.coolinterview.com/interview/22325/   Explain about SQL server 2005? http://www.coolinterview.com/interview/23174/   What is DESCRIBE command in SQL Server?What is its purpose?How to use it? http://www.coolinterview.com/interview/14931/   Where does Profiler store its temporary data in SQL Server 2005? http://www.coolinterview.com/interview/14918/   Explain about the command line tool SQLCMD? http://www.coolinterview.com/interview/23164/   What is updatable view & non updatable view http://www.coolinterview.com/interview/34123/   What does a @@fetch_status of -2 mean in SQL Server 2005? http://www.coolinterview.com/interview/22278/   What is the difference between primary key and unique key? http://www.coolinterview.com/interview/34124/   How functional dependency is related to database table design? http://www.coolinterview.com/interview/14965/   Explain about reporting services of MYSQL? http://www.coolinterview.com/interview/23157/   Detail about query optimizer? http://www.coolinterview.com/interview/23180/   Detail about the hardware which is supported by SQL server? http://www.coolinterview.com/interview/23144/   What are "HINTS"? What is "index covering" of a query? http://www.coolinterview.com/interview/14954/   What is the difference between User Identification and Authentication? http://www.coolinterview.com/interview/14952/   What does the Log Reader agent in SQL Server 2005 replication do? http://www.coolinterview.com/interview/14922/   What is difference between SET & SELECT http://www.coolinterview.com/interview/34122/   Which protocols support Kerberos authentication on SQL Server 2005? http://www.coolinterview.com/interview/22338/