It is a statement which gives a way to perform multiple DML operations.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is a MERGE Statement ?
Tuesday, March 22, 2011
It is a statement which gives a way to perform multiple DML operations.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Filtered Index ?
A Filtered Index is an optimized form of non clustered index. A Filtered Index allows us to create a filter to index a subset of rows within a table.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are Sparse columns ?
They are ordinary columns optimized for storage of null values, thereby reducing storage physical space.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Where are Usernames and Passwords stored in SQL Server ?
Sunday, March 20, 2011
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 ?
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
Subscribe to:
Posts (Atom)
