Always worth your time, Brent Ozar’s most recent Office Hours covers a couple of scenarios concerning my favorite sacred cow – database normalization.
Does normalization have a big performance impact?
Do foreign keys help with performance?
Normalize until it hurts, de-normalize until it works!
begin transaction
select * into dbo.TranSACTIOnAlLoGwilLNoTgrOWAlldbsAreINsImPLERECOveRy from dbo.ActivityLogs
while 1 = 1
begin
insert into dbo.TranSACTIOnAlLoGwilLNoTgrOWAlldbsAreINsImPLERECOveRy
select * from dbo.ActivityLogs
endTime to hit F5 and go to lunch…
When will I ever learn?
INSERT EXEC statement cannot be nested
Until it is, here is a great overview on How to Share Data between Stored Procedures by Erland Sommarskog.
You must be logged in to post a comment.