|
|
-
|
|
SQL Server 2012 added a new UI dialog that allows to add/edit/manage the start up parameters. This has become much easier than the previous versions.
![SQL Server 2012 - Service Property Page - Startup Parameters][1]
[1]: http://img1.beyondrelatio...
|
|
-
|
|
PERCENT_RANK() function will returns the percentage value of rank of the element among its group.
PERCENT_RANK() function value will be
1. For first element in its group, it will be 0.
2. For last element in its group, it will be 1.
3. For remaining...
|
|
-
|
|
`LAST_VALUE()` function returns the last value among the set of ordered values according to specified ordered & partitioned criteria. One difference between first_value and last_value is, for a group of rows, `FIRST_VALUE()` will return same value, wher...
|
|
-
|
|
Visual Studio 2010 provides various Code Refactoring options. Few of these are
1. **ReName:** Often while developing, we would like to rename the method names/field names etc. When it is named, in all places it has to be changed. Visual Studio provides...
|
|
-
|
|
In SQL Server 2012, one of the addition to OVER clause is, ROWS/RANGE Clause. In general, when we apply aggregate functions in over clause, it will apply to all rows in that group/partition. Suppose, if we wants to restrict the number of rows, it involv...
|
|
-
|
|
SQL Server 2012 Denali discontinued support for the system stored procedure `sp_dboption`. `ALTER DATABASE` is the suggested alternative....
|
|
-
|
|
The new pagination support allows you to write queries that can return rows from specific position of the result set. For example: the following query returns rows 20 to 30 from the result set.
SELECT
*
FROM Customers
ORDER BY CustID ...
|
|
-
|
|
One traditional approach to improve performance is scale-up by increasing hard-ware etc. Scale-up approach has certain limit. New trend towards improving performance is scale-out. SQL Azure supports scale-out by using federations. This will solve the pr...
|
|
-
|
|
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...
|
|
-
|
|
VS 2010 now supports importing/exporting breakpoints to XML files – which you can then pass off to another developer, attach to a bug report, or simply re-load later.
1. Go to Debug -> Windows -> Breakpoints window, which shows all breakpoints
2. You c...
|
|