What is the difference between index seek vs. Index scan?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by recursive stored procedure?
What is stretch database in sql server?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is default constraint in ms sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
How to work on DTS?what is the main requirement?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
What is clustered vs nonclustered index?
What do you mean by SQL injection attack?
How many database files are there in sql server 2000?what are they?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
what is denormalization? : Sql server database administration