Forum Replies Created

Viewing 15 posts - 17,596 through 17,610 (of 19,560 total)

  • RE: Stored procedure exec taking extremely long

    What does the udf do that could not be done in a stored proc?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 4, 2010 at 12:23 am

    #1113503

  • RE: Report Server Diagnostic Reports

    This was perfect timing for me. I was just looking for something to help me with the very topic.

    Thanks for the article.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 4, 2010 at 12:16 am

    #1113502

  • RE: Invalid length parameter passed to the substring function.

    arun.sas (2/4/2010)

    Hi

    One of the record in the ftpfile table does’t have the DOT(“.”) character and same which you search in the charindex/substring, hence this error occurred.

    As Arun said, the character...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 4, 2010 at 12:12 am

    #1113499

  • RE: can I map an LSN to a username or hostname?

    Drikus Roux (2/4/2010)

    If you are going to use the LSN to get to the UID (given your application does not impersonate and you don't have roles instead of users etc.)...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 4, 2010 at 12:09 am

    #1113496

  • RE: corrupt index (nonclustered primary key) after 2005 upgrade

    Paul White (2/3/2010)

    Paul Randal (2/3/2010)

    Skipping over all the Oracle nonsense...

    :laugh: :w00t:

    :Whistling::laugh:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 4, 2010 at 12:06 am

    #1113495

  • RE: Fragmentation on the table happening to quickly (urgent Please assist))

    Are the records being deleted sequential? And the records being loaded, are they sequential?

    The delete and reload is fragmenting your clustered index and other indexes. As the table...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 4, 2010 at 12:01 am

    #1113491

  • RE: help to get result from sql server for stock

    I may have misunderstood your first post.

    If you want an aggregate of all of the records in the table then:

    select itmcod,

    sum(isnull(opeqty,0))as opeqty,

    sum(isnull(inwqty,0))as inwqty,

    sum(isnull(isuqty,0)) as isuqty,

    ((sum(isnull(opeqty,0))+ sum(isnull(inwqty,0)))-sum(isnull(isuqty,0)))AS CLOSQTY

    from ITMLED

    group...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 11:56 pm

    #1113490

  • RE: Fragmentation on the table happening to quickly (urgent Please assist))

    Is the table wiped out, or is the DB2 data just added to the existing records in the destination table?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 11:40 pm

    #1113485

  • RE: help to get result from sql server for stock

    KeyurGohel (2/3/2010)

    Table: ITMLED

    Recsno itmcod opeqty inwqty isuqty

    6200 001 500 ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 11:36 pm

    #1113481

  • RE: NULL & 'NULL'

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 11:30 pm

    #1113478

  • RE: sql server very slow

    carloparcon (2/3/2010)

    the bigger in difftime is 16160, if i upgrade to 4gb is it possible solve my problem?

    More than likely not. As Jeff and Elliott said - it seems...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 11:17 pm

    #1113474

  • RE: Fragmentation on the table happening to quickly (urgent Please assist))

    If this hasn't happened in the past, what has changed?

    Also, what is the table structure and what is the clustered index?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 11:02 pm

    #1113467

  • RE: Changing Builtin/users to builtin/administrators

    like2innovate (2/3/2010)

    So do I just delete it? And if so, what about the BUILTIN/ADMINISTRATORS, it's not there. Is it supposed to be? Or is my MYPC/ADMINISTRATOR (aka computername/login name)...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 10:55 pm

    #1113465

  • RE: sql saturday and PASS mariage news

    Hmmm. Gonna have to start coercing people to get one going in my area. It sounds like a lot of fun.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 9:42 pm

    #1113442

  • RE: Changing Builtin/users to builtin/administrators

    like2innovate (2/3/2010)

    I'm a newbie who has setup SQL server 2008 Express on a Vista machine. I installed the express edition on under my adminstrator account, and set it to use...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 3, 2010 at 9:40 pm

    #1113440

Viewing 15 posts - 17,596 through 17,610 (of 19,560 total)