Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 49,552 total)

  • RE: SQL Server - Spid 1 - 50

    Weird.

    What problems is it causing?

    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

    October 9, 2014 at 7:55 am

    #1751298

  • RE: How to check Performance ON Cluster Index on table

    santoshkal (10/9/2014)

    If we create composite clustered index on all columns does it effect any thing ??

    Yes, it affects lots of things.

    when i run the query it always taking non 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

    October 9, 2014 at 7:32 am

    #1751290

  • RE: SQL Server - Spid 1 - 50

    Server regional settings?

    And no, sessions 1-50 are not system sessions, that distinction hasn't been true since pre-SQL 2005. Sessions over 50 may be system as well. Rather use the is_user_process...

    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

    October 9, 2014 at 7:31 am

    #1751288

  • RE: Temporary Tables Causing Stored Procedure Recompiles

    Nick Doyle (10/9/2014)

    I wonder which would get used once the concurrent executions complete and the next execution starts.

    Doesn't matter. Part of the 'cleanup' when the procedure ends and the temp...

    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

    October 9, 2014 at 6:42 am

    #1751264

  • RE: How to check Performance ON Cluster Index on table

    santoshkal (10/9/2014)

    after using where clause also its taking 100% cost ?

    Of course it it. It's still the only operation in the batch, the costs have to add to 100%, that'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

    October 9, 2014 at 6:32 am

    #1751260

  • RE: How to check Performance ON Cluster Index on table

    santoshkal (10/9/2014)

    when i run the select * from & checked the execution plan its cost 100%

    Well, of course it is.

    Costs have to add up to 100%, so...

    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

    October 9, 2014 at 5:48 am

    #1751234

  • RE: How to check Performance ON Cluster Index on table

    No, it's not a good idea to include all columns. Clustered indexes should be narrow, that one is not.

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

    As for how you test, identify the frequent queries which run against...

    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

    October 9, 2014 at 5:34 am

    #1751224

  • RE: How to check Performance ON Cluster Index on table

    What, exactly, do you mean by 'performance of 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

    October 9, 2014 at 5:03 am

    #1751215

  • RE: Are the posted questions getting worse?

    TomThomson (10/8/2014)

    I wish e718 had been available when I was younger; but I think http://www.thinkgeek.com/product/f3cd/ would have been even better.

    I think my sysadmin would love that 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

    October 9, 2014 at 2:38 am

    #1751182

  • RE: SQL Server Design with Load Balancing and Failover

    No idea.

    This is not the kind of problem that can be solved with a couple of forum posts. I suggest you consider getting a good SQL consultant in (I can...

    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

    October 9, 2014 at 2:37 am

    #1751181

  • RE: Are the posted questions getting worse?

    The problem with the dance shirt is, knowing my colleagues, some of them would ask for the interpretive dance. Probably multiple times.

    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

    October 8, 2014 at 3:56 pm

    #1751120

  • RE: .SNAP files

    Other editions can't create explicit snapshots, so no. And snapshots are useless for backup purposes, they can't be used for backups, they have no advantages when there are backups running,...

    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

    October 8, 2014 at 2:58 pm

    #1751110

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/8/2014)

    Hahahaha

    One of the managers complained this morning that, as far as he can tell, most of my wardrobe is made up of geeky t-shirts. 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

    October 8, 2014 at 2:48 pm

    #1751109

  • RE: SQL login passwords that don't meet complexity requirements

    Just be careful of any possible legal implications (what happens if someone uses the same password for your system and their online banking, you cracked their password as part of...

    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

    October 8, 2014 at 8:21 am

    #1750995

  • RE: Are the posted questions getting worse?

    Oh, and just noticed that I've passed 40k points again. Only ~3000 to go to get to where I was.

    Steve, btw, I didn't even get a T-shirt for the first...

    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

    October 8, 2014 at 8:02 am

    #1750984

Viewing 15 posts - 7,561 through 7,575 (of 49,552 total)