Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 18,926 total)

  • RE: To Create PDF from SQL stored procedure

    That should all be handled by that app that takes the order, not a job for sql server.

  • RE: Speeding up weekend maintenance

    ... and seriously, consider asking nicely for a 1 off test to solve a problem your manager is having. I've never had anyone say no to me to...

  • RE: Speeding up weekend maintenance

    Bhuvnesh (3/11/2011)


    Current db size is 900 gb and you are saying it could get flat raise in next year.you shud also think about following steps.

    1 manage your DB on multiple...

  • RE: Upserts - or copying entire rows when a key match is found between two tables

    greg.bull (3/11/2011)


    Hi there all,

    I have a table stucture as:

    location, month, metric1, metric2,..metric100

    I want to update the rows in this table with newer data, which is in the same format as...

  • RE: Speeding up weekend maintenance

    I'm not sure about the consequences or running update stats (locking wise). But maybe you could move to a model where you're constantly updating stats.

    You could then control those...

  • RE: LOB Data

    Rant!!!!!!!

    Ok I'm done :hehe:.

  • RE: Non-Clustered Indexes - Need some advice

    LutzM (3/7/2011)


    After some reformatting I figured the both queries used in the UNION statement are pretty much identical except for the join to BatchKeg and Keg and the ch.FlexTank =...

  • RE: Tables empty, but DB Size out of control

    Mike Hinds (3/3/2011)


    Craig - many thanks!

    I'll be saving and studying the info you provided.

    FWIW, the 3rd party software vendor now tells me they are familiar with this behavior.

    He...

  • RE: Heaps

    Duncan Pryde (3/3/2011)


    UMG Developer (3/3/2011)


    Steve Jones - SSC Editor (3/3/2011)


    The questions has been corrected (again, sorry) to note that 2 answers are required. The standard MS tests tell you...

  • RE: Query plan metamorphosis

    Grant Fritchey (3/3/2011)


    I'm still at the MVP summit so I have no time to play. I'll see if I can experiment a little when I get back next week. I...

  • RE: Heaps

    Koen Verbeeck (3/3/2011)


    Steve Jones - SSC Editor (3/3/2011)


    I also changed the size of the rows to fill the page.

    Sorry to point out an error again, but now you say in...

  • RE: Query plan metamorphosis

    Gianluca Sartori (3/3/2011)


    You're probably right.

    Let's see what happens, I'll keep you posted.

    Thank you, guys.

    I don't see what else to try. You found the issue. You know what...

  • RE: Query plan metamorphosis

    Time to call ms product support.

    Hopefully they'll see it as a bug and not charge the call!

  • RE: Query plan metamorphosis

    ... and once you get this resolved, please post the bug on connect so that ms can fix this isssue for the rest of us.

    TIA.

  • RE: Tables empty, but DB Size out of control

    Craig Farrell (3/2/2011)


    Mike Hinds (3/2/2011)


    (No column name)(No column name)usedtotal

    queue_messages_846626059339836631990103199419sysdercv6796973484825484888

    sysdesend67969734883648856

    sysconvgroup67969733140131408

    sysobjvalues2596186

    What are they, and what can I safely do with them?

    :blink: Do you have Service Broker active on this database? Check...

Viewing 15 posts - 7,066 through 7,080 (of 18,926 total)