Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 3,221 total)

  • RE: Are the posted questions getting worse?

    I imagine I am the oldest one to comment.. I was born in 1932 at the height of what is now called the "Great Depression". My dad was out...

    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]

    September 2, 2011 at 2:41 pm

    #1376692

  • RE: Bulk Insert with bad data

    You can remove the quotation characters by utilizing the REPLACE function. For example:

    DECLARE @in VARCHAR(200)

    SET @in = 'MAIN,0016861779528,"Dembo, Ron C","""Roulette"" or the Rules of Risk",0.00,,,"XX(205733.1)",2001,20020311,0,,'

    SELECT REPLACE(@IN,'"','')

    Result:

    MAIN,0016861779528,Dembo, Ron C,Roulette or...

    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]

    September 2, 2011 at 8:06 am

    #1376451

  • RE: Please help with Merge statement understanding

    Remove:

    WHEN NOT MATCHED BY SOURCE

    THEN DELETE

    Believe that is the source of the unwanted deletions.

    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]

    September 1, 2011 at 8:53 pm

    #1376250

  • RE: Disaster Recovery

    SQLkiwi (8/30/2011)

    Nice easy one today. I wonder how many will get it wrong though?

    Just for the record:

    A few more of us

    How other members answered

    Correct answers: 75% (6)

    Incorrect answers:...

    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]

    August 30, 2011 at 9:44 pm

    #1375292

  • RE: Are the posted questions getting worse?

    SanDroid (8/29/2011)

    GSquared (8/29/2011)

    GilaMonster (8/29/2011)

    WayneS (8/29/2011)

    Just read this: http://ittybiz.com/death-threats-online/. Appalling.

    Unbelievable. What is it, that they feel threatened by someone else's success?

    I read a book about that once, by some guy named...

    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]

    August 29, 2011 at 12:58 pm

    #1374659

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/26/2011)

    Here's something everyone in IT should be aware of

    Your decision making ability deteriorates as you make more decisions

    Thanks, terrific read. Now got to put sugar in my...

    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]

    August 26, 2011 at 9:23 am

    #1373855

  • RE: How do I modify this to show growth over a month? 7/1/11-7/31/11

    jdowling 65301 (8/26/2011)

    Here's what it says. The first query ran fine, the sencond I ran against one of my local dbs and it gave me an error

    INSERT INTO GrowthofDBEXEC sp_track_db_growth

    Msg...

    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]

    August 26, 2011 at 9:08 am

    #1373837

  • RE: How do I modify this to show growth over a month? 7/1/11-7/31/11

    jdowling 65301 (8/26/2011)

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'sp_track_db_growth'.

    Thats all that gives me...

    1. I reran the code that I posted earlier, using cut and paste...

    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]

    August 26, 2011 at 8:51 am

    #1373816

  • RE: Do we need to backup SSAS databases ?

    Like most things in SQL Server the answer is It depends

    What would happen if all the data currently in an SSAS database could not be accessed since unknown to yourself...

    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]

    August 25, 2011 at 5:56 pm

    #1373552

  • RE: How do I modify this to show growth over a month? 7/1/11-7/31/11

    jdowling 65301 - Here is one way

    -- Step 1. Create the table to save the data

    CREATE TABLE GrowthofDB(C1 VARCHAR(20),C2 VARCHAR(20),DBNAME VARCHAR(100),FileGroupName VARCHAR(100),

    LogicalFileName VARCHAR(100),PhysicalFileName VARCHAR(100)

    ,FileSize DECIMAL(10,2),Growth DECIMAL(10,2))

    --Step 2 ......

    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]

    August 25, 2011 at 4:51 pm

    #1373546

  • RE: Are the posted questions getting worse?

    GilaMonster (8/24/2011)

    They haven't been nominated for the Board of Directors, they've been chosen to serve on the nomination committee, the committee that evaluates the nominations for the Board.

    Thanks for catching...

    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]

    August 24, 2011 at 11:49 am

    #1372762

  • RE: Are the posted questions getting worse?

    Recieved e-mail one hour ago from Pass

    [delete]Nominated for the Pass Board of Directors[/delete]

    [correction]

    The 2011 Nomination Committee (NomCom) – a team that assesses and reviews all PASS Board of Director...

    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]

    August 24, 2011 at 10:59 am

    #1372716

  • RE: The Right Kind Of Join

    Very nice ...

    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]

    August 23, 2011 at 9:48 pm

    #1372333

  • RE: Are the posted questions getting worse?

    My son lives in the Tidewater area (Virginia Beach), at the time of the tremor he was driving and felt nothing ... but when he stopped at his destination 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]

    August 23, 2011 at 5:37 pm

    #1372313

  • RE: DTS Excel export sheet2

    How are you designating the second range ?

    Is it something like this Sheet2$a4:c

    I have been away from DTS for too long but do remember finding a great deal of help...

    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]

    August 23, 2011 at 4:19 pm

    #1372294

Viewing 15 posts - 1,006 through 1,020 (of 3,221 total)