Forum Replies Created

Viewing 15 posts - 35,566 through 35,580 (of 49,552 total)

  • RE: SQL server shuts down randomly

    Roland Allgayer (12/1/2009)

    12/01/2009 07:21:56,spid67,Unknown,Server shut down by NOWAIT request from login sa.

    Looks like the shutdown was requested by someone.

    Basically, someone logged in as sa ran this

    SHUTDOWN WITH NOWAIT

    Is this...

    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 1, 2009 at 9:53 am

    #1085931

  • RE: SQL server shuts down randomly

    That doesn't look like a SQL Server error log. It looks like the SQL Agent error log, the reference to idle CPU condition is something that'll only appear in agent....

    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 1, 2009 at 9:31 am

    #1085910

  • RE: Problem with indexes

    Easiest way to get the execution plans is simply to run the queries manually. Question is whether or not they'll generate identical plans to the ones the app runs. If...

    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 1, 2009 at 9:27 am

    #1085903

  • RE: Problem with indexes

    It doesn't suggest anything about the index maintenance. It does possibly indicate stale stats, but they shouldn't get stale that fast. How big's the table, how fast are you inserting...

    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 1, 2009 at 8:16 am

    #1085842

  • RE: Calculating Times in Stored Procedure

    But surely 02/12/09 7:00AM is bigger than 01/12/2009 23:30PM

    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 1, 2009 at 7:54 am

    #1085822

  • RE: shrinking a datafile file

    Alter Index

    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 1, 2009 at 7:53 am

    #1085820

  • RE: Can AUTOSHRINK result in deadlocks?

    muthukkumaran (12/1/2009)

    U can use this query also

    select * from sys.sysprocesses where blocked <> 0

    Sysprocesses is deprecated and should not be used in new development. It will be removed in 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

    December 1, 2009 at 7:52 am

    #1085819

  • RE: shrinking a datafile file

    So there's only 9 MB free in a 51 GB database. Definitely not worth a shrink.

    If you rebuild all the indexes on the table that you deleted rows 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

    December 1, 2009 at 7:39 am

    #1085803

  • RE: Problem with indexes

    Sounds like a parameter sniffing problem, not a statistics problem. The stats update would fix things, because it forces plans to recompile.

    Can you post the stored procs that are used...

    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 1, 2009 at 7:31 am

    #1085789

  • RE: Can AUTOSHRINK result in deadlocks?

    chris.worthington (12/1/2009)

    2). From the majority of postings I've read, the recommendation is to have AUTOSHRINK switched off and replaced by scheduled DBCC SHRINK commands instead. Is that a fair representation...

    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 1, 2009 at 7:25 am

    #1085784

  • RE: Log File runing.... Disk out of space

    atramard (12/1/2009)

    Ie you get a Disk out of space allert what can you do to sort the server out once youve:

    - shrink any file you can

    - move DB's...

    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 1, 2009 at 7:19 am

    #1085777

  • RE: Calculating Times in Stored Procedure

    nialltuohy (12/1/2009)

    What I have is a TBL_AUDIT_ID, the table definition and sample data is below, I've attached an image of the data in my TBL_AUDIT_ID aswell.

    I'm guessing that you haven't...

    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 1, 2009 at 7:15 am

    #1085773

  • RE: SQL server 2005 not compatible with access 2007

    How did you try the import?

    There are several Access-SQL 'upsize wizards' on the MS site. Have you tried those?

    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 30, 2009 at 9:30 pm

    #1085636

  • RE: Log File runing.... Disk out of space

    RCC-JAXDBA (11/30/2009)

    Also, be careful of truncating log files (backup log XXX with truncate_only) in a production environment if you are running tran log backups as this will interrupt the log...

    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 30, 2009 at 9:28 pm

    #1085635

  • RE: Log File runing.... Disk out of space

    atramard (11/30/2009)

    Detached the Db to delete the log ..... nothing worked

    Do not delete the transaction log unless you're comfortable with the chance of getting a suspect and unusable database afterwards.

    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 30, 2009 at 9:24 pm

    #1085632

Viewing 15 posts - 35,566 through 35,580 (of 49,552 total)