Forum Replies Created

Viewing 15 posts - 35,791 through 35,805 (of 49,552 total)

  • RE: Primary key column and Index on the same.

    Generally it has to do with the size and data type of the pk and whether or not the cluster would be better elsewhere. This may help: http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    November 17, 2009 at 6:26 am

    #1080186

  • RE: Clustered Index Key vs Unique Row Identifier

    These may help.

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    Part 3 will be published tomorrow

    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

    November 17, 2009 at 6:25 am

    #1080185

  • RE: Issue with Table script

    It's not the fact that the column is an identity that makes the second index a 'mistake', it's the fact that there's both a clustered index and a nonclustered index...

    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

    November 17, 2009 at 6:25 am

    #1080183

  • RE: Database Integrity Checks - sudden error

    That can happen if a previous snapshot wasn't dropped successfully. Don't know why, just have heard about it. Can you schedule a restart of SQL soon?

    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

    November 17, 2009 at 4:19 am

    #1080142

  • RE: how to create nested schema?

    Separate databases for the 3 devs, or a single database with just the A, B, C schemas (and be careful not to mess up the other's work)

    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

    November 17, 2009 at 4:18 am

    #1080141

  • RE: Database Performance

    mjarsaniya (11/17/2009)

    i think using different database per user should give performance because it has separate datafile and logfile but update takes 14.85 minutes which is more than single database 10.12...

    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

    November 17, 2009 at 4:16 am

    #1080140

  • RE: Should we need to follow recommendation of DTA blindly?

    You shouldn't be testing on live anyway. That's what a test server is there for.

    Run the queries against the DB. Time them. Create one of the indexes. Run 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

    November 17, 2009 at 4:14 am

    #1080139

  • RE: Difference between sp_updatestats and update statistics?

    No. How can it?

    sp_updatestats, if run without parameters, runs UPDATE STATISTICS Schema.Table StatsName if the stats set is set to auto update and UPDATE STATISTICS Schema.Table StatsName NORECOMPUTE if it'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

    November 17, 2009 at 4:09 am

    #1080136

  • RE: how to create nested schema?

    tarunsoodrnd (11/17/2009)

    After we have 3 schemas as tarun1, tarun2, tarun3 our next step is to insert the tables into the respective schemas. and which mean we have to insert existing...

    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

    November 17, 2009 at 3:59 am

    #1080132

  • RE: how to create nested schema?

    No such thing as a nested schema. What are you trying to do here?

    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

    November 17, 2009 at 2:43 am

    #1080113

  • RE: Difference between sp_updatestats and update statistics?

    sp_updatestats calls UPDATE STATISTICS. It'll only call it for a stats set if at least one row has changed and by default it does a sampled update.

    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

    November 17, 2009 at 2:42 am

    #1080112

  • RE: Count data using condition

    SELECT

    SUM(CASE Status WHEN 'Active' THEN 1 ELSE 0 END) AS SumActive,

    SUM(CASE Status WHEN 'Inactive' THEN 1 ELSE 0 END) AS SumInactive

    Count(*) AS Total

    FROM...

    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

    November 17, 2009 at 1:37 am

    #1080086

  • RE: directory lookup for the file failed with the operating system error 2

    Is there a drive named 'S:'?

    Does the SQL Server service account have full access to that drive?

    If this is a clustered SQL Server, is that drive a dependency 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

    November 17, 2009 at 1:35 am

    #1080085

  • RE: Search Query

    Elliott W (11/17/2009)

    You could try this:

    SELECT *

    FROM dbo.SomeTable

    WHERE ( @Field1 IS NULL OR Field1 = @Field1 )

    AND ( @Field2 IS NULL OR Field2...

    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

    November 17, 2009 at 1:19 am

    #1080082

  • RE: Help required in regards to SQL 2000

    unixbomer (11/11/2009)

    Well I would say that your biggest selling point would be that Microsoft dropped support for SQL 2000 last year. There is still extended support until 2013, but that...

    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

    November 17, 2009 at 1:13 am

    #1080079

Viewing 15 posts - 35,791 through 35,805 (of 49,552 total)