Forum Replies Created

Viewing 15 posts - 166 through 180 (of 381 total)

  • RE: date still showing up as YYYY-MM-DD

    winston Smith (8/26/2014)

    Finally, if it doesn't return what you expect, can you provide an online source which shows that what you are expecting to see isn't just a wish.

    if i...

    August 27, 2014 at 8:48 am

    #1741356

  • RE: Cannot view reports in Report Manager

    JohnPapa (8/27/2014)

    Many thanks Old Hand. It seems that we are getting warmer.

    I get what appears on RM6.png

    Any suggestions for changes.

    John

    The name is PhyData DBA, not Old Hand. Just as...

    August 27, 2014 at 8:42 am

    #1741349

  • RE: SQL Server 2008 r2?

    Ed Wagner (8/27/2014)

    Yes, the question is repeated, but the size of the varchar variable and the possible answers are different. The real difference is the unclear wording of the...

    August 27, 2014 at 8:13 am

    #1741341

  • RE: Cannot view reports in Report Manager

    JohnPapa (8/27/2014)

    It is a local user id. Everything is happening on a single pc right now. Will look into the authentication.

    Then check and change the Datasource on the SSRS server...

    August 27, 2014 at 8:11 am

    #1741340

  • RE: Cannot view reports in Report Manager

    You do not have access to the resource the Data Source is trying to connect to.

    Check the data source properties on the server and make sure the credentials they are...

    August 27, 2014 at 8:06 am

    #1741338

  • RE: SQL Server 2008 r2?

    I understand what you were going for, but the wording was way off.

    Do not ask "what happens" when the correct answers is "how to fix"

    "Useless code example in table...

    August 27, 2014 at 7:57 am

    #1741334

  • RE: Phantoms and isolation

    TomThomson (8/18/2014)

    PHYData DBA (8/18/2014)

    1. I got this question "wrong" selecting the "right" answers sent out in email the next day.

    How interesting. Must explain...

    August 19, 2014 at 2:22 pm

    #1739385

  • RE: Phantoms and isolation

    Hugo Kornelis (8/18/2014)

    PHYData DBA (8/18/2014)

    Or you could just do lots of testing to make sure using NOLOCK is not affecting your queries results adversely and move on.

    Why waste...

    August 19, 2014 at 2:18 pm

    #1739384

  • RE: Phantoms and isolation

    Hugo Kornelis (8/18/2014)

    Raghavendra Mudugal (8/18/2014)

    say we use nolock and it reads dirty and executes the select statement faster, now how to achieve the same speed without using nolock?

    That's the wrong...

    August 18, 2014 at 11:01 am

    #1738963

  • RE: Phantoms and isolation

    Going to be very honest about my opinions of this QOTD here.

    Some things are right and that is easy to notice on the surface.

    Some things are noticeably wrong because...

    August 18, 2014 at 9:41 am

    #1738921

  • RE: WMI Alerts

    I got it right!

    Choose TWO?!?!?!

    <looks at sky> STEVE!!!! <cries>

    August 8, 2014 at 7:09 am

    #1736395

  • RE: How to Create a Corrupt SQL Server Database

    Great article. It really highlights the concept of knowing how to break something so you can better learn how it can be fixed.

    August 8, 2014 at 7:05 am

    #1736392

  • RE: MAXDOP = 1 ?!

    Still Laughing.....

    Santa

    bwahahahahaha

    FYI - One of them has not... LeH

    July 18, 2014 at 9:08 am

    #1730663

  • RE: MAXDOP = 1 ?!

    Jeff Moden (7/18/2014)

    SQLRNNR (7/18/2014)

    Jeff Moden (7/17/2014)

    From what I've seen, Grant Fritchey's recommendations for changing the default threshold of parallelism are much more effective than changing the whole server to use...

    July 18, 2014 at 9:07 am

    #1730661

  • RE: MAXDOP = 1 ?!

    Everyone thank you for your replies.

    These are the exact same things we tried to explain prior to being sent the Quote in our original post.

    Needless to say we...

    July 17, 2014 at 12:16 pm

    #1730383

Viewing 15 posts - 166 through 180 (of 381 total)