Forum Replies Created

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

  • 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

  • RE: create view with CTE SQL statement

    Glad you have it working. You might want to tag Chris's post as having worked for you.

    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:30 am

    #1901068

  • RE: Are the posted questions getting worse?

    You know it's going to be one of those days when one of the kittens throws himself on the clean clothes you just laid out on the bed and keeps...

    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:06 am

    #1901066

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/14/2016)

    SQLRNNR (9/14/2016)

    Brandie Tarvin (9/14/2016)

    SQLRNNR (9/14/2016)

    Ed Wagner (9/14/2016)

    SQLRNNR (9/13/2016)

    Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the...

    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 14, 2016 at 11:30 am

    #1900918

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/14/2016)

    Brandie Tarvin (9/14/2016)

    SQLRNNR (9/14/2016)

    Ed Wagner (9/14/2016)

    SQLRNNR (9/13/2016)

    Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database...

    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 14, 2016 at 11:26 am

    #1900917

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/14/2016)

    Ed Wagner (9/14/2016)

    SQLRNNR (9/13/2016)

    Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets...

    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 14, 2016 at 10:44 am

    #1900909

  • RE: create view with CTE SQL statement

    SQL Galaxy (9/14/2016)

    Yes, that view is correct SQL statement.. I have created many views with CTE Select statement in non custom port just like only Linked server name.

    also...

    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 14, 2016 at 10:41 am

    #1900908

  • RE: Are the posted questions getting worse?

    Sean Lange (9/6/2016)

    Ed Wagner (9/6/2016)

    Sean Lange (9/6/2016)

    ChrisM@Work (9/6/2016)

    Sean Lange (9/6/2016)

    Luis Cazares (9/6/2016)

    Sean Lange (9/6/2016)

    I tried my hand at curing my own bacon for the first time. It came out of...

    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 14, 2016 at 8:33 am

    #1900842

  • RE: Are the posted questions getting worse?

    Took a look at local weather over lunch time and immediately saw:

    83° Mostly Cloudy

    feels like 90°

    H 84° / L 77°

    UV...

    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 1, 2016 at 10:31 am

    #1898828

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/1/2016)

    Jeff Moden (9/1/2016)

    GilaMonster (9/1/2016)

    I uploaded the slide-deck in progress. Comments?

    http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948

    I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.

    Looks...

    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 1, 2016 at 10:28 am

    #1898826

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/1/2016)

    People correctly say "Use them when appropriate" but most newbies aren't qualified to figure out what's actually appropriate.

    That's not true! When I was a noob, I knew 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 1, 2016 at 10:28 am

    #1898825

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