Forum Replies Created

Viewing 15 posts - 32,341 through 32,355 (of 49,552 total)

  • RE: dynamic/flexible query to filter records based on combination of user input (userid, status, fromdate and uptodate)

    Is there a question here?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 21, 2010 at 2:12 am

    #1182570

  • RE: The INSERT permission was denied on the object

    striker-baba (6/21/2010)

    And I am trying to insert data through a linked server from a remote test server into my prod server.

    It would have been useful if you'd mentioned that in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 21, 2010 at 2:10 am

    #1182569

  • RE: Insert,Update and delete triggers in sql server 2005

    In your update trigger you have a cross join between the inserted and deleted tables. You need to join them properly.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 21, 2010 at 2:09 am

    #1182568

  • RE: count(masterId), count(detail.ID) to produce master and detail counts in one single query

    Eugene Elutin (6/20/2010)

    Therefore, I may conclude that the 1/4 of the room (minus 1 person) from the mentioned TechEd presentation, were:

    a) Very old mens who still using punch cards and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 3:23 pm

    #1182523

  • RE: select statement

    You need three more REPLACE statements then, nested. One to replace the ( with an empty string '' and one to replace the ) with an empty string, then a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 12:29 pm

    #1182514

  • RE: select statement

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Is this homework?

    It looks like you have step...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 10:16 am

    #1182508

  • RE: The INSERT permission was denied on the object

    Are you calling a stored procedure or running ad-hoc insert statements?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 10:15 am

    #1182507

  • RE: The INSERT permission was denied on the object

    striker-baba (6/19/2010)

    Do you think the owner who created this table can avoid sysadmin to modify this table?

    No. Sysadmins bypass all permission checks, hence nothing can be denied to a sysadmin.

    What's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 9:35 am

    #1182504

  • RE: resore db

    Go to the options tab and change the location of the files for the newly restored DB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 8:33 am

    #1182500

  • RE: snapshort

    What information are you looking for?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 4:40 am

    #1182490

  • RE: snapshort

    Can you be more specific? There are at least 3 kinds of snapshots in SQL Server and I don't know which you're referring to.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 20, 2010 at 3:45 am

    #1182487

  • RE: count(masterId), count(detail.ID) to produce master and detail counts in one single query

    Eugene Elutin (6/19/2010)

    Contrary, I think most of the time, developers using hints, do know enough about them. So, in my experience, I found that "many people" use itto help performcance...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 19, 2010 at 12:52 pm

    #1182459

  • RE: Are the posted questions getting worse?

    Jeff/Lynn, I think this one's for you. http://www.sqlservercentral.com/Forums/Topic939955-169-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 19, 2010 at 12:22 pm

    #1182457

  • RE: SQL 2008 Cluster Resource Cannot come online - HELP!

    Is there anything useful in the SQL error log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 19, 2010 at 12:20 pm

    #1182456

  • RE: Are the posted questions getting worse?

    Talking about any thread in particular?

    edit: Nevermind. Found it and getting on my soapbox.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 19, 2010 at 12:19 pm

    #1182455

Viewing 15 posts - 32,341 through 32,355 (of 49,552 total)