Forum Replies Created

Viewing 15 posts - 11,611 through 11,625 (of 22,214 total)

  • RE: performance issue

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase...

    November 23, 2011 at 4:35 am

    #1412061

  • RE: Are the posted questions getting worse?

    Jim Murphy (11/22/2011)

    The other organizer of our SQLSaturday in Austin (#97) just compiled the speaker feedback evals. I came in 3rd overall! I'm pretty pleased since it was...

    November 23, 2011 at 4:30 am

    #1412060

  • RE: View Execution Plans

    Jack Corbett (11/22/2011)

    I haven't played with 2012 yet, but do the tabs float like in VS 2010 so you can have each tab on a separate monitor? That might...

    November 22, 2011 at 2:52 pm

    #1411859

  • RE: performance issue

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of the recompiles....

    November 22, 2011 at 2:27 pm

    #1411837

  • RE: View Execution Plans

    I'll either open two windows & bounce between them, or I'll open two instances of SSMS.

    SQL Sentry's Plan Explorer is worth checking out.

    November 22, 2011 at 2:26 pm

    #1411833

  • RE: performance issue

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of the recompiles....

    November 22, 2011 at 2:23 pm

    #1411830

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (11/22/2011)

    Kit G (11/22/2011)

    bitbucket-25253 (11/22/2011)

    Ah for real problems try Cleveland and its suburbs ... Columbus is pleasant compared to Clevland ...

    Cleveland... isn't that where people go when they die?...

    November 22, 2011 at 12:23 pm

    #1411747

  • RE: performance issue

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of the recompiles. Looks like...

    November 22, 2011 at 5:52 am

    #1411383

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/22/2011)

    What do you guys think of this as a first house?

    http://passerelle.centris.ca/Redirect2.aspx?CodeDest=I2V&NoMls=MT8619554&Source=

    Looks nice. Right off a lake, but still on the hill, so no flooding, cool.

    November 22, 2011 at 5:49 am

    #1411379

  • RE: Best 3rd party management tools?

    Sounds good. If you hit technical issues, you know where to find me.

    November 22, 2011 at 4:36 am

    #1411349

  • RE: Faster way to INSERT INTO large table

    You're comparing calculated values to calculated values. Indexes are no longer a part of the equation. It's nothing but scans. That's a guaranteed performance degradation as more and more rows...

    November 21, 2011 at 2:52 pm

    #1411066

  • RE: Are the posted questions getting worse?

    GilaMonster (11/21/2011)

    GSquared (11/21/2011)

    It must be DBA season somewhere.

    Open season on DBAs??? *fetches bow*

    *fetches rifle* And not the bolt-action one either.

    November 21, 2011 at 2:22 pm

    #1411048

  • RE: Where to start - Identify Performance Issue

    Gail's articles will get you started. When you need more, please consider my book (in the signature line).

    November 21, 2011 at 11:16 am

    #1410939

  • RE: Regarding sql server dba(queries)

    1 & 2 are in the Books Online.

    3. Yes. For more details see the Books Online.

    4. There is an error log associated with the Agent. You can get errors there...

    November 21, 2011 at 11:15 am

    #1410937

  • RE: Huge Differential Backup

    A differential is the sum total of all changes since the last full backup. When did you last take a full backup?

    November 21, 2011 at 11:14 am

    #1410934

Viewing 15 posts - 11,611 through 11,625 (of 22,214 total)