What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What are cursors? Name four types of cursors and when each one would be applied?3 16978
How do you use DBCC statements to monitor various aspects of a SQL server installation?1 5961
How do you load large data to the SQL server database?2 9728
How do you check the performance of a query and how do you optimize it?1 6591
Can XML be used to access data?2 2290
What is indexing?
What is normalization and what are the different forms of normalizations?2 12471
Difference between server.transfer and server.execute method?2 10245
What is a function? Give some example?3 7907
What is a stored procedure?3 3779
Difference between Function and Procedure-in general?6 11612
What is BLOCK statements in SQL?
How will you know when statistics on a table are obsolete?
What are the tables in sql?
How can you hide the sql server instances?
What is temporal data type?
What is the purpose of object explorer and its features? : sql server management studio
Please illustrate physical database architecture? : SQL Server Architecture
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are the options which must be set to allow the usage of optimistic models?
when would you go for denormalization? : Sql server database administration
what changed between the previous version of sql server and the current version? : Sql server database administration
What are the types of dml?
What is sql sandbox in sql server?
New concepts of sql server 2005 use in your project.