Forum Replies Created

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

  • RE: Prevent users from impersonating sysadmin using runas /netonly

    Does your company have an IT security policy? If so, does it say anything about using other people's logins without their permission?

    Company I used to work for had such 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

    July 30, 2012 at 12:02 pm

    #1519338

  • RE: SQL Server 2008R2 using more memory

    Sqlism (7/30/2012)

    Does it reduce peroformance?

    Not unless you reduce it to a stupidly low value

    Is it is the only option to reduce memory?

    Is this is natural on a prod boc 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

    July 30, 2012 at 11:58 am

    #1519337

  • RE: How to repair the table

    slizam (7/30/2012)

    that is for the demo version only, it just for viewing & cannot take the data unless pay more for it 🙂

    Of course. And some don't work after you've...

    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

    July 30, 2012 at 10:53 am

    #1519304

  • RE: Subquery returned more than 1 value. This is not permitted

    erics44 (7/30/2012)

    nope trigger fixed

    And trigger developer educated?

    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

    July 30, 2012 at 9:47 am

    #1519250

  • RE: CURSOR as OUTPUT of the Stored Procedure.

    Ian Scarlett (7/30/2012)

    Grant Fritchey (7/30/2012)

    What the heck do you do with it?

    Beats the heck out of me!

    Encapsulate the definition of a cursor. Why you'd want to do that though is...

    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

    July 30, 2012 at 6:58 am

    #1519122

  • RE: Reducing Log File Size from 50GB

    Err, no. See the last suggestion I made re perfmon. Much easier than a scheduled job.

    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

    July 30, 2012 at 6:39 am

    #1519115

  • RE: Are the posted questions getting worse?

    The point is you do it once and check it. He checked and said that the row number does at the moment show the correct order. So you add that...

    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

    July 30, 2012 at 6:03 am

    #1519107

  • RE: Order without Order by

    vinu512 (7/30/2012)

    I am suggesting that the OP can Order the data according to whichever column he wants and then add the Row_Number().

    If he had a column to order by, that...

    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

    July 30, 2012 at 5:39 am

    #1519096

  • RE: Are the posted questions getting worse?

    ChrisM@Work (7/30/2012)

    GilaMonster (7/30/2012)

    ChrisM@Work (7/30/2012)

    Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady, Gail....

    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

    July 30, 2012 at 5:22 am

    #1519091

  • RE: Order without Order by

    vinu512 (7/30/2012)

    GilaMonster (7/30/2012)

    Try adding this as a column, and see if it orders 'correctly'. If so, try select into and see if it's still ordered 'correctly'

    ROW_NUMBER() OVER (ORDER BY (SELECT...

    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

    July 30, 2012 at 5:03 am

    #1519088

  • RE: Order without Order by

    danielfountain (7/30/2012)

    That works perfectly as far as i can see - thank you very much. Just need to work this into some code now.

    Ta

    Dan

    Just bear in mind that's 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

    July 30, 2012 at 5:02 am

    #1519086

  • RE: Are the posted questions getting worse?

    ChrisM@Work (7/30/2012)

    Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady, Gail. 😎

    Could...

    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

    July 30, 2012 at 5:00 am

    #1519084

  • RE: stored procedure - Command(s) completed successfully.

    exec [WageGenProcForSCons-2] 2

    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

    July 30, 2012 at 4:29 am

    #1519076

  • RE: Order without Order by

    Try adding this as a column, and see if it orders 'correctly'. If so, try select into and see if it's still ordered 'correctly'

    ROW_NUMBER() OVER (ORDER BY (SELECT 1)) As...

    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

    July 30, 2012 at 4:26 am

    #1519074

  • RE: NonClustered index vs Unique NonClustered Index

    SQL* (7/30/2012)

    I am not able to understand your point. can you explain little more?

    Explain what exactly?

    Do you have any references on this?

    Google will. Tipping point, key lookups.

    Also

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    July 30, 2012 at 4:20 am

    #1519071

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