Forum Replies Created

Viewing 15 posts - 35,176 through 35,190 (of 49,552 total)

  • RE: index filter

    The error's pretty clear.

    Resubmit the query without specifying any hints and without using SET FORCEPLAN.

    You're telling the optimiser to use a particular index that it absolutely cannot use to run...

    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

    December 21, 2009 at 3:37 am

    #1094652

  • RE: Invalid column name error

    GilaMonster (12/21/2009)

    What do you get when you do a syntax check on it. Exact error 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

    December 21, 2009 at 3:34 am

    #1094648

  • RE: Invalid column name error

    What do you get when you do a syntax check on it. Exact error please.

    As an aside, I see lots of nolock. Do you know what that really does? See...

    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

    December 21, 2009 at 3:22 am

    #1094643

  • RE: System table permission

    The error message explicitly states that you cannot assign a permission to yourself. If you're logged in as a particular user you cannot grant a permission to that user. Furthermore,...

    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

    December 21, 2009 at 3:06 am

    #1094641

  • RE: Backup and insert

    How are you doing the backup? What's the 'insertion process' actually doing? What's the error that you're getting?

    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

    December 21, 2009 at 2:54 am

    #1094636

  • RE: index filter

    You mean an index hint "WITH (INDEX = ...)"?

    If so, you do it in an inner join the same way as your example. The hint immediately follows the table.

    That said,...

    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

    December 21, 2009 at 2:52 am

    #1094634

  • RE: unable to access drive

    Is the drive there and is it accessible through Windows?

    Does the SQL service account have sufficient permissions to write backups to that drive?

    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

    December 21, 2009 at 2:51 am

    #1094633

  • RE: System table permission

    Are you currently logged in as 'User'? Is the table owned by 'User'?

    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

    December 21, 2009 at 2:46 am

    #1094631

  • RE: Error while accessign the database

    Are those logins correctly mapped to the users in the database?

    If you just created new logins on the server it's highly unlikely that they won't be. Look up 'orphaned users'...

    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

    December 21, 2009 at 1:12 am

    #1094608

  • RE: index filter

    Sorry, I don't understand your question. Can you explain in more detail please? Possibly include the queries and table/index definitions?

    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

    December 21, 2009 at 1:10 am

    #1094607

  • RE: unable to access drive

    Is the drive still there? (is it accessible through windows)

    Is it a clustered SQL Server instance?

    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

    December 21, 2009 at 1:08 am

    #1094605

  • RE: How to repeat one Table/Cell data in each page

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic836978-150-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

    December 21, 2009 at 1:07 am

    #1094604

  • RE: System table permission

    How exactly are you trying to grant permission? What's the script?

    You don't need to explicitly grant permissions to a database owner or sysadmin. By default they have full rights 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

    December 21, 2009 at 1:07 am

    #1094602

  • RE: Cannot shrink log file 2 (LOG FILE) because all logical log files are in use.

    Ivanna Noh (12/20/2009)

    jI have no idea what would be using the log file in the middle of the night - certainly no other scheduled jobs. The database is mirrorred so...

    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

    December 21, 2009 at 1:04 am

    #1094601

  • RE: Are the posted questions getting worse?

    mike_walsh (12/20/2009)

    My add-on thought to the idea that Aaron and Brent came up with is to tweet questions from RSS feeds from forums like this and sites like StackOverflow/ServerFault/MSDN Forums/etc....

    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

    December 21, 2009 at 1:03 am

    #1094599

Viewing 15 posts - 35,176 through 35,190 (of 49,552 total)