Forum Replies Created

Viewing 15 posts - 19,366 through 19,380 (of 49,552 total)

  • RE: How to access sysobjects information through a non admin user

    Ok, what must the user be allowed to do and what must the user not be allowed to do?

    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

    April 4, 2012 at 7:50 am

    #1468862

  • RE: How to access sysobjects information through a non admin user

    capn.hector (4/4/2012)

    GilaMonster (4/4/2012)

    The answer is grant view definition to that user. Why is that not an option here?

    p.s. sysobjects is deprecated, should not be used any longer, included only 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

    April 4, 2012 at 7:49 am

    #1468861

  • RE: Are the posted questions getting worse?

    A new misspelling for my records...

    Thank you Linn and Gylla

    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

    April 4, 2012 at 7:44 am

    #1468853

  • RE: How to access sysobjects information through a non admin user

    The answer is grant view definition to that user. Why is that not an option here?

    p.s. sysobjects is deprecated, should not be used any longer, included only for backward compatibility...

    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

    April 4, 2012 at 7:32 am

    #1468839

  • RE: CASE WHEN LEFT(...) Pretty please - why isn't this working?

    Define 'not working'?

    Throwing an error?

    Doing something unexpected (if so what is it doing and what should it be doing)?

    Converting the server to a black hole?

    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

    April 4, 2012 at 7:30 am

    #1468836

  • RE: SQL SERVER WEIRD Performance problem. Please help.

    bullo (4/3/2012)

    Because the nature of the page and its options I need to make individual queries.

    Why?

    That kind of code is not going to perform well on SQL.

    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

    April 4, 2012 at 7:26 am

    #1468829

  • RE: Transaction log size and # records in table (via properties window)

    Assuming that the record count is pulled from sys.partitions, it is only supposed to be transactionally consistent, not necessarily correct during a transaction.

    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

    April 4, 2012 at 7:24 am

    #1468824

  • RE: Impact of dropping a clustered index

    anthony.green (4/4/2012)

    Please correct me if I'm wrong, but when there is a column which is required in the result set which is not an included column, the non-clustered index will...

    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

    April 4, 2012 at 5:11 am

    #1468745

  • RE: Improved performance of restore process

    Highly unlikely.

    If it's running at a different time of the day it could be that the disk and network are under less load.

    Backup and restore time are principally governed by...

    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

    April 4, 2012 at 5:06 am

    #1468736

  • RE: Impact of dropping a clustered index

    sqldba4u (4/4/2012)

    I tested on a table. Dropping clustered index doesn't impact data.

    Of course it won't. Clustered index is just about organisation of data. Dropping or creating indexes can't change the...

    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

    April 4, 2012 at 5:03 am

    #1468732

  • RE: Impact of dropping a clustered index

    anthony.green (4/4/2012)

    queries will cause table scans

    Not necessarily. Nonclustered indexes can still be used for seek operations

    non clustered indexes will cause a lookup scan

    Lookup scan?

    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

    April 4, 2012 at 5:02 am

    #1468730

  • RE: Can't Restore Differential Backup

    dpollard 96305 (4/4/2012)

    I'll leave the ShadowProtect backup running as it is and do full SQL backups hourly.

    I'll continue with the transaction log backup every 10 minutes.

    As you say it 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

    April 4, 2012 at 1:06 am

    #1468655

  • RE: Database only backups when compression is off.

    Post the errors please?

    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

    April 4, 2012 at 12:54 am

    #1468651

  • RE: SQL jobs Dead Locks Issue

    Evil Kraig F (4/3/2012)

    That graph looks incomplete. It's almost all SPID 25, so unless it's deadlocking itself, that won't fly well.

    SPID 25 is the system spid responsible for writing...

    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

    April 4, 2012 at 12:47 am

    #1468649

  • RE: Can't Restore Differential Backup

    I was asleep when you posted the first comment about Shadow protect or I could have told you that. (not used that product, just from general experience)

    The VSS-type backups reset...

    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

    April 4, 2012 at 12:44 am

    #1468647

Viewing 15 posts - 19,366 through 19,380 (of 49,552 total)