what is performance tunning in sql server ? explain.
Answer / karthikeyathirughanashamphanth
Step-1:Capturing Performance metrices.
Step-2:Find the problem Queries with Profiler.
Step-3:Define Mitigation for the Problem Queries.
| Is This Answer Correct ? | 1 Yes | 1 No |
How to create a view with data from multiple tables?
Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).
How can I check if a view exists in a sql server database?
What is partitioned view?
What is truncate table?
How do I start sql server agent automatically?
What is the difference between commit and rollback?
What are the ways available in sql server to execute sql statements?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is GUID in sql server?
What are page splits?
explain different types of joins? : Sql server database administration
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)