Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 9,707 total)

  • 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...

    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...

    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...

    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...

    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...

    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,...

    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...

    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.

    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...

    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.

    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...

    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...

    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...

    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...

    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...

    September 14, 2016 at 10:41 am

    #1900908

Viewing 15 posts - 1,456 through 1,470 (of 9,707 total)