Forum Replies Created

Viewing 15 posts - 20,326 through 20,340 (of 49,552 total)

  • RE: SQL Server 2000 database compatibility on SQL Server 2008

    In addition, the parser is stricter, there were some SQL statements that 2000 considered valid that 2005 does not. There were optimiser changes so a very small percentage of queries...

    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

    February 14, 2012 at 8:53 am

    #1446894

  • RE: LCK_M_U lock wait

    LCK_M_U is a wait for an update lock. Something's trying to update and whatever it wants to update is locked already. Start by identifying what is causing the blocking and...

    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

    February 14, 2012 at 8:45 am

    #1446890

  • RE: Optimize speed of maintenance tasks

    However you do need to check the licensing. Some apps (sharepoint as an example), you cannot tamper in any way with the schema without completely losing support.

    I am curious, why...

    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

    February 14, 2012 at 6:26 am

    #1446809

  • RE: DBCC REINDEX on table with 970GB data and 10GB index with 5 billions rows of count

    You mean LOB (Large OBjects)?

    LOB data types are text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml and large CLR types.

    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

    February 14, 2012 at 4:06 am

    #1446752

  • RE: Column Retrive using column id

    My reply to the interviewer would be to ask why I would need to do that. Certainly not something that you need to do in queries and referencing columns by...

    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

    February 14, 2012 at 3:37 am

    #1446739

  • RE: Dropping Image column

    I think this calls for another blog post added to the to-write queue. When I start blogging again I'm going to have no shortage of topics.

    Thinking of it a bit...

    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

    February 14, 2012 at 3:23 am

    #1446721

  • RE: Dropping Image column

    I wish I'd seen this earlier...

    Dropping a column is a meta-data only operation. SQL just changes the metadata to say that the column isn't there any longer and bumps 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

    February 14, 2012 at 2:56 am

    #1446701

  • RE: Optimize speed of maintenance tasks

    mchofman (2/14/2012)

    All I want to know is, does splitting up my database file accross multiple disks give extra performance or doesn't this help a lot.

    It might, or it might 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

    February 14, 2012 at 2:31 am

    #1446685

  • RE: How to iterate thru 10million plus records

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    February 14, 2012 at 2:27 am

    #1446683

  • RE: DBCC REINDEX on table with 970GB data and 10GB index with 5 billions rows of count

    george sibbald (2/14/2012)

    I'm surprised Gail and Jeff haven't jumped all over this but that does not look like a good candidate for a clustered index, its certainly not narrow 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

    February 14, 2012 at 2:25 am

    #1446682

  • RE: LAZY WRITER

    Please post new questions in a new thread. Thank you.

    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

    February 14, 2012 at 2:24 am

    #1446681

  • RE: drop database statement error on t-sql

    Could be someone else is using it.

    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

    February 14, 2012 at 1:36 am

    #1446666

  • RE: DBCC REINDEX on table with 970GB data and 10GB index with 5 billions rows of count

    stanley wong-314201 (2/13/2012)

    So, If i run the drop_existing script , will it still move the entire table include the data and index to the secondary filegroup ?

    CREATE UNIQUE CLUSTERED INDEX...

    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

    February 14, 2012 at 1:17 am

    #1446661

  • RE: Back up file size

    Not unless you specified WITH INIT

    Without that SQL will append backups to existing ones in the file.

    Use RESTORE HEADERONLY to see what backups are within the file.

    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

    February 13, 2012 at 2:40 pm

    #1446526

  • RE: Back up file size

    Did you backup to an existing backup set (so multiple backups in the same file)?

    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

    February 13, 2012 at 12:56 pm

    #1446463

Viewing 15 posts - 20,326 through 20,340 (of 49,552 total)