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 16430
How do you use DBCC statements to monitor various aspects of a SQL server installation?1 5620
How do you load large data to the SQL server database?2 9286
How do you check the performance of a query and how do you optimize it?1 6203
Can XML be used to access data?2 1928
What is indexing?
What is normalization and what are the different forms of normalizations?2 11787
Difference between server.transfer and server.execute method?2 9865
What is a function? Give some example?3 7491
What is a stored procedure?3 3257
Difference between Function and Procedure-in general?6 10929
How can we call UDF(User Define Function) using C# code in ASP.net ?
can any body tell me how to know the password of current user in sql server
how to take backup bcp out for a column in table in sql server?
how can you attach more than 20 ldf files in sql server
Comment,Datatypes are unlimited
How you trouble shoot when any job fails
wat wil hapn if we give the both read and deny read permission to user?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
which backup strategy you are following at ur company
Issues related in upgrading SQL Server 2000 to 2005 / 2008
If user is owning any SQL Objects, can we drop that user
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible