Forum Replies Created

Viewing 15 posts - 17,746 through 17,760 (of 49,552 total)

  • RE: When to mess with CPU affinity?

    Just this side of never.

    They're two settings that probably shouldn't be changed in the majority of cases. If you force affinity, you take away SQL's ability to move schedulers between...

    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

    July 9, 2012 at 5:48 am

    #1510277

  • RE: Restart Log Backups

    SQLBoar (7/9/2012)

    The question doesn't actually imply that the database has ever had any kind of successful backup. So unless you've checked and can rely on already existing full backup -...

    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

    July 9, 2012 at 4:38 am

    #1510244

  • RE: Query to return sample from each column of the DB

    derek.colley (7/9/2012)

    TOP doesn't guarantee ORDER BY. You should explicitly specify ORDER BY where possible and you can limit the result set like this:

    ...

    ORDER BY yourCol ASC

    ...

    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

    July 9, 2012 at 4:35 am

    #1510242

  • RE: Corrupt master and msdb databases

    If SQL starts, restore from lastest backups. If it doesn't start, rebuild the system databases and then once it does start restore the backups.

    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

    July 9, 2012 at 4:33 am

    #1510240

  • RE: Where to declare a data type when a function's parameters are declared

    Golfer22 (7/8/2012)

    When writing SQL code, which would be preferable from a readability perspective given these two examples which I believe are identical in terms of performance:

    Nothing to do with performance....

    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

    July 9, 2012 at 4:18 am

    #1510236

  • RE: Future Career Suggestion Request

    Jeff Moden (7/8/2012)

    GilaMonster (7/8/2012)

    Jeff Moden (7/8/2012)

    Jeez Gail, calm down! I NEVER said that MCM is "useless".

    You didn't?

    The recommendation sucked so bad that it immediately discredited the MCM...

    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

    July 8, 2012 at 2:17 pm

    #1510135

  • RE: Future Career Suggestion Request

    Jeff Moden (7/8/2012)

    Jeez Gail, calm down! I NEVER said that MCM is "useless".

    You didn't?

    The recommendation sucked so bad that it immediately discredited the MCM cert in my...

    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

    July 8, 2012 at 1:40 pm

    #1510130

  • RE: SQL Query Tuning help

    Well that's definitely not optimal... Why does the table not have a clustered index? Why is the index on EventID a unique nonclustered index rather than a primary key (backed...

    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

    July 8, 2012 at 12:59 pm

    #1510123

  • RE: SQL Query Tuning help

    Please post table definitions, index definitions and execution plan, 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

    July 8, 2012 at 12:10 pm

    #1510113

  • RE: Future Career Suggestion Request

    Jeff Moden (7/8/2012)

    necause I just saw (yesterday) some recommendations by an MCM on tuning a query that, while not technically incorrect, were woefully short (to the point of being misleading)...

    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

    July 8, 2012 at 11:15 am

    #1510106

  • RE: Backup (sql 2005), restore (sql 2008) -- anything else to do?

    Jeffrey Williams 3188 (7/8/2012)

    GilaMonster (7/8/2012)

    Coming from 2005, probably not. If you'd been coming from SQL 2000 I would have said absolutely yes.

    I keep hearing that they have fixed this issue...

    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

    July 8, 2012 at 9:38 am

    #1510094

  • RE: Inapproriate writes observed in PERFMON when a query is issued

    You're running the query in Management Studio on the same machine as the SQL service. That's SSMS's 'scratchpad' for query results (it's how it can display results that exceed 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

    July 8, 2012 at 9:09 am

    #1510089

  • RE: Backup (sql 2005), restore (sql 2008) -- anything else to do?

    Coming from 2005, probably not. If you'd been coming from SQL 2000 I would have said absolutely yes.

    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

    July 8, 2012 at 8:56 am

    #1510087

  • RE: Backup (sql 2005), restore (sql 2008) -- anything else to do?

    Update all statistics

    Run a checkDB

    Update compat mode to 100

    Take a backup

    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

    July 8, 2012 at 3:42 am

    #1510065

  • RE: what happen to the logs in database mirroring?

    mah_j (7/7/2012)

    so if the principal fails and we do a manual failover,i should do a forced service failover because the mirror database is now Disconnected and in Recovery mode.so we...

    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

    July 8, 2012 at 3:20 am

    #1510062

Viewing 15 posts - 17,746 through 17,760 (of 49,552 total)