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 16154
How do you use DBCC statements to monitor various aspects of a SQL server installation?1 5430
How do you load large data to the SQL server database?2 8946
How do you check the performance of a query and how do you optimize it?1 5932
Can XML be used to access data?2 1742
What is indexing?
What is normalization and what are the different forms of normalizations?2 11346
Difference between server.transfer and server.execute method?2 9669
What is a function? Give some example?3 7260
What is a stored procedure?3 3064
Difference between Function and Procedure-in general?6 10687
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
what is isolation level at dead lock?
How to convert a table data in XML format in sql server?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
how can u get last observation in an unknown dataset ?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
role of sql sever 2005 in database rather than any other database
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
how to overcome kernel isssues
If user is owning any SQL Objects, can we drop that user
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
sql database suspect We have a sql database that is showing as suspect. How can we recover?