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 16374
How do you use DBCC statements to monitor various aspects of a SQL server installation?1 5556
How do you load large data to the SQL server database?2 9192
How do you check the performance of a query and how do you optimize it?1 6110
Can XML be used to access data?2 1875
What is indexing?
What is normalization and what are the different forms of normalizations?2 11680
Difference between server.transfer and server.execute method?2 9812
What is a function? Give some example?3 7442
What is a stored procedure?3 3212
Difference between Function and Procedure-in general?6 10879
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Tell about MOM Tool(Microsoft Operator Manager)?
What is RMS migrations?
application server is slow what may be the problem
How do you Implement SSIS Packages in your Project?
Scalability, Availability, Integration with internet, etc.)?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Which is the best place or learning center for MS SQL?????In Bangladesh?????
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
Working with TLogs
Why do you want to join software field as you have done your BE in Electronics?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
whats new about truncate in sql server 2008?