Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 49,552 total)

  • RE: Spinlocks

    Identify the problems that you're having, pinpoint the causes and address those directly. Just throwing hardware at the problem may well have no effect or may make whatever problems you're...

    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

    December 2, 2014 at 4:46 am

    #1761996

  • RE: Error while creating DB

    You have a server-scoped DDL trigger on CREATE DATABASE?

    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

    December 2, 2014 at 3:58 am

    #1761990

  • RE: Spinlocks

    Well, they're fast drives, what other kind of problem are you expecting them to help with?

    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

    December 2, 2014 at 3:55 am

    #1761986

  • RE: Spinlocks

    So you have procedures running very often, doing a lot of reads from memory...

    Again, what is making you think there's an IO-related problem here? You're talking about getting SSDs, 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

    December 2, 2014 at 3:37 am

    #1761983

  • RE: Spinlocks

    Why are you looking at SSDs? What suggests that you have a IO contention?

    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

    December 2, 2014 at 3:16 am

    #1761977

  • RE: SQLReader doesn't return any rows...

    On a slightly different topic... your procedure has a race-condition. Two people run this at the same time with the same key, one to insert the key and the other...

    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

    December 2, 2014 at 2:25 am

    #1761972

  • RE: Are the posted questions getting worse?

    WayneS (12/1/2014)

    SQLRNNR (12/1/2014)

    Koen Verbeeck (12/1/2014)

    SQLRNNR (12/1/2014)

    Sean Lange (12/1/2014)

    Is it just me or is LinkedIn quickly becoming the most useless website in existence? It seems that all that is there 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

    December 2, 2014 at 1:31 am

    #1761962

  • RE: if we rebuild the master db

    If you rebuild the system databases, all 4 get rebuilt. There isn't a 'rebuild master alone' feature.

    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

    December 1, 2014 at 9:00 am

    #1761760

  • RE: Clustered Index and nullable column!!!!!

    Clustered index column can be nullable. It's the primary key which does not allow any nulls.

    Uniqueidentifier however is generally a bad choice for clustered index because of the randomness. 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

    December 1, 2014 at 8:38 am

    #1761751

  • RE: SQL Query - Simple Question

    Jason-299789 (12/1/2014)

    This wont work in 2000, so you would have put the CTE as a 2 Correlated sub queries.

    Or maybe a temp table, since the Row_Number function doesn't exist in...

    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

    December 1, 2014 at 8:13 am

    #1761739

  • RE: Restoring DBs from files not backups?

    arrjay (12/1/2014)

    You don't need the .ldf when attaching the .mdf. There is an option in the attach screen you need to tick so SQL creates a new blank .ldf...

    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

    December 1, 2014 at 8:01 am

    #1761732

  • RE: if we rebuild the master db

    Yes.

    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

    December 1, 2014 at 7:58 am

    #1761730

  • RE: I'm Stumped - Starting SQL With Domain Account

    Perry Whittle (12/1/2014)

    Sean Pearce (12/1/2014)

    provided the server is still available.

    😀 what have you done with it then

    I'm imagining a server being thrown off a roof... 🙂

    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

    December 1, 2014 at 7:52 am

    #1761726

  • RE: Restore logs from SQL2005 db to SQL2012 db?

    If the initial database restore succeeded, they should.

    You have done all necessary upgrade testing?

    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

    December 1, 2014 at 7:42 am

    #1761713

  • RE: Restoring DBs from files not backups?

    steven 44886 (12/1/2014)

    Looks like I am out of luck. I don't have the logfile for the database (it was on local storage on the dead server - so probably lost...

    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

    December 1, 2014 at 6:56 am

    #1761698

Viewing 15 posts - 7,126 through 7,140 (of 49,552 total)