Where are Usernames and Passwords stored in SQL Server ?

In System Catalog Views sys.server_principals and sys.sql_logins.

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

How will you change the server level settings in SQL Server ?

Using sp_configure

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

What are the types of Cursors in SQL Server ?

1. Static
2. Keyset-driven
3. Dynamic
4. Fast-Forward only

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

How will you get the last error no in SQL Server ?

@@ERROR.

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

How will you get GUID in SQL Server ?

NewID().

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

Daily Tips- Tip #85 - SQL Performance Tuning

sp_depends is the stored procedure is used to know which table use a rule or default.

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

Daily Tips- Tip #84 - SQL Performance Tuning

sp_unbindrule is the stored procedure which is used to unbind rule from table.

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

Daily Tips- Tip #83 - SQL Performance Tuning

sp_bindrule is the stored procedure which is used to bind rule to table.

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

Daily Tips- Tip #82 - SQL Performance Tuning

sp_helptext is the stored procedure which gives details about rules and defaults.

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

Daily Tips- Tip #81 - SQL Performance Tuning

sp_helpdb is the stored procedure which gives details about database.

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

Daily Tips- Tip #80 - SQL Performance Tuning

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