How do you fine the performance tunning?
Answer Posted / shivaraj
it is depends on
Data base design.
Hardware Sizing,
Application T- SQL codes- Indexes,Stored
Procedues,constraints
no of clients
no users
Type of data and Quantity base storage capacity on daily
basis
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
 Explain what is sql override for a source taLle in a mapping?
Explain primary key and foreign key constraints?
How to enable tcp/ip protocol on a sql server?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
List some major differences between triggers and stored procedures?
What is report rendering ?
How to generate random numbers with the rand() function in ms sql server?
How much is a sql server license?
Define cross join in sql server joins?
What is difference between cte and view?
Can binary strings be converted into numeric or float data types?
Describe triggers features and limitations?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What are clustered and non-clustered index?