Forum Replies Created

Viewing 15 posts - 26,956 through 26,970 (of 49,552 total)

  • RE: Poor database design

    I suspect that you may need to get a specialist in (on-site) for a couple of days. I can recommend some good people here. Sounds like it's maybe too big/complex...

    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

    March 30, 2011 at 4:58 am

    #1305333

  • RE: Table fillrate and other info!

    Still need a table definition (create 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

    March 30, 2011 at 4:18 am

    #1305325

  • RE: Table Design -> DataTypes for identifier values

    Why not have the version as an identity column? Seems the obvious approach.

    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

    March 30, 2011 at 4:15 am

    #1305323

  • RE: Table Design -> DataTypes for identifier values

    Rowversion is not intended for what you are trying. Rowversion is typically used to detect what rows in a table have changed since a previous point in time. The value...

    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

    March 30, 2011 at 4:13 am

    #1305322

  • RE: Table fillrate and other info!

    Table definition?

    Please read through this: 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

    March 30, 2011 at 3:58 am

    #1305317

  • RE: Table fillrate and other info!

    You're not going to be able to do a udf if you want one query that can plug any table name and any column in. That will require dynamic 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

    March 30, 2011 at 3:17 am

    #1305309

  • RE: affinity mask value for 8 cpu heavily loaded sqlserver 2005 Ent

    Leave the affinity mask at default unless you really know what you are doing or are instructed so by Customer Support.

    High CPU often means you need to optimise your 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

    March 30, 2011 at 3:09 am

    #1305306

  • RE: Show all indexes with names

    Query sys.dm_db_index_physical_stats, join to sys.indexes (for the index name0, join to sys.tables or use the Object_Name function for the table name.

    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

    March 30, 2011 at 3:07 am

    #1305305

  • RE: Table fillrate and other info!

    Still don't understand. If there are 1000 rows how can only 500 be populated?

    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

    March 30, 2011 at 3:01 am

    #1305303

  • RE: Data set query keeps changing?

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1086036-1633-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

    March 30, 2011 at 2:44 am

    #1305298

  • RE: SQL Server shutdown - how to re-start server

    M.Kahn (3/30/2011)

    1) If Production SQL Server 2005/2008/RC is crash or down for some reason Human error etc ? , what i have to do first step do

    so sql server bring...

    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

    March 30, 2011 at 2:44 am

    #1305297

  • RE: Table fillrate and other info!

    Look up MIN, MAX, COUNT functions. They'll do 3 of the 4.

    What do you mean by % filled?

    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

    March 30, 2011 at 2:41 am

    #1305296

  • RE: Checkpoints and Performance

    Could you maybe start a new thread for new questions and give some detail as to what your problem 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

    March 30, 2011 at 12:33 am

    #1305266

  • RE: SQL Server punshes you for writing bad updates.

    Carlton B Ramsey (3/29/2011)

    That doesn't seem right to me though. I would had assumed that when the failure happened that the transaction log would be marked in such 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

    March 30, 2011 at 12:23 am

    #1305263

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (3/29/2011)

    For all gurus on the thread .... Are any of you going to try for this nice little gem

    http://sqlserverperformance.idera.com/forums/forum.php

    Register here:

    http://sqlserverperformance.idera.com/forums/register.php

    Last year a member of the Ohio North 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

    March 30, 2011 at 12:07 am

    #1305257

Viewing 15 posts - 26,956 through 26,970 (of 49,552 total)