Forum Replies Created

Viewing 15 posts - 35,866 through 35,880 (of 49,552 total)

  • RE: How to retrive the data which is stored in hashed from

    Hashing is typically a one-way operation. ie the original data cannot be obtained from the hashed value.

    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 13, 2009 at 2:51 am

    #1078764

  • RE: SQL Tuning where no PK exists

    Looks like the clustered index is about as good as you're going to get here. Query needs a few too many columns for a covering nonclustered index to be a...

    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 13, 2009 at 2:46 am

    #1078762

  • RE: Query performance tuning

    The time for that select * is probably a combination of time to get the data off disk and time to get it across the network. Why are you querying...

    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 13, 2009 at 2:28 am

    #1078757

  • RE: Firehose Anyone? What's the most efficient way to insert 11 million records from one table to another?

    Bulk insert, bcp and SELECT INTO are all minimally logged if the database's recovery model is something other than FULL. There are other limitations, check Books Online for the details...

    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 13, 2009 at 2:22 am

    #1078753

  • RE: How to retrive the data which is stored in hashed from

    How was the data put into the 'hashed' form?

    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 13, 2009 at 2:20 am

    #1078751

  • RE: Why would an identity clustered index get fragmented?

    Roust_m (11/12/2009)

    the second one, I am not sure 100%, but the clustered index only has that identity column which does not get updated.

    Would the data updates affect clustered...

    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 13, 2009 at 2:05 am

    #1078747

  • RE: Restore DB with Norecovery

    tsd_suresh (11/12/2009)

    Any other alternative method to restore with norecovery ?

    Restore with recovery?

    Depends what you want to do with the DB. If you're restoring additional backups, then you need 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

    November 13, 2009 at 2:04 am

    #1078745

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

    guptaajay1985 (11/12/2009)

    Directory lookup for the file "e:\as.mdf\as.mdf" failed with the operating system error 2

    That doesn't look like a valid filename to me. Double check what it is that you're setting...

    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 13, 2009 at 1:58 am

    #1078743

  • RE: are CLR Functions at the server/instance level or db specific?

    Same as T-SQL functions.

    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 12, 2009 at 4:21 pm

    #1078642

  • RE: Rebuilding indexes doesnt work

    Trooper09 (11/12/2009)

    The column avg_fragmentation seems to have pretty high values on few of the indexes on the databases more than 80 and I beleive I should be rebuilding the indexes...

    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 12, 2009 at 4:15 pm

    #1078641

  • RE: Database is in Restoring mode

    Try RESTORE DATABASE <DB Name> WITH RECOVERY

    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 12, 2009 at 4:13 pm

    #1078640

  • RE: SQL Tuning where no PK exists

    SQLNewbster (11/12/2009)

    I did notice you mentioned clustered and I didn't have either as a clustered index.

    A clustered index can't have include columns, just specify the key

    I can try...

    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 12, 2009 at 1:00 pm

    #1078558

  • RE: What is the BEST way to determine the REAL version of SQL 2000??

    The output of @@Versions confuses so many people. The different colours show what's referring to what.

    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)

    Dec 16 2008 19:46:53

    Copyright (c)...

    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 12, 2009 at 12:53 pm

    #1078552

  • RE: Sleeping process CPU

    Those numbers are cumulative. They show the total cpu and the total IOs that the connection has done since connecting. If these connections have been open for a long time...

    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 12, 2009 at 12:46 pm

    #1078548

  • RE: SQL Tuning where no PK exists

    That's an incredibly wide index. What about dropping that and creating a clustered index on

    Company_No], [Year_For_Period], [Period]

    It's a bit wider than I like for a cluster, but it may...

    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 12, 2009 at 12:34 pm

    #1078538

Viewing 15 posts - 35,866 through 35,880 (of 49,552 total)