Forum Replies Created

Viewing 15 posts - 181 through 195 (of 380 total)

  • RE: MAXDOP = 1 ?!

    arfeenmalik (7/17/2014)

    Simple Answer :

    If the system is running well without any performance issues, then there is no need to go around changing settings. However, you will need to continually monitor...

    July 17, 2014 at 10:24 am

    #1730348

  • RE: MAXDOP = 1 ?!

    GilaMonster (7/17/2014)

    PHYData DBA (7/17/2014)

    SQLRNR - Well when I mentioned that the maxdop = 1 setting is good for pure OLTP issues where the CXPACKET waits are high.

    Not even...

    July 17, 2014 at 10:18 am

    #1730340

  • RE: SSRS report returning incorrect results on first run

    SQLRNNR (7/17/2014)

    Is there something else other than a select statement in that proc? Trying to gauge if nolock is used in the proc at all.

    And back to Jacks question...

    July 17, 2014 at 9:38 am

    #1730331

  • RE: SSRS report returning incorrect results on first run

    DataTrim (7/17/2014)

    Hi

    The WITH (NOLOCK) hint isn't being used in the SELECT statement.

    Regards

    Mark

    Okay... ummmm.... Was this a test? Are you making a confession? Are you saying that you tried this with...

    July 17, 2014 at 9:28 am

    #1730326

  • RE: SSRS report returning incorrect results on first run

    DataTrim (7/17/2014)

    Hi

    I have a parametised SSRS report that when is first run it returns incorrect results (i.e. number of rows and grand total of a value column aren't correct). ...

    July 17, 2014 at 9:27 am

    #1730325

  • RE: MAXDOP = 1 ?!

    We smiled and waved, they literaly bit the waving hand.

    Then after showing them some information from Paul Randal, and from some Issues with a WellPoint Datawarehouse.

    They asked us who is...

    July 17, 2014 at 9:00 am

    #1730306

  • RE: MAXDOP = 1 ?!

    SQLRNNR (7/17/2014)

    That's great for the vendor. But that is an apples to oranges comparison coming from them.

    Is the workload high OLTP? Or do you have you noticed parallelism...

    July 17, 2014 at 8:49 am

    #1730291

  • RE: Force Parameterized Queries vs Missing Indexes

    Andrew Kernodle (7/16/2014)

    Hrm. I wouldn't think that enabling forced parameterization would fix a table scanning issue; from my understanding, that helps in cases where your workload is almost entirely...

    July 16, 2014 at 10:33 am

    #1729938

  • RE: Checking the Performance of my SQL Server 2008 R2

    bubby (7/16/2014)

    Thanks,

    I would I see if my SQL is optimized,

    No you wont see optimized SQL here.

    You will see if your SQL is causing problem.

    Seeing if it...

    July 16, 2014 at 10:20 am

    #1729929

  • RE: Checking the Performance of my SQL Server 2008 R2

    In activity monitor, select recent expensive queries. Do you see any of your SQL there?

    July 16, 2014 at 8:58 am

    #1729888

  • RE: Paying It Forward

    vliet (7/9/2014)

    It would be nice if you had asked that DBA why he was worried about others stealing his ideas. If you're working in an environment where others frequently show...

    July 9, 2014 at 1:31 pm

    #1728201

  • RE: Paying It Forward

    batgirl (7/9/2014)

    I owe any/all success that I have had in the IT field to my ability to "look stuff up"

    the.end.

    Bravo! Seriously! I would give anything to work more with...

    July 9, 2014 at 9:18 am

    #1728113

  • RE: Paying It Forward

    I could care less about someone stealing my ideas. However there are those out there that treat abuse the community like many abuse Welfare or Food stamps.

    Just yesterday...

    July 9, 2014 at 7:37 am

    #1728044

  • RE: Status and Name Please

    TomThomson (6/11/2014)

    I guess you looked at the wrong...

    Tom. You are right.

    My I was in a rush to take back my nega post yesterday about it really being there.

    This even...

    June 12, 2014 at 6:58 am

    #1721050

  • RE: Status and Name Please

    Andy Warren (6/11/2014)

    PhyData, I take your point on that, I wish I had found a better reference for the answer. Shift F1 probably relevant more for QOTD than real life?...

    June 11, 2014 at 10:45 am

    #1720828

Viewing 15 posts - 181 through 195 (of 380 total)