nice question to learn new things....

Question is correct...But answer is wrong...:) 

Partial backup is nothing but the differential backup. If we need to restore differential backup, initially restore FULL backup then differential backup.
Full backup --> every day backup
Differential backup...

nice question

very easy one

Thanks Gianluca Sartori...

Thanks Gianluca Sartori... How can i find out the issue by using the above query? any column looks strange when that error raise?

nice question...

nice question...

Thanks for the question...:-D

nice question...

nice question... count * should not consider the null values that's why we got an error while using count(distinct *), But when we use count(distinct myid) it consider null also...

if I run the below query then it gives result as 4. So when I mention column name inside of count function, it omitted the null values in that column....

Nice question thanks....

Now only i am getting to know Thanksgiving day

This is because LEN function does not work for text, ntext and image data types.

new things added in my mind memory...:-D