What are the features of SQL Server 2008?
What are the features of SQL Server 2008?
New Features in SQL Server 2008
- Ability to Hot-Add CPUs.
- FileStream Data.
- Data Compression.
- Log Stream Compression.
- Transparent Failover.
- Language-Integrated Query.
- Enhanced Office Integration.
What are T-SQL functions?
T-SQL Functions Aggregate functions, which operate on a collection of values, but return one summary value. Ranking functions, which return a ranking value for every row within a partition. Rowset functions, which return an object that can be used as a table reference in SQL statements.
What are the advantages of T-SQL?
Advantages of using T-SQL It is built with aided logging and transaction knowledge in the environment and thus promoting reliability. Efficiency: It minimizes traffic over the server. the jobs being run with data are processed with minimal overhead when being transferred within the application.
What is difference between SQL and T-SQL?
The obvious difference is in what they are designed for: SQL is a query language used for manipulating data stored in a database. T-SQL is also a query language, but it’s an extension of SQL that is primarily used in Microsoft SQL Server databases and software.
What is T-SQL in stored procedure?
Stored procedures are a collection of Transact-SQL statements stored within the database. They are used to encapsulate oft-used queries, such as conditional statements, loops, and other powerful programming features. Stored procedures are similar to functions in high-level programming languages.
What are the disadvantages of using T-SQL?
Some of the disadvantages of the T-SQL are mentioned below:
- Costly in nature – The T-SQL language is costly in nature that increases the operational cost and acts as extra overhead for the database user.
- Limited access – The T-SQL language provides limited control to the database user.
What are the operations we can perform using SQL or T-SQL?
Structured Query language (SQL) : Data definition language used for create, drop, alter, truncate in database. Data manipulation language used for insert, update, delete data in database. Data control language used for Revoke and grant data. Transaction control language used for commit, rollback data.
Why is it called T-SQL?
It stands for Structured Query language and it is developed by IDM. It stands for Transact Structured Query language and it is developed by Microsoft. Structured Query language is used for look over data using queries. Transact Structured Query language used for creating application and add business logic.
Is T-SQL difficult?
TSQL is easy. WAY TOO EASY. Developers look at it, learn the syntax and, as far as they’re concerned, they’re done.
Is T-SQL procedural?
T-SQL is a procedural extension used by SQL Server.
What is difference between PL SQL and T-SQL?
PL SQL basically stands for “Procedural Language extensions to SQL.” This is the extension of Structured Query Language (SQL) that is used in Oracle….Difference Between T-SQL and PL-SQL.
|It is easy and simple to understand.||PL-SQL is complex to understand.|
What’s new in SQL Server 2008?
New in SQL Server 2008 Enterprise and Developer edition is database Backup Compression. With Backup Compression, the database backups are compressed as the backup file is being written. By using compressed backups, you can save valuable disks space if a disk device is the target for your backups.
What is SQL Server 2008 R2 SP2 Express?
Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 R2 SP2 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008 R2 SP2.
What is the difference between SQL Server 2008 and SSIs?
Sparse columns – SQL Server 2008 has more efficient storage for ‘wide’ tables with many columns that repeat and do not contain data Persistent Lookups in SSIS – There is no longer a need for re-querying for lookup operators and cache lookups in multiple ways with the ability to persist lookups to disk
What are the geospatial data types in SQL Server 2008?
With SQL Server 2008 two geospatial data types where introduced and a number of geographic functions. The two new data types are geometry and geography. The geometry data type is a planer data type that represents the Euclidean coordinate system, or more commonly called the flat earth model.