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 16084
How do you use DBCC statements to monitor various aspects of a SQL server installation?1 5384
How do you load large data to the SQL server database?2 8831
How do you check the performance of a query and how do you optimize it?1 5879
Can XML be used to access data?2 1702
What is indexing?
What is normalization and what are the different forms of normalizations?2 11211
Difference between server.transfer and server.execute method?2 9607
What is a function? Give some example?3 7195
What is a stored procedure?3 3015
Difference between Function and Procedure-in general?6 10628
what is isolation level at dead lock?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
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
how to do partition in sqlserver
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How we create SQL Server 2005 Reporting Services ? Give me Sample
tell me the disaster recovery plan
If a stored procedure is taking a table data type, how it looks?
How retrieve field names from the table in SQL through JAVA code?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How do use Having,Group by,Group function in SQL?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
how can u get last observation in an unknown dataset ?