Forum Replies Created

Viewing 15 posts - 181 through 195 (of 715 total)

  • RE: Columnstore Indexes

    Stewart "Arturius" Campbell (3/16/2015)

    Koen Verbeeck (3/16/2015)

    Carlo Romagnano (3/16/2015)

    Hany Helmy (3/15/2015)

    Gr8 question, thanx 🙂

    Did anyone tried this feature before? And is there any actual performance gained?

    I tried just a little. The...

    March 17, 2015 at 4:30 am

    #1784440

  • RE: Nested Break

    Interesting question, never user [BREAK] before, thanx

    March 17, 2015 at 12:47 am

    #1784408

  • RE: Columnstore Indexes

    Gr8 question, thanx 🙂

    Did anyone tried this feature before? And is there any actual performance gained?

    March 15, 2015 at 8:02 am

    #1784107

  • RE: Secondary XML Indexes

    I was sure about 2 of them, but had to search for the 3rd type, thanx.

    March 15, 2015 at 7:57 am

    #1784106

  • RE: Secondary XML Indexes

    Ed Wagner (3/13/2015)

    I must admit that I don't use XML very much. It's does store very flexible data structure, but it just doesn't perform well. Thanks for the...

    March 15, 2015 at 7:53 am

    #1784105

  • RE: Index Fragmentation

    Alvin Ramard (3/11/2015)

    Hany Helmy (3/11/2015)

    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. ...

    March 15, 2015 at 6:37 am

    #1784101

  • RE: Index Fragmentation

    Alvin Ramard (3/11/2015)

    Hany Helmy (3/11/2015)

    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. ...

    March 15, 2015 at 6:34 am

    #1784100

  • RE: Performance Counters

    Igor Micev (3/12/2015)

    I knew it's possible but didn't know that it could be with the -x option in the startup options.

    Thanks

    + 1 same here 🙂

    March 15, 2015 at 6:33 am

    #1784099

  • RE: Index Fragmentation

    Alvin Ramard (3/11/2015)

    Hany Helmy (3/11/2015)

    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. ...

    March 15, 2015 at 6:28 am

    #1784098

  • RE: Index Fragmentation

    I am using this one a lot, thanx for the question.

    March 11, 2015 at 12:28 am

    #1783134

  • RE: Reading Logs

    raulggonzalez (3/10/2015)

    Sean Lange (3/10/2015)

    I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my...

    March 11, 2015 at 12:24 am

    #1783133

  • RE: Identity Column Datatype

    TomThomson (3/7/2015)

    This is a rather early repeat! We had an identical question on Jan 13th, less than 2 months ago; and then on Jan 20th we had another question...

    March 9, 2015 at 7:04 am

    #1782497

  • RE: Identity Column Datatype

    Toreador (3/9/2015)

    TomThomson (3/7/2015)

    So a nice easy question, and it will be rather disappointing if the correct answers end up much below 100%.

    Currently just 61%. And looks like 2% didn't realise...

    March 9, 2015 at 7:03 am

    #1782495

  • RE: Backing up from SETUSER

    Never used it before SETUSER, but very good question despite of the date issue.

    March 8, 2015 at 1:39 am

    #1782382

  • RE: Remove data from tables

    divu.17 (3/5/2015)

    "Delete table" is not a correct syntax in option d.

    Correct and is option c and f.

    Thanks,

    Divya.

    C is not correct, cause you can`t delete any rows from table AAA...

    March 5, 2015 at 2:08 am

    #1781840

Viewing 15 posts - 181 through 195 (of 715 total)