What is Microsoft SQL Server 2008 used for?

SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications.

What is the difference between SQL Server 2008 and 2008r2?

SQL Server 2008 R2 has more visual features than the SQL Server 2008. As well as SQL Server 2008 R2 supports for mainly data analysis, data presenting and deal with databases which is located in several physical locations.

What are the new features in SQL Server 2008?

New Features in SQL Server 2008

  1. Ability to Hot-Add CPUs.
  2. FileStream Data.
  3. Data Compression.
  4. Log Stream Compression.
  5. Transparent Failover.
  6. Language-Integrated Query.
  7. Enhanced Office Integration.

What is the difference between SQL and SQL Server?

Differences between SQL and SQL Server. Type: SQL is a query language. It is used to write queries to retrieve or manipulate the relational database data. On the other hand, SQL Server is proprietary software or an RDBMS tool that executes the SQL statements.

What is trigger in mssql?

A trigger is a special type of stored procedure that automatically runs when an event occurs in the database server. DML triggers run when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.

What is SSIS called now?

First released with Microsoft SQL Server 2005, SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0….SQL Server Integration Services.

Developer(s) Microsoft
Operating system Microsoft Windows
Type ETL Tools
License Proprietary commercial software

What are major differences between SQL Server 2005 and SQL Server 2008 version?

Difference between Sql server 2005 and 2008

Sr No SQL Server 2005 SQL Server 2008
5 SSIS is started using. SSIS avails in this version.
6 CMS is not available. Central Management Server(CMS) is Introduced.
7 PBM is not available Policy based management(PBM) server is Introduced.

What are the new features in SQL Server 2012?

Top 10 Exciting New Features of SQL Server 2012

  • Column Store Indexes.
  • Business Intelligence.
  • Sequence Objects.
  • Windows Server Core Support.
  • Pagination.
  • Error Handling.
  • New T-SQL Functions.
  • Enhanced Execute Keyword with WITH RESULT SETS.