Forum Replies Created

Viewing 15 posts - 29,641 through 29,655 (of 49,552 total)

  • RE: restrict log file size -sql server 2005

    Sandesh Segu (10/30/2010)

    Remove auto grow option. This will restrict the Log file growth.

    However if you do that and the log runs out of space, the database will go readonly until...

    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

    October 30, 2010 at 10:54 am

    #1244554

  • RE: use log file

    Grant Fritchey (10/30/2010)

    The default trace does not store data manipulation calls. In order to track those you'll have to create your own server side trace.

    Or put triggers on the tables...

    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

    October 30, 2010 at 10:50 am

    #1244553

  • RE: restrict log file size -sql server 2005

    Please read through this - Managing Transaction Logs[/url]

    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

    October 30, 2010 at 10:37 am

    #1244552

  • RE: SQL Server Breaks down for every 10mins

    Just from the error log, there's a number of configuration and maintenance problems on this server.

    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

    October 30, 2010 at 9:08 am

    #1244541

  • RE: SQL Server Breaks down for every 10mins

    Jeff Moden (10/30/2010)

    GilaMonster (10/29/2010)

    p.s. The last integrity check of any of these databases was almost 2 years ago. You like living dangerously?

    That actually brings up a good subject. Do...

    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

    October 30, 2010 at 8:22 am

    #1244533

  • RE: Clustered Index and Striping

    The clustered index enforces logical ordering, not physical.

    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

    October 30, 2010 at 3:17 am

    #1244508

  • RE: Update Stat=Is it helpful to run update_stat after restoring the database to different server

    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/Topic1013402-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

    October 30, 2010 at 3:16 am

    #1244507

  • RE: select a record based on a time range

    drew.allen (10/29/2010)

    I'm curious about why you used minutes rather than hours for the calculations.

    Because I initially misread the requirements and though he wanted from 2:30 to 3. Given 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

    October 30, 2010 at 3:14 am

    #1244506

  • RE: select a record based on a time range

    Why does that 'obviously not work'? It's almost what you want.

    DECLARE @date1 DATETIME

    DECLARE @date2 DATETIME

    SET @date1 = DATEADD(mi, 120, DATEADD(dd,0,DATEDIFF(dd,0,GETDATE())-1)) -- yesterday at 2:00 am

    SET @date2 = DATEADD(mi,60,@date1)

    SELECT ...

    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

    October 29, 2010 at 3:06 pm

    #1244445

  • RE: Sr level interview questions

    Alvin Ramard (10/29/2010)

    I've seen someone score 4/10 in an interview for a DBA position. All the questions were either based on something in his resume, or based on 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

    October 29, 2010 at 2:51 pm

    #1244437

  • RE: 1 database in a server can't be opened

    pavan_srirangam (10/29/2010)

    May you don't have the permission to that particular database.

    Lack of SQL permissions would not cause this. This is an error from SQL saying that it cannot, for some...

    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

    October 29, 2010 at 2:46 pm

    #1244435

  • RE: SQL Server Breaks down for every 10mins

    p.s. The last integrity check of any of these databases was almost 2 years ago. You like living dangerously?

    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

    October 29, 2010 at 2:35 pm

    #1244427

  • RE: SQL Server Breaks down for every 10mins

    pinnamaneni.pavani (10/29/2010)

    2010-10-28 11:49:21.80 spid11s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.

    It's not...

    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

    October 29, 2010 at 2:30 pm

    #1244423

  • RE: How to Kill 000-105 test?

    cppwiz (10/29/2010)

    Why would anyone would post on a SQL Server forum about passing an IBM AIX exam? :crazy: :blink: :ermm:

    I suspect it has to do with a whole bunch...

    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

    October 29, 2010 at 2:05 pm

    #1244410

  • RE: Sr level interview questions

    Michael Valentine Jones (10/29/2010)

    You come to work in the morning to find that all the disks in the SAN cabinet were destroyed by a direct lightning hit and none of...

    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

    October 29, 2010 at 2:04 pm

    #1244409

Viewing 15 posts - 29,641 through 29,655 (of 49,552 total)