Forum Replies Created

Viewing 15 posts - 33,511 through 33,525 (of 49,552 total)

  • RE: Time to rethink DB design and workflow

    What version of SQL and what edition?

    If you have 2005/2008 Enterprise Edition, consider table partitioning for your large table. Then you can switch partitions out to do archiving. Works...

    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 14, 2010 at 1:15 am

    #1133349

  • RE: 881223 - How to add a Share Disk resource to a cluster?

    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/Topic882515-1549-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 14, 2010 at 1:08 am

    #1133346

  • RE: Help to know more about Index

    http://www.sqlservercentral.com/articles/Indexing/68439/ and the rest of the series.

    Also, there's a lot of information, especially on index architecture in the SQL Books Online. Have you read all of that?

    If you still have...

    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 13, 2010 at 9:36 am

    #1133219

  • RE: cluter server databases backup on local drive

    When dealing with a cluster, only shared drives that are dependencies of the SQL Server service are accessible from 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

    March 13, 2010 at 9:34 am

    #1133218

  • RE: Temp tables

    In general, use two different temp tables or, instead of dropping the temp table, truncate it and change the second select into to an insert into.

    SELECT #Customer.*

    INTO #CTemp

    FROM #Customer

    WHERE #Customer.zip_code...

    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 13, 2010 at 1:01 am

    #1133161

  • RE: Please Explain The User Levels

    Points for posts, points for answering QotD correctly.

    http://www.sqlservercentral.com/Forums/Topic447796-4-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 13, 2010 at 12:36 am

    #1133158

  • RE: Temp tables

    Maybe I'm missing something, but that entire piece can be one update statement

    update customer

    set local_fl = CASE zip_code WHEN '92646' THEN 1 ELSE 0 END

    Does that work? I honestly can't...

    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 13, 2010 at 12:34 am

    #1133157

  • RE: TSQL using parameters does not use the index

    Tom Van Harpen (3/12/2010)

    I checked out the article when I think back to the profiler output (don't have it in front of me) but it appeared that it may have...

    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 13, 2010 at 12:30 am

    #1133154

  • RE: sql 2008 - three databases cannot be backed up - message '170(failed to retrieve text for this error. Reason: 15105)'

    mathias-ruehn (3/12/2010)

    but maybe there are some complications in the auth requests.

    they are ok, but maybe this is causing the failures...

    No! The errors in your logs, the ones that I quoted...

    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 13, 2010 at 12:24 am

    #1133153

  • RE: sql 2008 - three databases cannot be backed up - message '170(failed to retrieve text for this error. Reason: 15105)'

    GTR (3/12/2010)

    Attach and Detach is not recommended for migration.

    Why not? Detach/attach and backup/restore will result in the same thing. A database converted to the new version on the new...

    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 13, 2010 at 12:20 am

    #1133151

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2010)

    Lynn Pettis (3/12/2010)

    I'm waiting for the Average DBA Competition. I'll nominate myself for that one.

    I'm waiting for the I'm Not a DBA Competition. I'll nominate myself...

    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 12, 2010 at 12:04 pm

    #1132917

  • RE: TSQL using parameters does not use the index

    Because that's a variable in the first script (not a parameter), SQL can't tell what they value of it is at compile time and it has to make a guess...

    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 12, 2010 at 11:31 am

    #1132894

  • RE: sql 2008 - three databases cannot be backed up - message '170(failed to retrieve text for this error. Reason: 15105)'

    You have IO problems. Get some diagnostics running on those drives or, better idea, get the DBs onto different storage before they completely fail.

    A read of the file 'S:\MSSQL10.MSSQLSERVER\MSSQL\DATA\central_city_Data.MDF' at...

    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 12, 2010 at 11:21 am

    #1132888

  • RE: Are the posted questions getting worse?

    Paul White (3/12/2010)

    GilaMonster (3/12/2010)

    Gianluca Sartori (3/12/2010)

    That would be funny! I was officially nominated DBA two weeks ago, it's a bit early to enter a competition and pretend that I'm "exceptional"!...

    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 12, 2010 at 11:16 am

    #1132885

  • RE: Load/performance testing

    It's a local security policy setting. Grant the SQL Server Service account rights.

    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 12, 2010 at 11:12 am

    #1132881

Viewing 15 posts - 33,511 through 33,525 (of 49,552 total)