Hi,

I think it will update the file even if it exists.

I create a job with step than contains inser into t1 values(1) .

the file in the output already exists, and...

Hi,

Count does not ignore NULLs values if we use it as follow : COUNT(*), but if we write COUNT(ColumnName) in this case Count ignores Nulls Values.

I think GROUPING does not...

Hi,

I think the non clustred index it used in all the five queries.

I have tested the example on SQL Server 2008 R2 and I have display the execution plan, that...

Hello,

I think 1 and are the same ?

Thanks

Hi Everybody,

I think there is also SOAP type.

Thanks

Hi,

??????????

How can I choose an answer and there is statement that insert into D4 table. !!!!!!!!!!!!!!!!!!!!!!!!!!

Thanks

Hi,

It was a good question.

Thenks.

Hi,

I got ot right, but should replace "SQLAgentAgentRole" with "SQLAgentReaderRole"

Thanks.

Hello Everybody,

My answer was : 1, 2, 3, 5.

I think it is the correct answer acordind to http://msdn.microsoft.com/en-us/library/ms190736.aspx

Hash recursion and hash bailout cause reduced performance in your server....

Hello,

I think there is something wrong, The correct Answer is A and D.

!

.

Hello,

The second select return a count = 1 !!!!!

thanks

Thanks for the question.

🙂

Hello,

My answer was "SQL Server cannot start if the master database is unavailable"

I think that is correct, isn't it?

see this link please

http://msdn.microsoft.com/en-us/library/ms187837.aspx

Thanks for all.

Hello,

ANSI_PADDING is also a correct answer !!!!!

Hello,

The question is missleading !!!

The question is "How many rows returned by executing all of the following?" , and when I executed the script the result was "(5 row(s) affected)",...