Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 8,416 total)

  • RE: Temporary Indexes

    mikewhi (4/29/2011)

    We use them in ETL processing. We BCP into a heap, create a clustered index, run multiple queries on the CL index and then drop it in preparation for...

    April 29, 2011 at 5:35 pm

    #1318007

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/29/2011)

    I primarily use Chrome.

    I did too for many years, and would not have touched IE again without being paid well to do it.

    Then I tried IE9. Now it's...

    April 29, 2011 at 5:28 pm

    #1318003

  • RE: Online indexing

    Michael Valentine Jones (4/26/2011)

    I was wondering why the OP even posted this question. Taking 5 minutes to actually test it would have verified that you can.

    There were two parts...

    April 26, 2011 at 10:04 am

    #1315993

  • RE: Online indexing

    Ninja's_RGR'us (4/26/2011)

    Sql Wiki in action 😀

    I bet you could fin 20 more usefull refferences for this issue if you really tried hard enough :hehe:.

    At least!

    April 26, 2011 at 7:28 am

    #1315861

  • RE: Online indexing

    Edward-445599 (4/26/2011)

    Can you do online indexing when in compatibility level 80? Would this make any difference in the time it would take to do a massive table?

    Yes you can, assuming...

    April 26, 2011 at 6:59 am

    #1315835

  • RE: SET ROWCOUNT

    toddasd (4/25/2011)

    Not only confusing, but dangerous! I'm reading Defensive Database Programming by Kuznetsov and he describes where any triggers on the table in the code above will be affected by...

    April 25, 2011 at 12:21 pm

    #1315542

  • RE: SET ROWCOUNT

    toddasd (4/25/2011)

    The INSERT TOP (4) ignores the SET ROWCOUNT 2 and inserts 4 rows anyway. That's the part opc.three pointed out to me.

    That's true - but only if the TOP...

    April 25, 2011 at 10:45 am

    #1315509

  • RE: Are the posted questions getting worse?

    Jeff,

    VSTA is installed by SQL Server 2008 for use with SSIS scripting (see http://msdn.microsoft.com/en-us/library/bb522527(v=SQL.100).aspx). SQL Server 2005 used something called VSA (notice the missing 'T'). VSTA can be...

    April 25, 2011 at 1:04 am

    #1315318

  • RE: Row size, indexes and varchar(max)

    titan2782 (4/21/2011)

    There are two columns set to varchar(2048). I changed those to varchar(max) and the row size went down to about 6000. I used the queries found here http://www.sqlservercentral.com/Forums/Topic226699-5-1.aspx...

    April 24, 2011 at 6:39 am

    #1315247

  • RE: SET ROWCOUNT

    toddasd (4/21/2011)

    I didn't know INSERT could have a TOP clause.

    It's a good thing to know, because SET ROWCOUNT will not work with INSERT, DELETE, or UPDATE in the next version...

    April 24, 2011 at 6:09 am

    #1315243

  • RE: Are the posted questions getting worse?

    Darn my addled jet-lagged brain - I forgot to mention how great it was to meet Jack Corbett and have a couple of good long chats with him. I...

    April 4, 2011 at 12:57 am

    #1306862

  • RE: Are the posted questions getting worse?

    What an amazing day at SQL Saturday #71 in Boston today.

    Got to meet heaps of great people including Grant and Stefan K!

    If anyone would like to see the slides from...

    April 2, 2011 at 7:10 pm

    #1306797

  • RE: Are the posted questions getting worse?

    Hi everyone. Just to confirm it officially: I am now a SQL Server MVP (yay!)

    Thanks to everyone for their kinds words and encouragement.

    Paul

    April 1, 2011 at 2:30 pm

    #1306693

  • RE: Are the posted questions getting worse?

    Roy Ernest (4/1/2011)

    Today is a sad day for me personally and to add more pain to it I had a car accident. My body hurts badly. My car is just...

    April 1, 2011 at 12:24 pm

    #1306649

  • RE: Indexed Computed Column Not Used to Perform Seek

    HowardW (3/29/2011)

    ...so I know it's not already fixed (if it is a bug)?

    It's a regression, but not a bug IMO. It seems there has been an enhancement that collapses...

    March 29, 2011 at 11:23 am

    #1305046

Viewing 15 posts - 2,011 through 2,025 (of 8,416 total)