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 16276
How do you use DBCC statements to monitor various aspects of a SQL server installation?1 5501
How do you load large data to the SQL server database?2 9074
How do you check the performance of a query and how do you optimize it?1 6046
Can XML be used to access data?2 1812
What is indexing?
What is normalization and what are the different forms of normalizations?2 11563
Difference between server.transfer and server.execute method?2 9762
What is a function? Give some example?3 7370
What is a stored procedure?3 3163
Difference between Function and Procedure-in general?6 10810
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How to trouble shoot if unable to connect SQL Server
Call by value and call by reference in procedure and function, with NOCOPY.
what is checksum in sql server.........???
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
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?
how to do partition in sqlserver
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Delete duplicate rows without using rowid.
New concepts of sql server 2005 use in your project.
How we create SQL Server 2005 Reporting Services ? Give me Sample
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is the difference between NOROW and LOCKROW?