Forum Replies Created

Viewing 15 posts - 26,476 through 26,490 (of 49,552 total)

  • RE: Less Pay, More Convenience

    Ninja's_RGR'us (4/27/2011)

    GilaMonster (4/27/2011)

    Dan.Humphries (4/27/2011)

    Most managers hear of someone who did not actualy do much work from hom enad assumed that all work from home employees must not work more than...

    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

    April 27, 2011 at 10:56 am

    #1316758

  • RE: Less Pay, More Convenience

    Dan.Humphries (4/27/2011)

    Most managers hear of someone who did not actualy do much work from hom enad assumed that all work from home employees must not work more than a couple...

    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

    April 27, 2011 at 10:41 am

    #1316745

  • RE: Less Pay, More Convenience

    Steve Jones - SSC Editor (4/27/2011)

    Many managers just don't understand what they should be doing, so they tend to bother workers regularly with meetings and status requests, not desk checks.

    I...

    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

    April 27, 2011 at 10:30 am

    #1316738

  • RE: Need Help with Capacity growth script

    Please don't start multiple threads for the same problem. You're just wasting people's time is they answer unaware of all that's been discussed.

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

    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

    April 27, 2011 at 9:35 am

    #1316707

  • RE: There exists an index but query does not user created index, Why?

    The predicate is not SARGable, the index is not covering.

    SQL has no idea how many rows that predicate affects, hence it can't tell whether scanning the nonclustered index 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

    April 27, 2011 at 9:19 am

    #1316683

  • RE: light weight pooling greyed out

    Doesn't make a difference that it's not normalised.

    Light-weight pooling is a very bad idea these days, it's unlikely to improve performance, it's going to break CLR, linked servers and probably...

    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

    April 27, 2011 at 9:15 am

    #1316681

  • RE: light weight pooling greyed out

    By who?

    Does that person know what they are talking about?

    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

    April 27, 2011 at 8:14 am

    #1316613

  • RE: light weight pooling greyed out

    Why do you want to turn that on?

    It's a setting that should be left alone unless you have been instructed by Customer Support, or you know exactly what it'll do...

    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

    April 27, 2011 at 8:11 am

    #1316609

  • RE: What should I be doing with my points?

    Grant Fritchey (4/27/2011)

    Where was the company store located again?

    Cambridge? Or Denver?

    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

    April 27, 2011 at 8:01 am

    #1316600

  • RE: Optimize big table

    marcosjroig (4/27/2011)

    I deleted the primary key and I dont have a unique key. I do a control before insert to check repetitive data. Primary key has asociated clustered index, 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

    April 27, 2011 at 7:51 am

    #1316589

  • RE: Help with (easy for you) query

    GSquared (4/27/2011)

    The original requirement was if there's more than one row, do X. If Exists will test if there is at least one row. Are you sure that'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

    April 27, 2011 at 7:47 am

    #1316582

  • RE: Truncated field length in query

    What's the table definition? What's the query?

    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

    April 27, 2011 at 5:27 am

    #1316477

  • RE: optimize Our Database

    Identify the queries that perform badly. Rewrite or adjust indexes to make them run better. Repeat until performance is acceptable

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    April 27, 2011 at 3:23 am

    #1316430

  • RE: What should I be doing with my points?

    The points are just for boasting rights, they just get you different forum titles.

    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

    April 27, 2011 at 3:05 am

    #1316426

  • RE: Upgrade from SQL Server 2005 32 bit to SQL Server 2008 R2 64 bit

    I don't recommend restoring system databases to other versions.

    Rather script out what you need (logins, linked servers, server-level permissions, jobs, job history if you want it, DTS/SSIS) and apply those...

    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

    April 27, 2011 at 3:02 am

    #1316422

Viewing 15 posts - 26,476 through 26,490 (of 49,552 total)