|
|
-
|
|
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work* when there is LOB data involved.
When we recreate indexes on a table containing LOB data, the LOB data pages are not moved to desti...
|
|
-
|
|
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server Team for more info.
For a complete list of issues that have been fixed in SP3, refer KB 2546951:
List of issues that are fixed by SQL Server 20...
|
|
-
|
|
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two requirements to allow running a procedure created in [master] database in user database context:
1. The stored procedure name must begin wit...
|
|
-
|
|
A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using a dump device for backups is it reduces the change required to backup code. For example, if you are backing up to a Network location. If yo...
|
|
-
|
|
CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog post to get highlights of what has been updated.
Download Links:
SQL Server 2008 SP3 CTP: http://go.microsoft.com/fwlink/?LinkId=226850
SQL Server 2008 SP3 Express CTP: http://go.micros......
|
|
-
|
|
sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns summary information for objects of all types in the database. These includes all user tables, system tables, stored procedures, functions, exten......
|
|
-
|
|
You can browse available SQL Instances on network by choosing "" from Server Name drop-down list in "Connect to Server" dialog box in Management Studio:
As you can see from the screen shot, all of my instances are visible on the network. If I want to hide this information fro......
|
|
-
|
|
sys.dm_db_persisted_sku_features
lists all features which are utilized by the database. Features specific to Enterprise/Developer
edition are:
- Compression,
- Partitioning,
- TDE and CDC
These features are available only on Enterpr......
|
|
-
|
|
PERCENT_RANK() returns the position of a row within the result set. In contrast
to RANK() function, PERCENT_RANK() ranks rows between 0 and 1, both inclusive.
Computation formula used by PERCENT_RANK():
(RANK() – 1) / (Number of Rows – 1)
......
|
|
-
|
|
CUME_DIST() calculates relative position of a value relative to a group of
values. The value returned by CUME_DIST() is > 0 and <= 1,
which represents percentage of number of rows with value less than (for ascending
order) or equal to current row.</p>
......
|
|