Forum Replies Created

Viewing 15 posts - 28,771 through 28,785 (of 49,552 total)

  • RE: Trigger Delete

    So users are allowed to delete 1 row, but not 2?

    To check for entire table, similar thing, but check and see if count(*) from deleted = count(*) from base 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 23, 2010 at 7:04 am

    #1265913

  • RE: Database corrupted

    If your last backup is 12pm, then any transactions past that cannot be recovered via restore. That's what simple recovery means.

    As for other options, without seeing the full output 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 23, 2010 at 6:55 am

    #1265903

  • RE: Space Used number is not decreasing as expected

    By dropping columns, there's space free on the pages, not free pages.

    It's either a rebuild of the clustered index or DBCC CLEANTABLE (or both) to resolve. I can't remember offhand...

    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 23, 2010 at 6:53 am

    #1265898

  • RE: Slight Problem :(

    dan-572483 (12/22/2010)

    Except SQLExpress does not have SQL Agent for automated backups. Unless you don't mind doing manual backups at the end of every day, at some point you'll...

    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 23, 2010 at 1:29 am

    #1265807

  • RE: Can I speed this TSQL up?

    Please post table definitions, index definitions for the contacts table as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 22, 2010 at 1:18 pm

    #1265672

  • RE: Are the posted questions getting worse?

    SQLkiwi (12/22/2010)

    Gail is the subject of the 10th day of SQL:

    http://crysmanson.com/2010/12/22/on-the-10th-day-of-sql/

    :w00t:

    It's funny, most of the posts on my blog are related to performance (execution plans, indexes, T-SQL performance comparisons or...

    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 22, 2010 at 12:35 pm

    #1265657

  • RE: Calling Out Bad Advice

    GSquared (12/22/2010)

    I have to say that my response to bad advice depends on where it is, what it is, what it's about, the tone it's delivered in, and the history...

    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 22, 2010 at 12:13 pm

    #1265653

  • RE: partition table,File group on Single hardDrive

    endo64 (12/22/2010)

    Hi,

    Multiple files gains some performance since SQL Server uses multiple threads to read data.

    It is a myth that SQL uses one thread per data file to read data....

    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 22, 2010 at 12:11 pm

    #1265651

  • RE: Migrating SQL 2000 and 2005 Databases from 32 bit to 64 bit

    alen teplitsky (12/22/2010)

    if you rebuild all your indexes it should also rebuild all your statistics as well

    Rebuilding indexes only updates the stats that are associated with indexes. It won't update...

    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 22, 2010 at 11:49 am

    #1265643

  • RE: How to ensure Security for MDF and LDF files

    Please post new questions in a new thread and give details of the SQL version involved.

    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 22, 2010 at 7:39 am

    #1265521

  • RE: restoring corrupted Database due to hard disk crash

    mlsrinivas (12/22/2010)

    I want to re-run the process with your guidance with the mdf and ldf files I got from the data recovery team. I still have the copy of 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 22, 2010 at 7:14 am

    #1265504

  • RE: restoring corrupted Database due to hard disk crash

    mlsrinivas (12/22/2010)

    I tried with DBCC CHECKDB('TransAidDB', REPAIR_REBUILD), but during this trial I am getting an error that database is to be opened in single user access, which I already 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

    December 22, 2010 at 2:00 am

    #1265385

  • RE: Microsoft officially launches Windows Phone 7 chinagoshop.com

    Spam. Reported. No replies please.

    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 22, 2010 at 1:22 am

    #1265381

  • RE: restoring corrupted Database due to hard disk crash

    mlsrinivas (12/22/2010)

    I tried various tools and options but of no use. I am giving below the process I followed which had lead close to recovery (I could see 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

    December 22, 2010 at 1:07 am

    #1265377

  • RE: Primary Key Vs Clustered Index: Performance Tuning

    Table and index definitions please?

    I'm guessing you didn't read the article that Gianluca posted.

    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 22, 2010 at 12:37 am

    #1265371

Viewing 15 posts - 28,771 through 28,785 (of 49,552 total)