| (1) Reporting services:-In SQL Server Reporting | | | | with or without parameters .When we use SQL |
| Services increase there benefit to customers. These | | | | Server as a Web Service that can for HTTP SOAP |
| include centralized report storage and management, | | | | requests requires must create an HTTP endpoint and |
| control over how reports are processed or | | | | defining the methods that the endpoint exposes. When |
| administered, and also have ability to fastest changing | | | | we create HTTP endpoint, that endpoint must be |
| reports formats (HTML, Excel, PDF, etc.). This entire | | | | created with a unique URL that we uses to listen for |
| capabilities make reporting Services is valuable. So | | | | incoming HTTP requests. |
| Web-based reporting has ability to make up-to-date | | | | (4) Database Mirroring: - Database mirroring provides |
| information available to a distributed group of users. | | | | solution to provide high availability at the database level |
| Reporting Services provides a impressive way to find | | | | where all things depends upon the database. In Sql |
| and view reports, the Reporting Services interface | | | | Server we can maintained synchronized copies of a |
| may not be the most appropriate one for all report | | | | database on two separate servers allows switching |
| users. | | | | between them. And its plays its role on failure of |
| (2) Partitioned Tables and Indexes:-Sql Server 2005 | | | | primary server. |
| has ability to partition tables and indexes have always | | | | (5) CLR Integration: - Microsoft SQL Server 2005 has |
| been a design to improve performance and | | | | adopt the database programming model hosting by the |
| manageability in larger databases. Microsoft SQL | | | | Microsoft .NET Framework 2.0 Common Language |
| Server 2005 has many new features that simplify the | | | | Runtime (CLR). .Net CLR hosted inside SQL Server to |
| design of using this feature. | | | | improve performance, security and reliability. This helps |
| (3) Xml Web services: - SQL Server 2005 provides a | | | | developers to write procedures, triggers, and functions |
| standard method for getting the database engine by | | | | in any of the CLR languages. |
| using SOAP via HTTP. With the help of this methods, | | | | To know more about Sql Server Interview Questions |
| we can send SOAP/HTTP requests to SQL Server | | | | visit dotnetquestion.info and learn all interview questions |
| to execute stored procedures, extended stored | | | | related to sql server which is very helpful in interviews |
| procedures, T-SQL batch statements and | | | | for you. |
| scalar-valued user-defined functions which can have | | | | |