Shadow or Ghost in DB SQL
create database ShadowDB
GO
Use ShadowDB
create table DemoTable(id int,name char(100))
create clustered index IDx_DemoTable on DemoTable(id)
declare @initialVar int =0
while @initialVar<100
begin
insert into DemoTable values(@initialVar,'Name'+cast(@initialVar as char(30)))
set @initialVar=@initialVar+1
end
select * from DemoTable
dbcc ind('ShadowDB','DemoTable',-1)
dbcc traceon(3604)
dbcc page('Shadowdb',1,298,1)
--delete a record
begin tran
delete from DemoTable where id=72
dbcc page('Shadowdb',1,298,1)
rollback
Shadow or Ghost in DB SQL
Reviewed by Rupesh
on
06:28
Rating:
Need some description before technichal query.
ReplyDeleteNeed some description before technichal query.
ReplyDelete