Forum Replies Created

Viewing 15 posts - 44,416 through 44,430 (of 49,552 total)

  • RE: DELETE statement is causing log size full

    vyas (9/18/2008)

    If your recovery mode is full/bulk logged the

    Before deleting record set database to simple mode

    And after deletion is over

    set database to full/bulk logged.

    And do 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

    September 18, 2008 at 6:54 am

    #873571

  • RE: DELETE statement is causing log size full

    That will help if the delete is batched and a checkpoint is run between batches. If the deletes are happening all in one transaction, then the log will still run...

    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

    September 18, 2008 at 6:53 am

    #873570

  • RE: SQL Server 2005 SP_autostats

    Is the table owned by dbo, or another user?

    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

    September 18, 2008 at 6:51 am

    #873566

  • RE: Database 'msdb' cannot be opened

    Via T-SQL or through management studio GUI? If the latter, try it via T-SQL. Management studio may be trying to query the DB before starting the restore.

    If via T-SQL, what'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

    September 18, 2008 at 5:56 am

    #873530

  • RE: Question on 2008 BI Beta Exam: 71-452

    Peter Rijs (9/18/2008)

    To my surprise the exam only consisted of single questions, where the SQL 2005 exam had most case studies.

    I'm not sure what is better, as the questions sometimes...

    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

    September 18, 2008 at 5:52 am

    #873528

  • RE: Data storage for bigint datatype..

    According to BoL

    2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

    So, no it will not store 9223372036854775808, as that's 1 higher than the max value allowed.

    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

    September 18, 2008 at 5:49 am

    #873524

  • RE: Interesting ERROR inINSERT Trigger

    Bert's 100% right with the cause. inserted and deleted are only visible in the scope of the trigger, not any procedures called from it or dynamic SQL.

    You have another problem...

    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

    September 18, 2008 at 5:46 am

    #873522

  • RE: RE Starting MSSQLSERVER

    Check the SQL Server error log, see what it says. There should be reasons written into the log saying why things failed.

    The log's just a text file and it's named...

    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

    September 18, 2008 at 5:41 am

    #873517

  • RE: Problem with encryption

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

    No more replies to this thread please. Direct replies to:

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

    September 18, 2008 at 4:44 am

    #873487

  • RE: Problem with encryption

    Please run the following and post the results:

    SELECT @@Version

    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

    September 18, 2008 at 4:42 am

    #873486

  • RE: SQL 2008

    Filestream requires that there's a column in the table or type ROWGUIDCOL. The rest of the table (as far as I know) doesn't matter.

    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

    September 18, 2008 at 4:40 am

    #873483

  • RE: Huge memory using in sqlservr.exe

    You can set the max memory for SQL under the server properties. If you don't set that, SQL will take as much memory as it 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

    September 18, 2008 at 4:39 am

    #873482

  • RE: SQL 2008

    Duplicate post. No replies to this thread please.

    Replies to:

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

    September 18, 2008 at 4:36 am

    #873480

  • RE: How to Identify in how many Storedprocedures hasa sp been called?

    Chirag (9/18/2008)

    another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the proc and also all...

    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

    September 18, 2008 at 2:13 am

    #873435

  • RE: Thank You All

    Thanks James

    That kind of comment is what makes it all worthwhile.

    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

    September 18, 2008 at 1:54 am

    #873426

Viewing 15 posts - 44,416 through 44,430 (of 49,552 total)