What is sorting and what is the difference between sorting and clustered indexes?1 5892
What is the use of SCOPE_IDENTITY() function?2 3567
Can we rollback records deleted by a truncate statement?3 5241
How many types of indexes are there in SQL Server?6 6789
How many types of TRIGGERS are there in MS SQL Server?8 23908
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers1 3407
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?1 3541
Can we execute a stored procedure inside a trigger?6 17392
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 3839
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 7054
How will u test the stroded procedures and functions? difference between SP and Triggers
explain the type of contraints3 2459
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is best institute to Learn DotNET And SQL in chennai?
How can we call UDF(User Define Function) using C# code in ASP.net ?
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.
which backup strategy you are following at ur company
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Working with TLogs
Scalability, Availability, Integration with internet, etc.)?
ow to bring suspect mode datbase online from scratch
where the connection string store in the database
application server is slow what may be the problem
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
What are the dis_advantages of stored procedures, triggers, indexes?
What is Lock table in SQL?
How much memory that we are using in Logshipping Concept?