|
|
-
|
|
By using Multi-server query, we can execute a query against multiple servers at a time. In Central Management server, register the available servers. Then executing the query against the group will execute in all the servers registered against the group...
|
|
-
|
|
SQL Server 2008 provides a very useful feature for DBA, to monitor the Database resources such as I/O,CPU,Processed running,Resource Waits etc.
In SSMS, in standard toolbar, click on Activity Monitor icon, which opens Activity Monitor for you.
![alt t...
|
|
-
|
|
Until SQL Server 2005, If we write complex queries/stored procedures, Its very difficult to debug these stored procedures. Developers used to depends on "print" statements. SQL Server 2008 introduced debugging feature, using which we can analyze complex...
|
|
-
|
|
In SQL Server 2005, while writing query, we need to remember object names. If we didn't remember object name, we need to go to object explorer and need to find the object names. With SQL Server 2008, we can use intellisense, which greatly helps while wr...
|
|
-
|
|
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...
|
|
-
|
|
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...
|
|
-
|
|
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 ...
|
|