Forum Replies Created

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

  • RE: Friday the 13th

    Nice. Very humorous.

    😛

  • RE: BETWEEN

    Whereas I can agree with the wording change from 'same' to 'identical', I thought it was obvious what this question was testing.

    Good question.

    Thanks

    -Jeff

  • RE: SQL Server 2008 FILESTREAM

    Currently filestream is not enabled by default...to enable it you must use:

    exec [sp_filestream_configure] @enable = 3;

    Then to see this value..which is what I think the question is getting at:

    "Enabled for...

  • RE: SQL Server 2005

    I agree that saying

    mssqlsystemresource.mdf should not be considered Resource but MSSQLSystemResource

    can probably be considered splitting hairs. :hehe:

    My BOL talks about 5 system databases as well.

    Cheers!

    Jeff

  • RE: SQL Server 2005

    I can see the debate over this question, however, I'm going to side with this statement:

    "The physical file name of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf."

    It's my opinion...

  • RE: Set trigger firing order

    The question was only concerned with 3 triggers. Setting the order the way the answer states would work. As for using the solution with more than 3 triggers, keep in...

  • RE: Backups

    Agreed, that's why I didn't quote that part. 😉

  • RE: Backups

    Correct....so to quote Steve earlier

    The process is *not* re-entrant.

    Cheers

  • RE: Backups

    This sounds like the debate over 'enabled' in the QotD earlier in the month

    http://www.sqlservercentral.com/Forums/Topic478219-1242-1.aspx

    To use the saying from that thread by Steve Jones, it sounds like we are splitting hairs...

  • RE: Backups

    Good question.

    I agree with Gsquared. Nice analogy btw. 😀

  • RE: Storage Size

    I thought the QotD was an interesting topic. I would also like to thank Hugo for his in-depth explanation. Points or not, I learned something new.

    Cheers

  • RE: Query

    I can understand looking at the QotD as a puzzle sometimes and not always from a 'best practices' perspective.

    Good point Steve.

  • RE: SQL Server 2005

    Vishal,

    Are you just quoting Kenneth? I ask because you have copy/pasted most of his post.

    Please scroll up to refer to the other posts on this topic. Just setting the...

  • RE: SQL Server 2005, Windows Vista and Office 2007 Compatibility

    Thanks Steve. I just answered and it's working correctly now.

    Where I agree on the idea of a review panel, I still learn new things even if the QotD answer or...

  • RE: SQL Server 2005

    Hi Steph,

    Let's start with Reconfigure. The options we are setting here can be configured to be turned on. For example. If you execute:

    sp_configure 'show advanced options', 1;

    Then execute sp_configure you...

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