Daily Tips- Tip #80 - SQL Performance Tuning

Sunday, March 20, 2011

sp_help is the stored procedure which gives table details.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #79 - SQL Performance Tuning

sp_helpconstraint is the stored procedure to view constraints.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Where are the system stored procedures stored in SQL Server ?

In the Master database


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the different types of System Testing ?

Saturday, March 19, 2011

1. Facility Testing
2. Volume Testing
3. Stress Testing
4. Usability Testing
5. Security Testing
6. Performance Testing
7. Storage Testing
8. Configuration Testing
9. Installability Testing
10. Reliability Testing
11. Recovery Testing
12. Serviceability Testing
13. Documentation Testing
14. Procedure Testing


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is System Testing ?

The process of comparing the software to its original objectives.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Function Testing ?

It is process of finding discrepencies between the program and requirement.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the other name of Unit Testing ?

Module Testing.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Blog Widget by LinkWithin