In the explanation it was mentioned the following: "The DEK is inside the backup", to be honest I am not an expert of (Transparent Data Encryption), but I am not...

Thank you Hugo, I was about to ask a question regarding this particular point (LEN(REVERSE(@Char))) but then I found your post, so no need.

Warm Regards,

Hany Helmy

In the Explanation: "A CASE expression will always evaluate the WHEN clauses from top to bottom. As soon as one evaluates to True, the corresponding [ELSE] is returned."

I think it...

Good question, although I didn`t take my coffee yet and it needed more concentration to read it properly (as most of the QoTD now are tricky), but I managed to...

I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

Any explanation dear author?!!...

I strongly agree with SQLRNNR, that`s true UNIQUE constraint does allow inserting multiple values (in a single column) as long as the whole compination of the UNIQUE constraint is not...

Thank you all for the useful info, links and that good free ebook, I already started reading it beside studying from MSDN and I am having real hard times with...

Thanx Gail for the response but unfortunately the same result I got [nothing useful]. Actually the official Microsoft training kit will be published later this year on November 1 other...

Create this Trigger on master db

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [Security]

ON ALL SERVER

FOR DROP_database

AS PRINT 'Database Dropped'

SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

ROLLBACK --this will...

I executed the query myself and it returned 1 row with the value of 1, so I guess the answer is wrong!;-)