What is the expansion of BCP ?

Saturday, March 19, 2011

Bulk Copy Program.


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

What is a table called if it has no Clustered index and Non-Clustered index ?

Heap.


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

what is Log Shipping ?

In SQL Server, it is a process of automating the back up of a database and transaction log files on a production server.


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

What is the maximum level of recursion allowed in SQL Server ?

32.


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

Is recursion allowed in Stored Procedures in SQL Server ?

Yes.


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

What is SQL Profiler ?

Its an tool which is used to montior activites in SQL Server and also helps in increasing performance.


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

What are the different types of Sub-Query ?

1. Single-row
2. Multiple-row
3. Multiple-column


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