Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    And THIS[/url], folks, is why backups are important.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 19, 2016 at 10:41 am

    #1901686

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/19/2016)

    David Burrows (9/19/2016)

    Ed Wagner (9/19/2016)

    ChrisM@Work (9/19/2016)

    Eirikur Eiriksson (9/18/2016)

    Now where is that crystal ball again?

    😎

    You're going to need a pair of those. The OP (or should that be "perp"?)...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 19, 2016 at 10:40 am

    #1901685

  • RE: Are the posted questions getting worse?

    I HAVE THE POWER!!!!

    Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug fix"). I'm not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 19, 2016 at 7:52 am

    #1901626

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (9/15/2016)

    Anyone here planning to (or thinking about) going to Live! 360 Orlando?

    As a speaker, I have been given a special registration code that triggers a cheaper price $500...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 16, 2016 at 11:59 am

    #1901438

  • RE: SQL Code QA

    The Dixie Flatline (9/15/2016)

    I don't think I've ever done a RIGHT JOIN in production. :ermm:

    I have a power user who does it all the time because he doesn't seem...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 11:56 am

    #1901188

  • RE: SQL Code QA

    MMartin1 (9/15/2016)

    A pet peeve of mine is when the columns used in the select clause as the result of joins are not prefixed. You may know that someColumn came from...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 11:52 am

    #1901186

  • RE: SQL Agent Job Shows Running for Days, but Not Really Running

    jerry-621596 (9/15/2016)

    Brandie, these two jobs didn't cross over to a linked server. If I find anything common as I continue to research this I will let you know.

    Please do. And...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 11:51 am

    #1901184

  • RE: Blocked Process Alert issues

    mcliffordDBA (9/6/2016)

    What was the outcome? We are having a similar issue, but I can't capture the block.

    Oh, wow. It's been so long ago. We ended up having to do an...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 7:12 am

    #1901103

  • RE: t-sql 2012 case statement issue

    wendy elizabeth (9/10/2016)

    In a t-sql 2012, I have the following case statement:

    CASE

    WHEN (CalendarSchool.schoolLevelOPS IN ('All', 'Elem') AND ScheduleStructure.name <> 'High/Middle...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 6:27 am

    #1901081

  • RE: SQL Agent Job Shows Running for Days, but Not Really Running

    Usually when this happens in my environment, some sort of network blip has killed a connection to another server (the jobs that tend to do this are jobs pointing to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 6:24 am

    #1901080

  • RE: SQL Code QA

    Fast.Eddie (9/7/2016)

    Good Afternoon All, This is my first post.

    I created the below code and if works fine. However my DBA said "It does the job but is clunky" how could...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 6:21 am

    #1901078

  • RE: SQL Code QA

    The Dixie Flatline (9/7/2016)

    Did he say it looks clunky or it runs clunky?

    I think your DBA is being really picky unless you have company standards for formatting,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 6:17 am

    #1901076

  • RE: SQL Code QA

    Luis Cazares (9/7/2016)

    colin.dunn (9/7/2016)

    Put the join ON clauses on the same line since they were so short.

    I usually have my ON clauses on the same line as my JOIN, but...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 6:13 am

    #1901075

  • RE: Are the posted questions getting worse?

    WayneS (9/8/2016)

    I just received an email announcing that SQL Sentry's Plan Explorer PRO is now free! See this blog post[/url] for more details.

    Thanks, Wayne. I'll look into this.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 5:43 am

    #1901072

  • RE: Are the posted questions getting worse?

    Did anyone else get two copies of a newsletter yesterday?

    I received the Stairway to U-SQL Level 8 at 3:59 p.m. and 6:24 p.m. (Eastern time, U.S.) yesterday. Didn't receive a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 15, 2016 at 5:32 am

    #1901069

Viewing 15 posts - 1,471 through 1,485 (of 9,725 total)