What is sorting and what is the difference between sorting and clustered indexes?1 5978
What is the use of SCOPE_IDENTITY() function?2 3625
Can we rollback records deleted by a truncate statement?3 5323
How many types of indexes are there in SQL Server?6 6896
How many types of TRIGGERS are there in MS SQL Server?8 24133
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers1 3472
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?1 3596
Can we execute a stored procedure inside a trigger?6 17759
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?3 3875
write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car12 7169
How will u test the stroded procedures and functions? difference between SP and Triggers
explain the type of contraints3 2515
what is the Ticketing tool used in Wipro technologies at Bangalore...???
how to overcome kernel isssues
Comment,Datatypes are unlimited
role of sql sever 2005 in database rather than any other database
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.
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How do you Implement SSIS Packages in your Project?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
whats new about truncate in sql server 2008?
How do use Having,Group by,Group function in SQL?
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.
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is the difference between NOROW and LOCKROW?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Working with TLogs