What is sorting and what is the difference between sorting and clustered indexes?1 6169
What is the use of SCOPE_IDENTITY() function?2 3786
Can we rollback records deleted by a truncate statement?3 5574
How many types of indexes are there in SQL Server?6 7211
How many types of TRIGGERS are there in MS SQL Server?8 24720
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers1 3630
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?1 3755
Can we execute a stored procedure inside a trigger?6 18457
What is the query optimization statistics?1 1297
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 4019
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 7559
How will u test the stroded procedures and functions? difference between SP and Triggers
explain the type of contraints3 2674
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Does any body please help me what question's have asked for SSRS in the interview?
If we delete pack Spec what will be the status of pack Body ?
what is package and it uses and how can u call a package
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
role of sql sever 2005 in database rather than any other database
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How to trouble shoot if unable to connect SQL Server
which backup strategy you are following at ur company
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
1 01 101 01010