Forum Replies Created

Viewing 15 posts - 31,111 through 31,125 (of 49,552 total)

  • RE: help needed in code tuning.

    Ninja's_RGR'us (8/22/2010)

    Here's a weird idea, start worrying about it when you plan to move to sql 201? and having the upgrade advisor throwing errors and warnings.

    In addition 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

    August 22, 2010 at 2:38 pm

    #1210159

  • RE: Use database name dynamically - Use @dbname

    If you have management studio 2008 (regardless of the database engine version), you can do multi-server queries. Other than that, Redgate has a multi-server query tool iirc.

    You can use 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

    August 22, 2010 at 2:37 pm

    #1210158

  • RE: help needed in code tuning.

    Jeffrey Williams-493691 (8/22/2010)

    I recall the same thing - and I don't have the reference either. But, it is related to how you write your queries. In SQL Server...

    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

    August 22, 2010 at 2:31 pm

    #1210156

  • RE: Do you advise to apply Recomendations given by DTA?

    Ninja's_RGR'us (8/22/2010)

    So if you can't trust the plans, can you trusts the ms, reads, writes, cpu... from the profiler 'cause that's pretty much the data I ended up trusting after...

    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

    August 22, 2010 at 2:30 pm

    #1210155

  • RE: Do you advise to apply Recomendations given by DTA?

    Jeff Moden (8/22/2010)

    Some will tell you that you can do a before'n'after on execution plan costs using estimated execution plans. Sometimes that works but sometimes it doesn't and, until...

    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

    August 22, 2010 at 1:15 pm

    #1210143

  • RE: INDEX DISABLE/REBUILD ???

    Jeffrey Williams-493691 (8/22/2010)

    This is really useful when bulk loading data into a DW. When you bulk load the data, you can DISABLE all of the non clustered indexes, load...

    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

    August 22, 2010 at 10:37 am

    #1210130

  • RE: Does anybody know "grant permission to multiple users" in sql

    Please don't cross post. It just wastes peoples time and fragments replies.

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

    August 22, 2010 at 10:34 am

    #1210129

  • RE: Does anybody know "grant permission to multiple users" in sql

    jude.pieries (8/21/2010)

    SELECT 'GRANT EXECUTE ON <OBJECTNAME > TO ' + NAME FROM SYSUSERS

    sysusers is deprecated, should not be used for new development and will be removed in a future version...

    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

    August 22, 2010 at 10:33 am

    #1210128

  • RE: When creating new table does column order matter if different data types?

    sql_er (8/21/2010)

    Last week a co-worker mentioned that it is best to place fixed length data types first, followed by variable length columns

    No, not at all. Order of columns in 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

    August 22, 2010 at 10:31 am

    #1210127

  • RE: INDEX DISABLE/REBUILD ???

    Create, as you might guess, creates a completely new index. If there's an existing index with the same name, you get an error.

    Disable drops the b-tree structure, just leaving 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

    August 22, 2010 at 10:27 am

    #1210125

  • RE: How many DBA's per instance/Database

    456789psw (8/22/2010)

    I just started a new DBA position and it seems like we have to many!

    Too many DBAs or too many instances?

    From what I recall from the bank, we had...

    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

    August 22, 2010 at 10:23 am

    #1210123

  • RE: Do you advise to apply Recomendations given by DTA?

    SqlServerLover (8/21/2010)

    So do i have to apply those indexes in test and find out if performance has improved or not by running those specific query or stored proc and checking...

    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

    August 22, 2010 at 7:10 am

    #1210100

  • RE: Performance tuning

    Jeff Moden (8/21/2010)

    subha.msc2007 (8/21/2010)

    Hi,

    i will give you the brief introduction about the performance issues.

    1. connectivity problems &

    2. Database tuning issues

    Database tuning...

    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

    August 21, 2010 at 2:36 pm

    #1210068

  • RE: help needed in code tuning.

    Jeff Moden (8/21/2010)

    I was referring to using actual table names as part of 2 part notation in the SELECT list. I remember very clearly seeing something from MS 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

    August 21, 2010 at 2:28 pm

    #1210067

  • RE: cannot delete index

    espanolanthony (8/21/2010)

    Msg 3739, Level 11, State 1, Line 3

    Cannot DROP the index 'dbo.Call_Details_.inx_add_1' because it is not a statistics collection.

    As the error says, that's an index, not a statistics collection....

    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

    August 21, 2010 at 10:02 am

    #1210038

Viewing 15 posts - 31,111 through 31,125 (of 49,552 total)