What are pages and extents? : SQL Server Architecture
No Answer is Posted For this Question
Be the First to Post Answer
What stored by the model?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
What is the difference between having and where clause?
Normalization and denormalization
Give a example to search fr a string in all stored procedure in sql server.
How to modify existing triggers using "alter trigger"?
What part does database design plays a role in performance of an sql server-based application?
Tell me about the approaches which you used to counter the DI problems.
Do you know sql server 2008 backup compression?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to check parameter value in stored procedure sql server?
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,
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)