Forum Replies Created

Viewing 15 posts - 42,001 through 42,015 (of 49,552 total)

  • RE: Login Failure issue - SQL Server 2008 on Windows Server 2008

    John Marsh (1/4/2009)

    Hello,

    Was there not a “State: NN” part to the Error Message? The value for State is important in determining the exact reason for Logon failure.

    State'll be in 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

    January 4, 2009 at 4:06 am

    #920838

  • RE: Nested cursor

    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/

    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

    January 4, 2009 at 3:38 am

    #920837

  • RE: upgrade to 2005 or 2008?

    george sibbald (1/3/2009)

    Off the top of my head a possibility is leave the existing 2005 servers where they are and just upgrade the 2000 servers to 2008, to spread 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

    January 4, 2009 at 3:36 am

    #920836

  • RE: [Newbie] Trigger doesn't work

    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/

    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

    January 4, 2009 at 2:48 am

    #920834

  • RE: Transaction log grows fast

    iqtedar (1/3/2009)

    but wat should he do if he needs to reduce the log file size..thanks in advance and wish you all a very happy and prosperous new year..thanks

    A once off...

    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

    January 4, 2009 at 2:35 am

    #920833

  • RE: Issues detected by SQL BPA

    madhu.arda (1/3/2009)

    I observed that the backups are placed on D, E,F like 4 months ago. But as I know from last 3 months the backups are going to Z 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

    January 4, 2009 at 2:29 am

    #920832

  • RE: Issues detected by SQL BPA

    It could be that someone's done an adhoc backup to a drive other than Z. Use the following to see the backup history.

    select * from msdb..backupmediafamily

    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

    January 3, 2009 at 12:11 pm

    #920739

  • RE: Select statements included within a function cannot return data to a client

    waykna (1/3/2009)

    I omitted the ORDER BY, given that there's an index on the two PK fields being selected.

    An index is not a guarantee of the order of the data returned....

    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

    January 3, 2009 at 11:17 am

    #920730

  • RE: sql server performance issue

    I finally managed to get everything working again, and have a look at your procs. There's a few things I noticed that could be potential problems.

    fnGetTerrTree_2:

    FROM Users

    CROSS APPLY (

    SELECT v.TerriId

    FROM...

    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

    January 3, 2009 at 9:59 am

    #920705

  • RE: like operator problem

    ColumnName LIKE '%/%' ESCAPE '/'

    With a character defined as an escape character, any character that follows that in the LIKE will be treated as a literal value.

    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

    January 3, 2009 at 9:51 am

    #920701

  • RE: prevent clients to retrieve information_schema and sys metadata

    Roy Matthews (1/2/2009)

    I'm getting the same problem. What is the solution to this?

    All data access via stored procedures, grant only execute permissions on the procs and no 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

    January 3, 2009 at 7:48 am

    #920686

  • RE: Please help with tuning, its taking infinity time to run

    RBarryYoung (1/2/2009)

    Can you show us the execution plan?

    Additionally, the schema of the tables and the index definitions would be of great help.

    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

    January 3, 2009 at 7:44 am

    #920684

  • RE: How to resolve "It is in the middle of a restore" error?

    thuybui (1/2/2009)

    A database is in "It is in the middle of a restore" state. How do I release that state for that database? Thanks.

    What did you do to get it...

    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

    January 3, 2009 at 7:37 am

    #920682

  • RE: Indexes getting fragmented very frequently

    Is autoshrink on for that database?

    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

    January 3, 2009 at 7:34 am

    #920681

  • RE: Reorganization

    Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in 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

    January 3, 2009 at 7:31 am

    #920680

Viewing 15 posts - 42,001 through 42,015 (of 49,552 total)