What is New - SQL Server 2008

Sign in | Join

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	What is New

Upload Image

Close it

Select File

Explore the new features and enhancements added to SQL Server 2008

Moderators


	Like

Invite Friends

Top Categories · View All

T-SQL Enhancements	7
Database Engine	1
Activity Monitor	1
Debugging Enhancements	1
Intellisense	1

Browse by Tags · View All

MultiServer Query	1
Activity Monitor	1
Debugging	1
Filtered Indexes	1
Row Value Constructor	1
Values	1
Grouping Sets	1
Table Valued Parameters	1
TVP	1
Merge	1
Sparse Columns	1
HierarchyID	1

Browse by Release · View All

All

11

SQL Server 2008

Features · Categories · Submit a feature · Most Liked · Most Discussed · Info · News · Fans (13) · Preferences

1
Liked

SQL Server 2008 - Filtered Indexes will allows you to create index on subset of rows

In general indexes contains all the table rows. However, In few scenarios, in multiple queries we might be using same condition and operates on same set of rows. Consider the Sales data, often we will interact with data of current year only. In that cas...

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

1
Liked

SQL Server 2008 - Row Values Constructor allows you to create multiple rows at once

Row value constructor is a ANSI SQL Feature, which is introduced in Microsoft SQL Server 2008. Currently SQL Server will support this feature in the form of an values clause. To construct a table by using set of row value expressions by using single DML...

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

2
Liked

SQL Server 2008 - GROUPING SETS allows you to present summary of rows across various columns

Grouping Sets will be very much useful in basic reports that include aggregates, gives you more flexibility and performance . These are extension to CUBE and ROLLUP which exists in previous versions before 2008. **CUBE:** Generates result set that con...

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

1
Liked

SQL Server 2008 - Table valued parameter allows to pass multiple rows at a time to stored procedure

Table Valued Parameters are the new parameter types in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. Before TVPs, Developers used to use delimited strings or series of insert statements etc or bulkcopy method....

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

1
Liked

SQL Server 2008 - Merge Statement allows you to combine Insert and Update statements using same query

Used to synchronize 2 tables by inserting or updating or deleting one table based on differences found in the other table. We can perform multiple data manipulation language (DML) operations in a single statement by using the MERGE statement. This can ...

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

2
Liked

SQL Server 2008 - Sparse columns allows you to save space for columns which have more null values

Sparse columns will have Optimized storage format for NULL values. When we declare a column as SPARSE and if we insert NULL into that column, it will not take any space. These will be useful when there are more number of possible attributes and users ...

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

1
Liked

SQL Server 2008 - HierarchyID will allows you to efficiently store and query hierarchial data

Scenarios like organization structure, file system etc will have hierarchical relationship. Before SQL 2008, users solved these scenarios by using some complex joins,recursive CTEs etc. SQL 2008 provides a new datatype called HierarchyId , which can be...

Ramireddy Posted on Mar 3 2012 12:00AM
Profile · Facebook · Twitter

Copyright © Rivera Informatic Private Ltd

Contact us Privacy Policy Terms of use Report Abuse Advertising

[ZULU1097]