hopefully following will help

http://pramodsingla.wordpress.com/category/interview-questions-2/

Koen Verbeeck (9/15/2013)

---

The question itself is great, however the explanation is lacking.

There's no reference, and the explanation itself is incorrect.

There's no variable that is "reset".

The DECLARE is not ignored, it...

A view with clustered index is indexed view.

There are lot of limitations/conditions apply on creating the index view.see BOL for detail

It is very shocking and saddening to me. 🙁

I was also planning to go for MCM/MCA but now I am bit suspicious for going even for MCSE.

in my opinion also,Microsoft...

nasty

alex.d.garland (8/30/2013)

---

"The SQL Server Database Engine recognizes any unique string that is part of the configuration name."

Wow, I did not know that. Good question, I always like it when...

Following steps might be helpful:

1.What I think is put all the task that you want to rollback in one transaction using required followed by supported

2. bit put the transaction option...

Windows

at least avoid use of NOT IN rather use NOT Exists

+1

For such scenarios compbination of Log shipping and FTP will work.

Thanks Koen and Duncan

As per my understanding yes

A control flow task is not a task..

Control flow tasks is not a task or container so not an object.

It's just a name give to collection of tasks and container..

and writer is asking for SSIS objects..

Any thought on this guys..