Hi Nakul ,

Maybe a database is surely the object which "owns" the most important count of child objects ( 1 datafile , 1 logfile , a table with at...

Hi Steve ,

You are right in your editorial but I am feeling that I have to report some points that it is possible you forgot ( coming from my participation...

Excellent post , Toreador. You are right. The * means only that the value -51 cannot represent any ASCII character for which the minimum value is 0 ( maybe ,...

Too easy question : as I knew that at least the three last choices including "only" were correct, I was left with an unique choice : the last one.

The certificates...

Thanks Louis for your explanations.

With DROP , the whole database disappears , on the contrary , sp_detach_db keeps the files and enables the possibility to move the location of these...

Question which is easy to answer if you had already to create a stoplist. I had to dive deeply in my own memory as I faced this problem when I...

Interesting question , but I have a question : what are the existing différences between DROP DATABASE and the use of sp_detach_db ? I prefer to use sp_detach_db ( because...

Sorry , Mr Steve Jones , I think you don't know how to read the BOL : the D answer is the good one ( and it is not the...

Easy question as I have followed a session about this topic ( with a marvellous speaker , Frédéric Pichaud ) at Issy-les-Moulineaux. All the answers were given and fully...

TDE and In-Memory OLTP are far to be my favorite topics ( truly I am a beginner ) and I have to admit that if I provided the good answers...

I have forgotten to read the excellent article from the same day as this question

[/url]

http://www.sqlservercentral.com/articles/Stairway+Series/121476/

about code signing which was giving the "good answer" for this question... Bad luck...

Thanks for this simple question. I had only to remember my 1st tests with PowerShell 6 years ago. I guess easily that the last proposal was not the good one....

Maybe to follow the idea of Grant , you could have a look at this link :

It is about the DMV sys.dm_tran_locks

Maybe also the DMV sys.dm_exec_requests could be...

I used SOME only once so I was able to find the "good" answer.But thanks for the link you provided towards the MSDN documentation , as I discovered that SOME...

I was lucky to find the good answer. The only two things I was sure was that it was impossible to create snapshots of system or mirrored databases. It is...