Forum Replies Created

Viewing 15 posts - 4,711 through 4,725 (of 49,552 total)

  • RE: Data size of table is not reduced even after deleting millions of rows

    Kristen-173977 (9/21/2015)

    GilaMonster (9/21/2015)

    Rebuild the clustered index.

    What happens in this instance if there is no clustered index (i.e. a Heap)?

    Then you need to rebuild the heap.

    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

    September 21, 2015 at 3:46 am

    #1828025

  • RE: save real datatype in sql without converting to exponential

    schaudhary (9/21/2015)

    You can use BIGINT Or varchar(Max) Or NVARCHAR(max) for this.

    No, please don't suggest storing numbers in a varchar field at all, much less varchar(max). I highly doubt there's much...

    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

    September 21, 2015 at 3:11 am

    #1828018

  • RE: save real datatype in sql without converting to exponential

    If you need precise, use the Numeric or Decimal data types.

    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

    September 21, 2015 at 2:42 am

    #1828012

  • RE: Data size of table is not reduced even after deleting millions of rows

    Rebuild the clustered 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

    September 21, 2015 at 2:37 am

    #1828009

  • RE: What type of Index would be suitable

    .Netter (9/20/2015)

    All passwords are encrypted, I would never store them as plain text.

    Shouldn't be. They should be hashed, not encrypted. Encryption is reversible, a password once stored should not be...

    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

    September 21, 2015 at 2:30 am

    #1828007

  • RE: What type of Index would be suitable

    .Netter (9/20/2015)

    Thanks for the responce, that's very similar to the query I have. I'll add the non clustered indexes to those columns.

    Err, no. You'll add A nonclustered index on...

    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

    September 20, 2015 at 11:38 am

    #1827959

  • RE: Top SQL objects consuming CPU

    Jeff Moden (9/20/2015)

    GilaMonster (9/20/2015)

    The reports use the same DMVs that the OP doesn't want to use because they're since the last compile, not a time frame.

    Damn... I keep forgetting 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

    September 20, 2015 at 11:36 am

    #1827958

  • RE: What type of Index would be suitable

    Assuming your query looks something like this:

    SELECT UserID FROM Users where UserEmailAddress = @EmailAddress AND HashedPassword = @PasswordHash

    then you probably want a nonclustered index on EmailAddress, HashedPassword.

    The clustered 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

    September 20, 2015 at 6:34 am

    #1827941

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    robinwilson (9/15/2015)

    I do hope we can set up clustered indexes on the database without breaking SLAs and I really hope it works as after that and numerous IT consultants who...

    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

    September 20, 2015 at 3:03 am

    #1827937

  • RE: Error 833 : trigger the error

    What are you trying to do here? Do you just want to see what the form of the message is, or are you testing alerts or similar?

    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

    September 20, 2015 at 2:42 am

    #1827935

  • RE: What's This Query ??

    Automatic statistics 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

    September 20, 2015 at 1:20 am

    #1827922

  • RE: Top SQL objects consuming CPU

    Jeff Moden (9/19/2015)

    nagakula (9/19/2015)

    hi Team,

    We are trouble shooting a SQL Server high CPU issue and want to know what statements are the expensive ones in terms of CPU usage...

    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

    September 20, 2015 at 1:19 am

    #1827921

  • RE: Top SQL objects consuming CPU

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    You'll have to modify the query to get %, but it's not that hard. Probably should also be using extende events, not profiler in SQL 2012, but profiler does 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

    September 20, 2015 at 1:18 am

    #1827920

  • RE: Why are databases showing up in a newly created instance?

    stanlyn (9/19/2015)

    Does the default instance's databases automatically show and have to be excluded or something?

    No. The default instance's databases show when you connect to the default instance.

    Does the user "sa"...

    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

    September 19, 2015 at 1:56 pm

    #1827909

  • RE: Why are databases showing up in a newly created instance?

    You're missing the point. I don't care what port you use (and to be honest, port scanners aren't exactly hard to use, so minor security by obscurity). I didn't ask...

    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

    September 19, 2015 at 1:53 pm

    #1827908

Viewing 15 posts - 4,711 through 4,725 (of 49,552 total)