SQL Server – DBCC PAGE and DBCC IND

DBCC IND – used to know the page details of tables & indexes. syntax: DBCC IND ( {dbname}, {table_name},{index_id} ) Description of columns displayed from DBCC IND PageFID File ID of Page PagePID Page ID IAMFID,IAMPID File ID&Page ID -> IAM mapping ObjectID  object ID(Table) IndexID Clustered index (IndexID = 1),Non clustered index (IndexID = 2) PartitionNumber  Number of…

Details

Sqlserver – COALESCE

COALESCE Returns the first nonnull expression among its arguments. Syntax COALESCE ( expression [ ,…n ] ) Limitations of COALESCE():In COALESCE() while passing arguments,it does not support arguments with different data types in few cases.For example: SELECT COALESCE(‘A’,GETDATE())GO ———————–Msg 241, Level 16, State 1, Line 1Conversion failed when converting date and/or time from character string. But…

Details