Forum Replies Created

Viewing 15 posts - 20,296 through 20,310 (of 49,552 total)

  • RE: how to find when the SQL server Last started?

    Login date of any of the system processes (session_id 1 is easy enough)

    Creation date_time of TempDB

    There are others, but those are among the easiest (and work on all current versions...

    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

    February 15, 2012 at 12:09 pm

    #1447478

  • RE: sys.dm_dm_missing_index ...

    It's a great place to start, but a terrible place to finish. Treat them as suggestions that need investigating, analysing and testing, not as a 'you must create these' list.

    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

    February 15, 2012 at 11:33 am

    #1447462

  • RE: Upgrading Your Career

    Brent Ozar (2/15/2012)

    Robert Davis (2/15/2012)

    If you feel otherwise please point these alleged brain dumps out.

    Here's everything you need to know to pass the MCM lab:

    Drop all the primary keys.

    Then just...

    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

    February 15, 2012 at 10:29 am

    #1447427

  • RE: Tracing a Deadlock

    Easiest way to find the location of the error log file is to open the log from Management Studio (object explorer. Management -> SQL Server Logs)and check right at 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

    February 15, 2012 at 9:49 am

    #1447393

  • RE: Deadlock Trace Issue

    Would it be possible for you to post the entire errorlog?

    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

    February 15, 2012 at 9:22 am

    #1447370

  • RE: Tracing a Deadlock

    So there's nothing in the error log? Are you looking at the right instance (if you have multiple instances)?

    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

    February 15, 2012 at 9:21 am

    #1447369

  • RE: Logs Not TRUNCATING SQL 2008R2

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    February 15, 2012 at 9:20 am

    #1447368

  • RE: 2 date queries and binding togthter to one

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1252488-392-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

    February 15, 2012 at 8:05 am

    #1447336

  • RE: Page Life Expectancy

    If PLE is 300 (5 min) it essentially means that the entire data cache is getting replaced in 5 minutes. Ok if you have maybe 1 GB memory, not OK...

    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

    February 15, 2012 at 7:51 am

    #1447326

  • RE: when i check the database with following command DBCC CHECKDB(checkerpdatabase) WITH NO_INFOMSGS,these below error occured what i do ????????????????

    Then the errors you have are not repairable.

    The only solution now is to recreate the database. Script all of the objects in the DB, export all data (there's a chance...

    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

    February 15, 2012 at 5:11 am

    #1447271

  • RE: Convert minutes to HH:MM:SS format

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

    February 15, 2012 at 4:38 am

    #1447259

  • RE: Dropping Image column

    paul.knibbs (2/15/2012)

    Interesting stuff...so even if the NULL bitmap should theoretically grow to accommodate a new column, it won't until some data is actually put into the specified record?

    Until the row...

    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

    February 15, 2012 at 4:35 am

    #1447256

  • RE: Is it possible to reduce retrieval time when using select * from [table]

    Wicked (2/15/2012)

    I'll try to group them into files

    I wouldn't recommend that unless you intend to spend days at the least designing the file layout based on data usage, query design...

    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

    February 15, 2012 at 4:33 am

    #1447255

  • RE: when i check the database with following command DBCC CHECKDB(checkerpdatabase) WITH NO_INFOMSGS,these below error occured what i do ????????????????

    That was with REPAIR_ALLOW_DATA_LOSS?

    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

    February 15, 2012 at 4:32 am

    #1447254

  • RE: when i check the database with following command DBCC CHECKDB(checkerpdatabase) WITH NO_INFOMSGS,these below error occured what i do ????????????????

    ahsan_mustafa33 (2/15/2012)

    i have no problem with loosing data from database i want to recovered my database

    when i run the following command which you provide

    DBCC CHECKDB ('checkerpdatabase' ,REPAIR_REBUILD)

    I did...

    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

    February 15, 2012 at 3:55 am

    #1447237

Viewing 15 posts - 20,296 through 20,310 (of 49,552 total)