Forum Replies Created

Viewing 15 posts - 21,241 through 21,255 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Probably a cached stylesheet or something.

    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

    January 8, 2012 at 10:16 am

    #1430193

  • RE: SQL coding techniques

    SQL Kiwi (1/8/2012)

    I used += in a SQL Server script today for just the second or third time ever. Just doesn't seem natural in SQL, despite using it 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

    January 8, 2012 at 10:13 am

    #1430191

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/8/2012)

    The requirements are then looked at by "project management" (or worse, "programme management") experts who understand neither software development ....

    My favourite comment from a project manager, upon...

    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

    January 8, 2012 at 10:12 am

    #1430190

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/8/2012)

    Is it just me, or is SQL code prettifying (specifically colours) broken on the site at the moment?

    SELECT 'abc' FROM SomeWhere

    Looks ok to me.

    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

    January 8, 2012 at 10:02 am

    #1430186

  • RE: DTA questions

    Sure. Books Online (the SQL help file). ALTER INDEX ... DISABLE and ALTER INDEX ... REBUILD.

    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

    January 8, 2012 at 9:45 am

    #1430180

  • RE: SQL coding techniques

    SQL Kiwi (1/8/2012)

    GilaMonster (1/8/2012)

    Perry Whittle (1/8/2012)

    IIRC the older syntax is not supported in database compatibilty modes of 90 and higher

    The older style for outer joins isn't (+=, =+), but 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

    January 8, 2012 at 9:44 am

    #1430177

  • RE: DTA questions

    The indexes will still exist. For performance of the load you may want to disable them before the truncate and load and rebuild them afterwards

    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

    January 8, 2012 at 9:27 am

    #1430171

  • RE: SQL coding techniques

    Perry Whittle (1/8/2012)

    IIRC the older syntax is not supported in database compatibilty modes of 90 and higher

    The older style for outer joins isn't (*=, =*), but the older form for...

    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

    January 8, 2012 at 9:25 am

    #1430169

  • RE: Audio Books

    I use presentation recordings (SQL Bits, Pass Summit and others) and just listen to the audio portions. It's often quite enough to understand

    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

    January 8, 2012 at 7:14 am

    #1430156

  • RE: in sqlserver2008r2 i just want to create a admin database

    You've given us no where near enough information to even begin to help you.

    Admin what? login? User? On SQL? From an application?

    Student and faculty detail tables? Procedures? Application screens? Reports?

    Etc,...

    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

    January 8, 2012 at 6:29 am

    #1430147

  • RE: SQL Help

    Easiest to do it in 5 update statements

    UPDATE TABLE1 SET Col1 = 9999 where Col1=1111

    UPDATE TABLE1 SET Col2 = 9999 where Col2=1111

    UPDATE TABLE1 SET Col3 = 9999 where Col3=1111

    UPDATE TABLE1...

    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

    January 8, 2012 at 5:55 am

    #1430142

  • RE: mirror setup failed, but cannot delete mirror db

    The mirroring probably partially succeeded, it is several steps to configure and can fail on any of them, so it wasn't successfully mirroring, but knew that it was 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

    January 8, 2012 at 5:52 am

    #1430141

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    Ninja's_RGR'us (1/8/2012)

    GilaMonster (1/8/2012)

    Ninja's_RGR'us (1/7/2012)

    I've had it on the other receiving end where a partner 1st refused to hire me because I didn't have the certs (admin cert for BI work...

    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

    January 8, 2012 at 5:31 am

    #1430139

  • RE: 70-450. how deep do i need to go

    Not very deep. Know the concepts, where you'll use them, what would make you chose feature X over Y (and what would make one or the other not applicable).

    p.s. I...

    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

    January 8, 2012 at 5:25 am

    #1430137

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    Ninja's_RGR'us (1/7/2012)

    I've had it on the other receiving end where a partner 1st refused to hire me because I didn't have the certs (admin cert for BI work which I...

    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

    January 8, 2012 at 2:23 am

    #1430120

Viewing 15 posts - 21,241 through 21,255 (of 49,552 total)