Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: Yet another way to defrag indexes

    What advantages does this script have over Ola Hallengren's index maintenance solution?

  • RE: Script to Generate Table to Stored Procedure Cross References

    Why is a char(32) being added to the table name? I noticed that this script is missing references, I wonder if this could be why?

    I'm also curious, why is there...

  • RE: Script All Logins / Users / and Roles

    Why not use sp_helprevlogin to script the logins/users instead? http://support.microsoft.com/kb/918992

    Also, any reason why you decided to not include all permissions and only script roles?

  • RE: IFF - 1

    tabinsc (6/6/2013)


    2008R1 tells me:

    Msg 102, Level 15, State 1, Line 9

    Incorrect syntax near '='.

    It doesn't appear to like the @a = @B.

    IIF isn't supported in 2008,...

  • RE: IFF - 1

    Terrible question! Why?? Because it reminded me that I still am stuck with 2008R2. 😀

    Just kidding -- but anyway, good question.

  • RE: Clustered Index

    Nevertheless, I understood the concept you were trying to convey.

    The programmer inside of me had to point out a very specific detail. 😉

    I thought that was a very good question...

  • RE: Clustered Index

    edit: misread the question.

    But, how can (iv) be true?

    How can the index rebuild remove the fragmentation from the index? The table is empty at that step so it should already...

Viewing 7 posts - 16 through 22 (of 22 total)