Forum Replies Created

Viewing 15 posts - 42,091 through 42,105 (of 49,552 total)

  • RE: Differential Backup Failures

    Jeffrey Williams (12/29/2008)

    When you change the recovery model from SIMPLE to FULL or FULL to SIMPLE, the database is marked as *requiring* a full backup before you can perform 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 29, 2008 at 11:00 pm

    #918761

  • RE: Is it safe to use "update syscolumns set colstat"

    Aspet Golestanian Namagerdi (12/29/2008)

    Is it safe to work with system tables and fallowing TSQL:

    If your goal is to corrupt your database and cause downtime and loss of data, sure.

    It 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

    December 29, 2008 at 1:51 pm

    #918608

  • RE: Changing Taxonomy

    joshcsmith13 (12/29/2008)

    For example, let's say I need a little help getting the correct results from my Cube operator with a Group By. This is valid syntax in 2000, 2005...

    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 29, 2008 at 1:47 pm

    #918603

  • RE: Differential Backup Failures

    biniyb (12/29/2008)

    But as far as File-System backups go, my SA here uses Legato which is different from NTBackup.

    Can you check and ensure that Legato's not also doing SQL backups 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

    December 29, 2008 at 12:26 pm

    #918544

  • RE: Optimization Job failed????

    It looks like there's not enough space in the data file. To rebuild a clustered index, SQL needs at least as much space as the clustered index currently takes 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

    December 29, 2008 at 12:22 pm

    #918540

  • RE: Differential Backup Failures

    Jeffrey Williams (12/29/2008)

    Changing the recovery model from full to simple will invalidate the backup chain - causing differential backups to fail with the error you are getting.

    This could also 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

    December 29, 2008 at 12:09 pm

    #918528

  • RE: Changing Taxonomy

    Matt Miller (12/29/2008)

    That's the thing though - multi-posting tends to backfire here. Because so many of the regulars use the "active threads" or "recent posts" options to look at...

    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 29, 2008 at 11:51 am

    #918517

  • RE: view with constantly update base tables

    I'll check tomorrow. Am currently reinstalling SQL.

    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 29, 2008 at 11:48 am

    #918515

  • RE: Optimization Job failed????

    Please run DBCC updateusage and then run the sp_spaceused again for both the database and the table.

    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 29, 2008 at 11:27 am

    #918502

  • RE: Changing Taxonomy

    joshcsmith13 (12/29/2008)

    I can't count the number of times I needed to post a T-SQL question, and couldn't decide if it should go in 2000 or 2005 to get 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

    December 29, 2008 at 11:25 am

    #918501

  • RE: Encripting seconds column in sql 2005

    May I ask why a column containing seconds would be confidential information needing encrypting? Who are you trying to protect that column against?

    Look up the Encrypt functions that SQL 2005...

    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 29, 2008 at 10:52 am

    #918484

  • RE: Transaction within a AFTER INSERT trigger

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

    December 29, 2008 at 10:47 am

    #918482

  • RE: Multi-column primary keys

    RBarryYoung (12/29/2008)

    Jim Russell (12/22/2008)

    Do you think we could convince Steve Jones to allow .sqlplan attachments?

    sqlplan files can be attached as .TXT files.

    Or zipped and attached, which I personally prefer as...

    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 29, 2008 at 10:38 am

    #918472

  • RE: ERROR trying to backup from Dataprotector

    Jeffrey Williams (12/29/2008)

    Gail - I have to make sure I remember this link. I see this issue so often now that it would just be easier to link to...

    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 29, 2008 at 10:37 am

    #918470

  • RE: view with constantly update base tables

    jasmineywchen (12/29/2008)

    I'm using 2005 and have attached the execution plan with my reply.

    Please post in the correct forum in the future. If you post in the wrong forum, people are...

    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 29, 2008 at 10:35 am

    #918469

Viewing 15 posts - 42,091 through 42,105 (of 49,552 total)