Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 3,221 total)

  • RE: Database Mirroring

    A very good, clear, concise question.

    Found out I knew something.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Inserting records into table does not keep the same order as inserted

    First my assumptions.

    1. Your table dw_trans was not defined in your posting

    2...Using a guesstimate approach I created a table dw_trans

    3. Using my guestimated data I loaded a few...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Creating an Indexed View

    Patrick2525 Posted Today @ 2:39 PM

    I think this more than anything has helped me pass the 70-432 and 70-433 exams.

    CONGRATULATIONS

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Creating an Indexed View

    So if I did apply the correct answer I could not create the additional indexes due to the error of attempting to create a "duplicate" index?

    Not sure if I understand...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Output to text file without line feed

    Mark Rice (3/30/2011)


    Craig - thank you so much for the quick reply.

    We found that the method you suggested will work, and we also found a way we could do this...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Creating an Indexed View

    Patrick2525 (3/30/2011)


    Carlo Romagnano (3/30/2011)


    The correct answer is "None of the above"

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    Tables must be referenced by two-part names, schema.tablename, in the view definition.

    I want back my points.

    Sorry about that - I...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    I'm going, but I'm working. I'll be doing a presentation as well as representing Red Gate (one of the sponsors) on the cruise.

    Sounds more like a paid vacation than...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Updating Records Based on Select Results

    Jeff Moden (3/29/2011)


    Johan, Ron, Gus, and David... thanks for jumping in on this one. 🙂

    Jeff - no problem. I spent 6 years as a scout master for a...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Creating an Indexed View

    SQL 2008 a minor glitch in creating the view, but nothing that would detract from answering the question.

    The link to the supporting documentation did not work, at...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Arrg null identity initial value reseeds to 0

    I do not seem to have the same result for

    INSERT INTO [dbo].[Applications]

    SELECT 'some name here or there'

    DELETE FROM [dbo].[Applications]

    dbcc checkident('Applications', reseed, 0)

    INSERT INTO [dbo].[Applications]

    SELECT 'more of this nonsense some...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    For all gurus on the thread .... Are any of you going to try for this nice little gem

    SOLVED A BEASTLY PROBLEM THAT WAS PLAGUING YOUR SERVERS FOR DAYS,...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Not Video, but music..... here is an announcement from AMAZON

    Appeared today at:

    http://www.bbc.co.uk/news/technology-12890677

    Amazon has unveiled an online music service that lets users upload songs and play them from a range...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)

    http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Updating Records Based on Select Results

    Original corrected by Jeff Moden ... so my errors removed so as not to confuse others who may read this ....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Problem with a TRIGGER INSERT

    luissantos (3/28/2011)


    Hello comunity

    Nobody have an ideia to solve my problem ?

    Luis Santos

    Many people do not like opening an attached file, such as the zip file you have attached. Who...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 15 posts - 1,321 through 1,335 (of 3,221 total)