ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO
ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO
ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO
ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO
Useful resources, Creating Compressed Tables and Indexes
DECLARE @p AS int
What Will be the output of the above code?
No output is displayed.
A list of first 10 employees is displayed from the Person database.
An incorrect syntax error is displayed.
None of the above.
Policy-Based Management enables the efficient management of multiple SQL Server instances from a single location. It is easy to create policies that control security, database options, object naming conventions, and other settings at a highly granular level. Such policies can evaluate servers for compliance with a set of predefined conditions and help prevent undesirable. Useful resources, Why SQL Server May Be More Suitable For You
Useful resources, Create Index (Transact-SQL)
CREATE INDEX To
Transact-SQL can be used to SELECT, INSERT, UPDATE, DELETE FILESTREAM data.
The size of the stored data is limited to 2 GB.
You cannot take backup of a database without the FILESTREAM data.
FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.
The FILESTREAM data can be accessed and manipulated in two ways – either with the standard Transact-SQL programming model, or via the Win32 streaming APIs. Both mechanisms are fully transaction-aware and support most DML operations including insert, update, delete, and select.BLOBs smaller than 256 kilobytes (KB) are better stored inside a database, and BLOBs larger than 1 megabyte (MB) are best stored outside the database. For those sized between 256 KB and 1 MB, the more efficient storage solution depends on the read vs. write ratio of the data, and the rate of “overwrite”. Storing BLOB data solely within the database (e.g., using the varbinary (max) data type) is limited to 2 gigabytes (GB) per BLOB. Useful resources, FILESTREAM Storage in SQL Server 2008
Tiny Encryption Algorithm
Advanced Encryption Standard(AES)
Triple Data Encryption Standard(3DES)
Useful resources, Transparent Data Encryption (TDE)
Useful resources,rename a SQL Server database
IGNORE_DUP_KEY cannot be set to ON for XML indexes.
IGNORE_DUP_KEY can be set to ON for spatial indexes.
IGNORE_DUP_KEY can be set to ON for filtered indexes.
IGNORE_DUP_KEY can be set to ON for XML indexes.
IGNORE_DUP_KEY cannot be set to ON for indexes created on a view.
IGNORE_DUP_KEY cannot be set to ON for indexes created on a view, non-unique indexes, XML indexes, spatial indexes, and filtered indexes. Useful resources, Create Index
0 and 66020
1 and 65530
0 and 65534
1 and 65535
The login time-out must be a number between 0 and 65534. Useful resources, ssbdiagnose Utility