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: 5

2 comments:

  1. Need some description before technichal query.

    ReplyDelete
  2. Need some description before technichal query.

    ReplyDelete

All Rights Reserved by Technology from Developers Eye © 2014 - 2015
Powered By Blogger, Designed by Aadics
Disclaimers:: The information provided within this blogsite is for general informational purposes only. While we try to keep the information up-to-date and correct, there are no representations or warranties, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the information, products, services, or related graphics contained in this blogsite for any purpose.The author does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause.

Contact Form

Name

Email *

Message *

Powered by Blogger.