|
|
-
|
|
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...
|
|
-
|
|
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....
|
|
-
|
|
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 ...
|
|
-
|
|
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 ...
|
|
-
|
|
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...
|
|
-
|
|
The new in-line editing menu, which appears when you right-click a spot in your document, gives you the option to paste your clipboard text with the formatting intact, paste it as plain text, or to merge the formatting.
Navigation pane allows you a qui...
|
|
-
|
|
We can share the Microsoft Word 2010 document to multiple users through Skydrive or Sharepoint or local file system etc. Users can edit the same document simultaneously also....
|
|
-
|
|
Visual Studio 2010 also now includes a built-in “Extension Manager” within the IDE that makes it much easier for developers to find, download, and enable extensions online.
Go to Tools -> Extension Manager
Which shows already installed extensions. Yo...
|
|
-
|
|
Code snippet is a one of the cool features that is given in Visual Studio IDE. If you know the chunks of the code that you need to type over and over again throughout the coding, then this code snippets feature will help you . For example your exception...
|
|
-
|
|
Visual Studio 2010 provides capability to select rectangular region of code. Just press down "Alt" key and select the rectangular region you want to copy.
![alt text][1]
[1]: http://beyondrelational.com/images/images.ashx?id=24edc9f69d874364a917173...
|
|