-- sprawdz alokacje danych; wykorzystuje sp_AllocationMetadata (c) Paul Randall
-- patrz projekt "Scripts"
USE PLSSUG_DEMO2;
GO

EXEC sp_AllocationMetadata N'help.filesFS'

/*
-- zamiast 1, 169, wpisz FirstPage z wyniku sp_AllocationMetadata
DBCC TRACEON (3604);
DBCC PAGE (Baza, 1, 169, 3);
GO
*/

DBCC TRACEON (3604);
DBCC PAGE (BOL2, 1, 302, 3);
GO

/* wyszukaj cos na ksztalt
content = [Filestream column] Slot 1 Column 4 Offset 0x62 Length 48

Slot 1 Column 1 Offset 0x4 Length 4 Length (physical) 4

fileId = 2                          

Slot 1 Column 2 Offset 0x8 Length 16 Length (physical) 16

fileGUID = 705917da-1ff4-e411-80c1-080027eeb814                          

Slot 1 Column 3 Offset 0x21 Length 64 Length (physical) 64

mp3FilePath = C:\Darksiders II Official Soundtrack\Disc 1\02 Into Eternity.mp3

mp3File = [Filestream column] Slot 1 Column 4 Offset 0x61 Length 48

ColType = 3                         Version = 1                         FileId = 65537
UpdateSeq = 1                       CreateLSN = 0000001f:00000173:0003 (31:371:3)
TxFMiniVer = 0                      XdesId = (0:768)    
 
*/