What will you do If the low Performance occurs?
Answers were Sorted based on User's Feedback
Answer / bhanu pratap singh
We will create "full text search" in our database queries,
by doing it we can increase the speed of our queries.
| Is This Answer Correct ? | 0 Yes | 1 No |
List out the different types of locks available in sql server?
Mention the different types of triggers?
What are different types of raid levels?
What is a data source file?
Why do we need different type of parameter?
Can we use where clause with group by?
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is better - 2nd Normal form or 3rd normal form? Why?
How many types of triggers in sql server?
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
does physical index sort data
Oracle (3253)
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)