Forum Replies Created

Viewing 15 posts - 43,261 through 43,275 (of 49,552 total)

  • RE: database 'master' is not valid 9003 error Help!!!

    Does the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG" exist? Is it readable?

    Do you have a backup of the master database?

    Can you do a check of the C drive? It looks like...

    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

    November 8, 2008 at 2:26 pm

    #895988

  • RE: Are Triggers a "legacy" Feature? (Database Weekly, Nov 08 2008)

    Triggers have uses, but I'm not sure that business logic is a good one.

    For me, auditing is the main use. In 2008 Change data capture and change data tracking can...

    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

    November 8, 2008 at 6:19 am

    #895948

  • RE: Creative SPAM

    I had one of those investment-type spams that made me laugh because of the coincidence in it.

    It started

    "Since you are not a client of XYZ bank ..." with XYZ bank...

    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

    November 8, 2008 at 6:03 am

    #895946

  • RE: More Information About SQL Server 2005 DMVs

    Chad Churchwell (11/7/2008)

    I use sys.dm_db_index_usage_stats to find obselete indexes that have not been accessed and are unneeded overhead in the database.

    I also use sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_details to identofy indexes 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

    November 8, 2008 at 5:04 am

    #895945

  • RE: "Locking" issues

    Barkingdog (11/6/2008)

    From the user's perspective their application appears to stop functioning until we use sp_who2 to find the user causing the block and ask that user to close the open...

    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

    November 8, 2008 at 4:54 am

    #895944

  • RE: RESIZE THE NDF FILE

    Look up ALTER DATABASE in books online. It will be one of the Modify File options.

    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

    November 8, 2008 at 4:48 am

    #895943

  • RE: I can't drop a database, please help

    onlo (11/6/2008)

    It always said some bodies in use, but sp_who2 told me nobody was holding this db.

    ALTER DATABASE < DB name > SET OFFLINE WITH ROLLBACK IMMEDIATE

    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

    November 8, 2008 at 4:47 am

    #895942

  • RE: Re: Interpreting results for SET STATISTICS IO

    The (unexpected) answer is both.

    Physical and readahead reads are physical IOs, ie they are reads from the physical disk. Logical reads are reads from memory.

    So, your second query required more...

    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

    November 8, 2008 at 4:43 am

    #895940

  • RE: Help with interview questions for a DBA position

    That's a wide-open question

    SQL not running

    SQL running but no accepting connections

    Database corruption

    Backup failures

    Drive failure (data file, log file or both)

    User deleted data accidentally

    Deadlocks

    Query running yesterday, giving error today

    ... etc

    If you...

    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

    November 8, 2008 at 4:35 am

    #895938

  • RE: Rescue me please!!!

    Jeffrey Williams (11/7/2008)

    Another option (which will require a downtime) is to:

    1) Perform a transaction log backup (tail log)

    Assuming the DB is in full/bulk logged and there is a 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

    November 8, 2008 at 4:32 am

    #895937

  • RE: Maximum stored procedure, function, trigger or view nesting level exceeded (Level 32)

    ajaykini (11/7/2008)

    Lynn:

    Thank you for your understanding and patience.

    I hope i am now on the right track to receive your valuable advise to resolve the problem.

    Almost. For the sample data you...

    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

    November 8, 2008 at 4:28 am

    #895936

  • RE: Problem with decryption

    Terri (11/7/2008)

    Wouldn't using views or stored procedures solve the problem of the jr HR person. In our shop we never give access to base tables. Either we 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

    November 8, 2008 at 4:27 am

    #895935

  • RE: Divide by zero error encountered

    ramadesai108 (11/7/2008)

    My question is: if t.SoldYR2 is greater than t.SoldYR1 (which

    means t.SoldYR2 has to be at least greater than zero). If it is greater than zero, then it cannot be...

    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

    November 8, 2008 at 3:34 am

    #895931

  • RE: transaction logs

    noeld (11/6/2008)

    BACKUP LOG [AdventureWorks] WITH NO_LOG

    FYI: This operation is deprecated

    So is Backup log with truncate only and both have been completely removed in SQL 2008.

    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

    November 8, 2008 at 3:25 am

    #895930

  • RE: Divide by zero error encountered

    rosh (11/6/2008)

    Would null values cause this.

    See if ISNULL helps.

    Null won't cause a divide by zero. Anything divided by null (or added to null or multiplied by null, ...) is null....

    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

    November 8, 2008 at 3:24 am

    #895929

Viewing 15 posts - 43,261 through 43,275 (of 49,552 total)