Forum Replies Created

Viewing 15 posts - 2,266 through 2,280 (of 5,685 total)

  • RE: insert in batches

    Tara-1044200 (11/18/2011)

    Can someone help me doing insert as select * into tab1 in a batches. I have almost billion records to insert and i think inserting in batches would...

    November 22, 2011 at 12:40 pm

    #1411756

  • RE: Processor license of SQL server

    GilaMonster (11/22/2011)

    Evil Kraig F (11/22/2011)

    Wut? Gyeaddangit! That better be one heck of a price drop.

    Around about 1 socket === 4 cores in terms of price. Is complex, see...

    November 22, 2011 at 12:34 pm

    #1411752

  • RE: Processor license of SQL server

    Ninja's_RGR'us (11/22/2011)

    What version are you buying?

    Sql 2012 will charge by cores.

    Before that it's by physical sockets.

    So a quad proc, 10 cores processor would only require 4 licenses, in 2012 it's...

    November 22, 2011 at 11:56 am

    #1411738

  • RE: Processor license of SQL server

    You pay per socket, not per core/cpu.

    IE: If you have a 16 core chip, it takes up 1 socket. You buy the license on the socket (1), not...

    November 22, 2011 at 11:55 am

    #1411737

  • RE: Service broker traverses domain boundaries

    That's going to be in endpoint and routing (for the keywords you need), and a discussion with your network administrator about what you can do to get shared trust between...

    November 22, 2011 at 11:53 am

    #1411734

  • RE: Control flow Vs Data flow

    Koen Verbeeck (11/22/2011)

    Evil Kraig F (11/21/2011)

    Erm... um... have you ever used SSIS? This sounds like an interview question. This is chapter 1 page 3 of any intro to...

    November 22, 2011 at 11:45 am

    #1411727

  • RE: What's the best way to get an entry level job on SQL server?

    peterob1 (11/22/2011)

    Thanks Craig.

    Love the bit about criminal bosses. Have to find one now.

    Seriously, thanks for taking the time, I will go through the article and try and use your suggestions.

    My...

    November 22, 2011 at 11:32 am

    #1411721

  • RE: Faster way to INSERT INTO large table

    Jeff Moden (11/21/2011)

    "Divide'n'Conquer". I like it and that's the way I would do it. That, notwithstanding, I wonder how MERGE would fair on such a thing?

    It would also...

    November 22, 2011 at 11:28 am

    #1411719

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/21/2011)

    Ah, well. I'm sure I screwed the pooch on some of those questions, but here's my launch buddy link. Anyone care to click for me?

    http://www.launchbuddi.es/5OHbk

    I need to figure...

    November 21, 2011 at 4:34 pm

    #1411111

  • RE: advice on archiving data

    Joe B-478020 (11/21/2011)

    I have the following problem...

    We have a manufacturing system database that continues to grow. Each day, new manufacturing orders and purchase orders are inserted and new transactions...

    November 21, 2011 at 4:05 pm

    #1411098

  • RE: SELECT inside a FROM - bad programmming practice?

    Edward Mlynar (11/21/2011)

    If putting arbitrary restrictions on how you accomplish a problem is a requirement for getting a scholarship then I would say "no, thank-you, but you can keep your...

    November 21, 2011 at 3:57 pm

    #1411091

  • RE: Faster way to INSERT INTO large table

    Amy.G (11/21/2011)

    I would sincerely look into 2-staging this process however. Holding insert/exclusive locks on the Alvis_22 schema table until this completes is just bad form. Do the long...

    November 21, 2011 at 3:54 pm

    #1411089

  • RE: Faster way to INSERT INTO large table

    Amy.G (11/21/2011)

    WOW. Lowell and Craig -- you guys really went above and beyond in helping me with this mundane issue. Thank you so much.

    Our pleasure. When you get those...

    November 21, 2011 at 2:43 pm

    #1411060

  • RE: Are the posted questions getting worse?

    george sibbald (11/21/2011)

    I hate to interrupt a bit of DBA baiting but anyone using IE9?

    Any usage or upgrade issues? I'm an old fuddy duddy still on vista.

    Switched at home...

    November 21, 2011 at 2:38 pm

    #1411058

  • RE: How to store lots of data (1024 columns) for a particular reading

    Heh, I misunderstood the final use of this data. I realized the spectrometer took all those readings as a whole but my brain went a bit sideways on the...

    November 21, 2011 at 2:36 pm

    #1411056

Viewing 15 posts - 2,266 through 2,280 (of 5,685 total)