A good ( and interesting ) question that I have been able to reply only because I remembered a SQL Server Days session which was about the query hints and...

Hi Hany ,

Thank you for your comment.

My own full comment about the older method should be ended by : why not if they can be applied without doing the...

Interesting question but maybe too easy with some minutes to spend :

- Plenty of RAM : too easy to be the good choice

- to use OPTIMIZE : never seen this...

Please , could you have a look at this link ?

I am far to be a specialist of this kind of problem , but it is the 1st post I...

The question was : Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?

I have not been unable to understand what...

Easy question as I remembered that I faced this question on the T-SQL forum (MSDN) . I moved it to the correct forum with the link corresponding to the lack...

Thanks for this good question that I was able to answer only because I faced the same question 6 years ago during an interview and I was wrong.

During this interview...

+1

You could find a possible explanation in this link

As I am registered for CodeProject , I have already read this article and I got easily the point.

I have also heard...

+1

But I think that the question would have included checkbox and not radiobutton ( which are exclusive )

Why I am getting this ?

PS SQLSERVER:\SQL\USER-PC\EXPRESS_ADV_2014>

PS SQLSERVER:\SQL\USER-PC\EXPRESS_ADV_2014> (Get-Host).Version

Major Minor Build Revision

----- ----- ----- --------

2 0 ...

I found the good choice because of an older question about the same topic for which I answered too quickly ==> failure for me

Really easy question ( one point is enough )

14 is the foreseen version for the next version ( I have read on the MSDN forum that the 13 version has...

Thanks for this easy question.

FileStream is the only possibility to "rub off" the limitation of 10 GB for the storage of data in a SQL Server Express Edition.

I got at...

Good question but an easy one.

I have appreciated because it is an example of "bad code" ( too difficult to understand ) that I have met too many times even...