Forum Replies Created

Viewing 15 posts - 136 through 150 (of 479 total)

  • RE: Isolation levels - Database Engine

    Ray Herring (3/6/2009)


    I agree with BitBucket. The results described at what you would expect in "normal" operations (assuming the typo is corrected)

    I understand the sections BitBucket quoted, but can't...

  • RE: Isolation levels - Database Engine

    Bitbucket,

    Irish Flyer has already stated the fact that was confusing me.

    From the way your scenario was stated, the second script did not commit its changes. Hence I wrote my tests...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/5/2009)


    Bob Hovious (3/5/2009)


    Why, O Ming, why?

    Oh, geez, great. Now Queen and the theme from Flash Gordon are going through my head....

    Now, I've got it running through my...

  • RE: Distinct going slower than *

    Putts (3/5/2009)


    WF_STOP index is not helping either .....

    I has a suspicion it might not help as it was common to all queries. Did you check if the plan changed at...

  • RE: Distinct going slower than *

    GilaMonster (3/5/2009)


    Derek Dongray (3/5/2009)


    Also I'd be interested to see the source of the User-defined function FFG_FX_JUST_DATE since, although it doesn't add the the estimated cost

    Scalar functions never do. It's one...

  • RE: Distinct going slower than *

    Putts (3/5/2009)


    Derek was working off the code on page 1 .... I'll go back and modify that to say "read page 4"

    My settings are different. 🙂 It's all page 1...

  • RE: Distinct going slower than *

    Putts (3/5/2009)


    Derek Dongray (3/5/2009)


    Looking at the plan....

    Sorry for a bit of confusion, Derek, but have brought up a new query that is doing something very similar here on page 4....

  • RE: Distinct going slower than *

    Looking at the plan, 73% of the estimated cost comes from 2 joins and a 'not null' filter, which I've reconstructed as

    Select

    AUND.AUND_INBOX,

    RPT_SQL_CL.dbo.FFG_FX_JUST_DATE(A.WF_START) as Expr1007

    from

    RPT_SQL_CL.dbo.IREP_T_WF_INFO as A

    right join -- 13,988,837 rows...

  • RE: Building table dynamically fails

    Use parentheses

    exec ( @v_exec_str )

  • RE: run SSIS from SP?

    Take a look in Books Online at the system procedures sp_add_job, sp_add_jobstep, sp_add_jobserver, sp_start_job and (probably) sp_delete_job.

    Something like...

    use msdb

    exec sp_add_job

    @job_name = 'Test 1'

    declare @cmd varchar(100)

    --

    -- Command value was simply...

  • RE: XML Help for SQL Server 2005

    You need to repost or edit your message to get the XML to show.

    The SqlServerCentral message editor is not friendly towards XML.

    To post your message, create it in another editor...

  • RE: Isolation levels - Database Engine

    Can someone clarify the question and answers here please?

    The question is asking what isolation the database is set to, but the answers are transaction isolation levels.

    Firstly, where is the isolation...

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/4/2009)


    That's an extremely old... and slow trick. The DATEADD/DATEDIFF method is quite a bit faster.

    That explains why I hadn't seen it before.

    Mangal presumably tells posters on MSDN...

  • RE: Are the posted questions getting worse?

    I skimmed over most of Mangal's blog posts and felt that there wasn't much there which I hadn't come across elsewhere. Nothing wrong with that really (although it hardly seems...

  • RE: Are the posted questions getting worse?

    GilaMonster (3/4/2009)


    Nobody requires that his posts be detailed (or even right?).

    Correct and helpful are required. I know I got asked for several forum posts where my answers helped someone

    Actually,...

Viewing 15 posts - 136 through 150 (of 479 total)