If there is failure during updation of certain rows, what will be the state?2 8324
What is the difference between Userdefined function and stored procedure? Explain and give the example also5 6303
how to dispaly a particular row details from a given table2 3732
What is a transaction and what are ACID properties?3 4717
Explain different isolation levels?4 7435
What's the maximum size of a row?4 7534
Explain Active/Active and Active/Passive cluster configurations?1 3007
What is lock escalation?1 5292
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?9 12688
Explain the storage models of OLAP?1 5360
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1124
What are constraints? Explain different types of constraints?26 116676
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?2 7782
what operator performs pattern matching?2 8511
How do you Implement SSIS Packages in your Project?
what is difference between view and Dip.
what exactly sql injuction.how to overcome.....
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what is isolation level at dead lock?
how can you attach more than 20 ldf files in sql server
what is checksum in sql server.........???
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
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 use DTS package in 2000,2005,2008 in sql server
last function used in MS Access to convert sql what function will use in sql
how to do partition in sqlserver
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
how to overcome kernel isssues