Forum Replies Created

Viewing 15 posts - 41,776 through 41,790 (of 49,552 total)

  • RE: MSDB log file size is 17GB?????

    You can shrink it. I wouldn't do it to a minimum value, the log will probably have to grow again if you do.

    If you don't need or want point-in-time recovery...

    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 12, 2009 at 11:58 pm

    #925667

  • RE: Reorganize Index Task

    Please run the following query in that database. What does it return?

    SELECT count(*) from sys.objects

    where name = 'PK__EventStage__46AF6B36'

    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 12, 2009 at 11:55 pm

    #925666

  • RE: Backups

    Please don't create new threads for existing questions.

    http://www.sqlservercentral.com/Forums/Topic616604-357-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

    January 12, 2009 at 11:52 pm

    #925664

  • RE: is_cleanly_shutdown flag - sys.databases DMV

    Carlton Leach (1/12/2009)

    Hi Gail,

    so DB_2 (Status = normal) that has autoclose set to on will have to complete recovery operations the next time it is accessed?

    No, that one is...

    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 12, 2009 at 2:24 pm

    #925594

  • RE: procedure to auth password

    RJ (1/12/2009)

    I have a procedure to create wherein the parameters would be username & password. this password are already enrcryped in the database. so i would have to encrypt 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 12, 2009 at 2:21 pm

    #925590

  • RE: is_cleanly_shutdown flag - sys.databases DMV

    It means that the database has been closed and the when it was closed SQL was able to finish all transactions and write all dirty pages to disk. Hence no...

    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 12, 2009 at 2:11 pm

    #925579

  • RE: MDX QUERY

    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/Topic634841-17-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

    January 12, 2009 at 1:40 pm

    #925564

  • RE: MSDB log file size is 17GB?????

    The_SQL_DBA (1/12/2009)

    USE msdb

    SELECT TOP(30) OBJECT_NAME(object_id), rows

    FROM sys.partitions

    ORDER BY rows DESC

    How's that going to find what's filled the transaction log up?

    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 12, 2009 at 1:39 pm

    #925562

  • RE: MSDB log file size is 17GB?????

    SanjayAttray (1/12/2009)

    Instead you can put msdb, model and master database in simple recovery mode and take full backup every night.

    Just bear in mind that if you put Model into...

    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 12, 2009 at 1:36 pm

    #925560

  • RE: MSDB log file size is 17GB?????

    madhu.arda (1/12/2009)

    My concern is why MSDB log is grown to 17 GB overnight? what are things do I need to check to know what is the reason to increase 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

    January 12, 2009 at 1:32 pm

    #925554

  • RE: SORT in execution plan, but query doesnt have an order by

    What SQL's probably doing is a seek on index 1 that retrieves all the rows that match on first name, then a seek on index 2 to retrieve all 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

    January 12, 2009 at 1:27 pm

    #925543

  • RE: two indexes give exact same execution plan but optimizer always picks 1. why?

    Jean-François Bergeron (1/12/2009)

    From what I read in the plan, the only predicate it uses is the first Part : Like 'A/P%', how about the 's' that is after?

    There should 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

    January 12, 2009 at 1:00 pm

    #925520

  • RE: sp_who2 results show one spid 24 times

    Ariadne (1/12/2009)

    Gila: This is an OLTP system if that helps any. Found out the server have AMD 2-socket 4-core 2210 mhz processors resulting in 8 CPUs total.

    If it's OLTP then...

    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 12, 2009 at 12:52 pm

    #925506

  • RE: two indexes give exact same execution plan but optimizer always picks 1. why?

    Try it and see.

    If you have a table with an index on a string column, you run a query of that form and check the execution plan, you'll see exactly...

    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 12, 2009 at 9:35 am

    #925361

  • RE: Error: 7886, Severity: 20, State: 1.

    Jackal (1/12/2009)

    Thanks for the response, the SQL logs show the error occuring at 6.01pm

    Can you post the full message that was in the log?

    Anything in the windows event logs?

    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 12, 2009 at 9:26 am

    #925353

Viewing 15 posts - 41,776 through 41,790 (of 49,552 total)