Other News

Editorials

Create a HASH Value in SQL Server

SQL Server has two built in functions for generating a hash value, CHECKSUM and HASHBYTES. CHECKSUM is not as sophisticated as HASHBYTES resulting in a higher probability of a duplicate hash for different input values. Still, it provides a lot of power, and is used for the HASH JOIN technique built into SQL Server itself. One thing that is really […]

Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 Database Engine Stored Procedures

Undocumented SQL Server 2012 Database Engine Stored Procedures SQL Server 2012 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_objectfilegroup sp_oledb_defdb sp_oledb_deflang sp_oledb_language sp_who2 sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel database engine stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname =...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here