SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities, such as which SQL Scripts are running, failed jobs etc.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Referential Integrity defines that the Primary key of one table should be match to the foreign key of other tables .
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
There are numerous good possibilities:
Loyalty, Energy, Positive
attitude, Leadership, Team player, Expertise, Initiative, Patience,
Hard work, Creativity, Problem solver.
Create Date
:
Thursday, September 18, 2008
Tags
:
interview,
general,
business,
network,
hr,
human resource,
SQL,
integer,
character,
management,
Flexibility,
organization,
efficiency,
general interview,
leadership,
manager,
human resources,
Microsoft,
accounting,
work attitude,
supervision,
PUZZLE
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
It depends what the logic is. If you need to do complex manipulation of data already in the database, it is probably better than trying to run sql queries and fetch the data into the middle tie and perform the manipulation in the middle tie, then send the large amount of data back to the database using sql insert or update. On the other hand, you can do to something simple using sql, but you have to write quite a lot of code in stored procedure, why do that.
For stored procedure vs. dynamic sql queries, assuming you are not talking about case where you can call stored procedure within a sql query or you can use dynamic sql inside a stored procedure, dynamic query has a downside (at least in Oracle db), that it has to be compiled if the exact sql string is not used recently (seconds I think) by any session, which could takes some time, and use some system resource. On the other hand, logic in stored procedure is not necessary automatically better.
I think you have to compare approaches based on how easy it is to write the code to do what you want, how easy it is for others to understand and maintain the code, and what is the performance cost in a target database, etc.
Create Date
:
Monday, May 05, 2008
Click here
to improve the Interview Question, Answer and other fields.