Forum Replies Created

Viewing 15 posts - 691 through 705 (of 3,221 total)

  • RE: Stored Procedures including Temporary Tables : Don't error on CREATE PROCEDURE (Can this be forced or tested)

    You might want to read:

    http://msdn.microsoft.com/en-us/library/ms190686(v=sql.100).aspx

    Which states:

    When a stored procedure is created, the statements in the procedure are parsed for syntactical accuracy. If a syntactical error is encountered in the procedure...

    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]

    February 8, 2012 at 9:37 am

    #1444628

  • RE: Using SP_

    sathishkumar.k (2/8/2012)

    Great question... Is that mean when any object with SP_ prefix used in combination with if (as in this case) would be searched in the current DB first and...

    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]

    February 8, 2012 at 9:25 am

    #1444615

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/7/2012)

    Now that it is officially posted on facebook, I can start telling everyone.

    Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born 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]

    February 7, 2012 at 8:54 pm

    #1444271

  • RE: Deadlock

    Good question - jogged my memory and by gosh I had not forgotten it.

    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]

    February 7, 2012 at 8:48 pm

    #1444270

  • RE: How to update the database table by removing trailing spaces from one of the columns?

    Unless it is extremely important to you now I suggest you leave things as they are. Why do I say that - well read the following:

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

    Which in part states

    In...

    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]

    February 7, 2012 at 11:30 am

    #1444008

  • RE: Duplicate record delete

    SGT_squeeqal

    If you do use a cursor, you might want to compare its performance with a

    CTE such as this sample. I believe if you do and have a reasonable

    number of...

    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]

    February 7, 2012 at 6:46 am

    #1443732

  • RE: Restore SQL 2000 DB in SQL 2005

    I suggest you read the following before upgrading.

    http://msdn.microsoft.com/en-us/library/ms144267(v=sql.90).aspx

    And understand the effect of the upgraded database by reading about the compatability mode at:

    http://msdn.microsoft.com/en-US/library/ms178653(v=sql.90)

    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]

    February 7, 2012 at 5:33 am

    #1443695

  • RE: Duplicate record delete

    SGT_squeeqal (2/6/2012)

    Bring you results into a cursor and then use rowcount -1 row to delete like for example, this will then delete all your duplicate rows bar 1

    declare @col1 datatype,

    @col2...

    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]

    February 7, 2012 at 5:13 am

    #1443682

  • RE: SQL 2000 and SQL 2005 security features (differences)

    I suggest you start reading here:

    http://sqlcat.com/sqlcat/b/whitepapers/archive/2007/12/16/sql-server-2005-security-best-practices-operational-and-administrative-tasks.aspx

    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]

    February 6, 2012 at 12:35 pm

    #1443379

  • RE: Duplicate record delete

    preetpalkapoor (2/6/2012)

    Thanks every one for your support.

    i got 3 methods to do that.

    1. To make temp table with i will check with my real time DB and is the easiest...

    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]

    February 6, 2012 at 12:26 pm

    #1443373

  • RE: Store procedure header

    Including them inside the SQL statement

    -- + 1

    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]

    February 6, 2012 at 10:39 am

    #1443315

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    GilaMonster (2/6/2012)

    Is it bad form, if you create a QotD, to list your own article as a reference?

    Might not be bad form, but I can just image the list of...

    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]

    February 6, 2012 at 8:52 am

    #1443226

  • RE: Using split funtion for multiple values

    pwalter83 (2/6/2012)

    bitbucket-25253 (2/6/2012)

    Once you have eliminated the commas then use

    DECLARE @Res VARCHAR(10)

    SET @Res = 'KNL RTM'

    SELECT REPLACE(@Res,' ','')

    Result:

    KNLRTM

    Thanks Ron,

    But the thing is I dont wish to join the values, instead...

    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]

    February 6, 2012 at 8:38 am

    #1443216

  • RE: alternative to table variable and temp tables

    You might want to read this and then decide which method is best for you situation

    http://blogs.msdn.com/b/sqlcat/archive/2008/10/09/table-variable-vs-temp-table-and-estimated-vs-actual-query-plan.aspx

    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]

    February 6, 2012 at 7:30 am

    #1443124

  • RE: Using split funtion for multiple values

    Once you have eliminated the commas then use

    DECLARE @Res VARCHAR(10)

    SET @Res = 'KNL RTM'

    SELECT REPLACE(@Res,' ','')

    Result:

    KNLRTM

    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]

    February 6, 2012 at 7:11 am

    #1443104

Viewing 15 posts - 691 through 705 (of 3,221 total)