Good Question !!!!!!.

Thanks Steve for the easy one !!!!

create table Intpk (intslno int identity (1,1), name varchar(100))

When records are...

What mechanism you want to follow. Is that a SSIS package or CSV upload or using linked server.

The posert should have limited to only two options.

even though we knew the answer very difficult to spot on from the options.

Seems like a test for the...

Good Question.

This is a very open ended question.

Monitoring the db size also comes with capacity planning, archiving, storing your transaction log to different drive, transaction log backup.

Just monitoring alone...

Create a clustered index on the date column. So the data pages are arranged on the order you want. . But there is no guarantee to see the order of...

Nice Question. I was distracted by the factor of go will make it as one transaction.

Nice 🙂

+1. Thanks for the easy question.

Any one can explain why option two has to fail? Thank you.

Damn it I misunderstood the question as what are the valid ports.

Good question. Keep coming more of this stuff.

--- Babu

Never seen this. Guessed this one. +1.