Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 49,552 total)

  • RE: two indexes on same column

    Lowell (6/29/2015)

    the funny thing is, that NC index gets used a lot when i look at the index stats

    Yes, it will. Doesn't mean it's useful.

    If you create 5 identical 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

    June 30, 2015 at 1:29 am

    #1808988

  • RE: Possible Causes of Database Corruption

    99%+ IO subsystem.

    That can be anything from a filter driver to the HBA drivers, switch firmware, cables, controllers, SAN cache, disks and everything in between.

    Make sure drivers and firmware is...

    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

    June 30, 2015 at 1:27 am

    #1808987

  • RE: How to deploy a encrypted procedure on the client machine.

    Please note: 6 year old thread.

    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

    June 28, 2015 at 12:40 pm

    #1808647

  • RE: Copying the id # to another field in your table

    Huh?

    If you don't know what the value should be, how can anyone else?

    Why the last entered ID value? What's the purpose? 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

    June 27, 2015 at 11:46 am

    #1808609

  • RE: How Can I Control "Buffer Manager Free Pages" Spikes

    If you don't feel like the alert is useful, disable it.

    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

    June 27, 2015 at 6:24 am

    #1808593

  • RE: Copying the id # to another field in your table

    Not following.

    If I insert 'This is a string' into that table, where does the ID come from for the IDCopied field?

    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

    June 27, 2015 at 1:58 am

    #1808585

  • RE: For MCSA : 70-461 ; 70-462; and any of these 70-463 or 411 or 412 or 483

    Personally I'm glad to see that change. Not everyone works with data warehouses. 463 is specifically SSIS, MDS and DQS, while I causally use SSIS from time to time, I'm...

    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

    June 27, 2015 at 1:55 am

    #1808584

  • RE: Are the posted questions getting worse?

    Jack Corbett (6/26/2015)

    Why no submission this year, Gail?

    Ask me over coffee sometime, somewhere.

    Are you going to be there?

    I don't know. Company won't pay for me 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

    June 26, 2015 at 2:39 pm

    #1808545

  • RE: Are the posted questions getting worse?

    jasona.work (6/26/2015)

    OK, I've tried to make out the title of the Shadowrun book on the shelf, and had no luck. I *know* it's one of the older ones, but...

    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

    June 26, 2015 at 2:28 pm

    #1808541

  • RE: Statistics (quickly) out of date

    ken.trock (6/26/2015)

    Thanks everyone. Even on a 120M row table SQRT(1000*<num rows>) is only a 350k row threshold. I'm bringing in at least that many every night. So not sure why...

    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

    June 26, 2015 at 1:21 pm

    #1808520

  • RE: Issue With T-SQL Data Types

    myjobsinus (6/26/2015)

    Thanks i created a function to split the string and that worked.

    Don't write your own, odds are it's using one of the more inefficient methods. Use the one...

    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

    June 26, 2015 at 1:17 pm

    #1808516

  • RE: Are the posted questions getting worse?

    jasona.work (6/26/2015)

    OK, I've tried to make out the title of the Shadowrun book on the shelf, and had no luck. I *know* it's one of the older ones, but...

    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

    June 26, 2015 at 1:14 pm

    #1808515

  • RE: How Can I Control "Buffer Manager Free Pages" Spikes

    Why would you want more than 20% of you memory to not be used? Surely the point is to ensure that the data cache is used, not that SQL is...

    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

    June 26, 2015 at 1:09 pm

    #1808513

  • RE: Issue With T-SQL Data Types

    It's not data types that are the problem. It's that IN doesn't work that way.

    Column IN (@Variable), because there's only one variable in the brackets, means Column = @Variable, and...

    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

    June 26, 2015 at 9:43 am

    #1808448

  • RE: Exit Lines

    The 'exit' statement that I made when I left the bank (after 4 years of working there and ~2 weeks of being intermittently belittled and insulted by some 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

    June 26, 2015 at 9:27 am

    #1808443

Viewing 15 posts - 5,461 through 5,475 (of 49,552 total)