what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
What is normalization 1nf 2nf 3nf?
What are the types of stored procedures in an sql server?
What is the difference between coalesce() & isnull()?
What is dbcc updateusage?
select empid empname from employee What is the result for the about query?
How to find the latest updated value in a table without sending any parameters to that query
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain various data region available in ssrs with their use?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
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)