Forum Replies Created

Viewing 15 posts - 586 through 600 (of 607 total)

  • RE: Auto Update Statistics

    Ninja's_RGR'us (7/25/2011)

    How many rows are getting updated by this?

    This doesn't sound like you're not changing anything...

    The query is to fix incorrect entries, and on this occassion there were no incorrect...

    July 25, 2011 at 6:22 am

    #1357716

  • RE: Auto Update Statistics

    Ninja's_RGR'us (7/25/2011)

    Sean Pearce (7/25/2011)

    ALZDBA (7/25/2011)

    hmm ... 08:30 ... now that really would be a coincidence, wouldn't it.

    Are you sure that hasn't been an sp_updatestats or so that got launched (e.g....

    July 25, 2011 at 6:06 am

    #1357703

  • RE: Auto Update Statistics

    ALZDBA (7/25/2011)

    hmm ... 08:30 ... now that really would be a coincidence, wouldn't it.

    Are you sure that hasn't been an sp_updatestats or so that got launched (e.g. using sqlagent) ?

    Did...

    July 25, 2011 at 5:49 am

    #1357699

  • RE: Why does SQL insist on a clustered index scan?

    Gianluca Sartori (6/22/2011)

    Just guessing: maybe the stats got updated automatically with a lower sample? I ran into this problem at times and decided to turn off stats recompute. You will...

    June 22, 2011 at 1:48 am

    #1342255

  • RE: Why does SQL insist on a clustered index scan?

    OK, so I found the problem last night. When I said the stats were up-to-date, I had only checked TBL_MASTER, the table performing the scan. However it turns out the...

    June 22, 2011 at 1:20 am

    #1342247

  • RE: Why does SQL insist on a clustered index scan?

    Lynn Pettis (6/21/2011)

    Remember clustered index scan == table scan.

    I'm actutely aware of that, hence the concern over this behaviour.

    Grant Fritchey (6/21/2011)

    The cluster is on ID but you're searching on DOCID....

    June 22, 2011 at 1:16 am

    #1342246

  • RE: We lost all our connection strings and credentials in our data sources

    Thank you, that is exactly what we missed.

    June 21, 2011 at 1:31 am

    #1341660

  • RE: logical_reads

    Ninja's_RGR'us (4/8/2011)

    Above removing the order by and checking the disks.

    Have you tried inserting intermediate results (for each join) to temp table? >> divide and conquer.

    That would also tell you what...

    April 8, 2011 at 8:39 am

    #1309219

  • RE: logical_reads

    Jason-299789 (4/8/2011)

    I would be tempted to rewrite the query as follows

    INSERT INTO ResultTable

    SELECT t.field1_varchar_255

    ...

    April 8, 2011 at 8:25 am

    #1309205

  • RE: logical_reads

    Results attached

    April 8, 2011 at 7:54 am

    #1309175

  • RE: logical_reads

    Ninja's_RGR'us (4/8/2011)

    Why are you using maxdop 1?

    Not sure. It's not my query and the developer came running to me to perform some magic trick :unsure:

    It's probably there due to multipe...

    April 8, 2011 at 7:37 am

    #1309163

  • RE: logical_reads

    Ninja's_RGR'us (4/8/2011)

    How many GBs of data arer you exporting to disk?

    Are you reading and writing on the same HD?

    I haven't reached the export yet. It is loading the result table...

    April 8, 2011 at 7:13 am

    #1309135

  • RE: logical_reads

    Ninja's_RGR'us (4/8/2011)

    What does the package do?

    Runs 4 procs then exports the data into text files. It is stuck on the 4th proc.

    It started at 08:00 (it's 14:45 now) and reads...

    April 8, 2011 at 6:47 am

    #1309107

  • RE: Poor database design

    GilaMonster (3/31/2011)

    Sean, next time it happens, if you're allowed to investigate, feel free to post specific questions and we'll see what we can help with.

    Thanks, I will definitely do that....

    April 4, 2011 at 1:26 am

    #1306867

  • RE: Poor database design

    crainlee2 (4/1/2011)

    Without knowing all of the details of your situation and the problems you are having, the one thing that stands out is that the larger the database grows, the...

    April 4, 2011 at 1:24 am

    #1306866

Viewing 15 posts - 586 through 600 (of 607 total)