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 |
Explain what is raid and what are different types of raid levels?
What is NOT NULL Constraint in sql server 2012?
What is transaction server isolation?
Explain about local stored procedure?
What is SCOPE_IDENTITY() in sql
How is a full-text index updated?
Explain about Joins?
How you can get a list of all the table constraints in a database? : Sql server administration
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Explain left outer join and right outer join?
How to enforce security in sql server? : sql server security
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
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)