Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: Replication between SQL Server versions

    In fact whilst the first answer works, the second answer is more correct since an instance of SQL Server 2012 would also do the job.

  • RE: Compression

    Thanks for the explanation.

  • RE: Compression

    I'd be interested to know what your rationale was for going for the answer you did.

    Can you explain please? I just want to know whether my assumptions were different. Did...

  • RE: Compression

    The question requires you to make some assumptions (the compressed database is wholly compressed, and the data is basically the same in both databases, for instance).

    The answer is based on...

  • RE: Can This Work?

    No - The create sp statement has to be the first statement in the batch, so, as written, the TSQL will not execute. (Try it.)

  • RE: Restart Log Backups

    Good question.

    However just because I could get away with a differential backup, the 'once bitten twice shy' part of me would always go for a full backup unless there was...

  • RE: Create Database

    Seems to me that both answers can be correct.

    Ian

  • RE: Hash Join

    Good question that made me think. Shame the quoted reference doesn't match the 'correct' answers.

  • RE: Computed Columns 1

    Just because you CAN trick SQL Server into allowing a computed column to indirectly reference columns in other tables does not mean you should. My strong suspicion is that if...

  • RE: SQL Server 2008 - Disabling Full Text Search

    Good question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the database...

  • RE: That case filter

    Poorly worded question that has nothing to do with the the subject in the title and with none of the possible answers matching what actually happens in practice.

    Other than that...

  • RE: Database Snapshot

    SQL Server Central have screwed up the answer to question of the day!

    The world is deafened by the sound of wailing and gnashing of teeth!

    Can I have my point, please?:crying:

  • RE: Creating an Indexed View

    It seems to be a common thread with a few of these questions which is that you have to try and second guess what the questioner meant to ask rather...

  • RE: Subtle Line Feed / Carriage Return issue

    The answer I got is 1,2,3,4. Running through SSMS 2008 R2 to an instance of SQLServer 2005.

    Seems like nobody tested this properly! That's the real answer that should be taken...

  • RE: To switch or not to switch

    Yep. I missed something - as th eprviuous poster said I was supposed to be selecting the incorrect answers.

    Doh!

Viewing 15 posts - 1 through 15 (of 19 total)