What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
No Answer is Posted For this Question
Be the First to Post Answer
How to view the error log for any specific instance? : sql server database administration
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
How many null values we can have in a unique key field in sql server?
Explain what is scheduled job and how to create it?
How can you tell if a database object is invalid?
Explain about thread and memory management process of SQL?
Do you know what are acid properties of transaction?
How can i change the column name.
13 Answers HCL, Yardi Software,
What is SQL Server?
how would you troubleshoot blocking? : Sql server database administration
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
What is normalization process?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)