Forum Replies Created

Viewing 15 posts - 35,506 through 35,520 (of 49,552 total)

  • RE: Moving data out of a partion

    Please don't cross post. It just wastes peoples time and fragments replies. There's no partitioning on SQL 2000, so putting this in the SQL 2000 forum is inappropriate anyway

    No 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

    December 4, 2009 at 12:34 am

    #1087511

  • RE: Database Backed up on 2008, restore on 2000?

    Garadin (12/3/2009)

    a quick google informs me that the backup data structure changed between versions.

    Not just the backup file structure. The actual database file structure. It is not possible 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

    December 4, 2009 at 12:33 am

    #1087510

  • RE: Error 100 while running full backup in maintenance plan

    Does the maintenance plan log or SQL error log show something more useful?

    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

    December 4, 2009 at 12:25 am

    #1087508

  • RE: Scalar - Seek vs Variable - Scan

    Please post table definitions, index definitions and execution plans, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Root of your issue is parameter sniffing. The optimiser knows the value of the constant, it doesn't of 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

    December 4, 2009 at 12:22 am

    #1087506

  • RE: Performance optimization on huge data

    sashikanta.mishra (12/3/2009)

    I agree that all the column should not be part of index column. So i only choose the column to be indexed and rest columns are in INCLUDE ....

    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

    December 4, 2009 at 12:20 am

    #1087504

  • RE: Searched Case execution

    I didn't even notice that. Aliases are supposed to be applied after the select is evaluated (which is why you can't refer to an aliased column elsewhere in the SELECT...

    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

    December 3, 2009 at 10:49 am

    #1087263

  • RE: get Count(*) to return 0

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    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

    December 3, 2009 at 9:30 am

    #1087205

  • RE: modify the database physical file name

    Why do you want to change the name of a file of one of the system databases?

    p.s. Please in future ask new questions in a new thread, rather than resurrecting...

    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

    December 3, 2009 at 9:15 am

    #1087197

  • RE: Searched Case execution

    Robert Frasca (12/3/2009)

    That works fine so you're right, there's something subtle but I can't pinpoint it.

    Weird.

    Take out the three extra column that I added for testing, see if it still...

    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

    December 3, 2009 at 9:11 am

    #1087193

  • RE: SQL server 2005 Mirroring....

    ajay.uce (12/3/2009)

    What is Mirroring in SQL server 2005..How can i configure that in SQL server 2005 ?

    What is the difference between Log shipping and Mirroring ?

    Is google down again?

    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

    December 3, 2009 at 8:47 am

    #1087167

  • RE: Searched Case execution

    Most of the select statement is a non-issue.

    Run this, see what it produces. There's got to be something subtly wrong with the values somewhere.

    SELECT

    ser.Patient_Primary_Policy_Carrier_ID,

    '[' + ISNULL(cval1.Control_Value1,'') + ']'

    cval1.Control_Value1,

    CASE

    WHEN ser.Patient_Primary_Policy_Carrier_ID =...

    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

    December 3, 2009 at 8:42 am

    #1087158

  • RE: MAXDOP Advice

    Kwisatz78 (12/3/2009)

    Ok this is where my understanding is weak, how can I see what queries have CXPACKET or SOS_Scheduler_yield waits? and further to that how do I then look...

    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

    December 3, 2009 at 8:26 am

    #1087135

  • RE: Replace data and log files of master

    luckysql.kinda (12/3/2009)

    Do you mean I have to install sql server again if I don't have master DB backup.

    No. The SQL installer can, if run with specific parameters, rebuild the master...

    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

    December 3, 2009 at 2:55 am

    #1086969

  • RE: Log File runing.... Disk out of space

    atramard (12/3/2009)

    it look like i am gone have to limit those log growth....

    Why?

    What you should have is alerts that warn you when the disk is getting full (80% as...

    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

    December 3, 2009 at 2:53 am

    #1086966

  • RE: MAXDOP Advice

    Kwisatz78 (12/3/2009)

    Yesterday I did a reset of the wait stats and since then in the view sys.dm_os_wait_stats CXPACKET is the second highest with a count of 3271668 with SOS_SCHEDULER_YIELD highest...

    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

    December 3, 2009 at 2:49 am

    #1086964

Viewing 15 posts - 35,506 through 35,520 (of 49,552 total)