Forum Replies Created

Viewing 15 posts - 16 through 30 (of 108 total)

  • RE: Union

    Maybe you could just select current month from daily table by filtering with date and rest from history table

    WITH Daytab AS

    (

    SELECT 'Daytab' AS src, 2014012 AS acctg,'West' AS region,'UT'...

    January 15, 2015 at 5:07 am

    #1770408

  • RE: Union

    Why do you need to join these tables anyway? If data is stored in daily table use it from there.

    If you want to use union select all from history table...

    January 14, 2015 at 12:05 pm

    #1770206

  • RE: Best Approach

    You need to have one table having all activities and then you outer join your table to it.

    January 14, 2015 at 11:48 am

    #1770198

  • RE: Tempdb Shrink takes long time.

    Siva Ramasamy (1/14/2015)

    Hi, I have restarted the SQL Instance before and it grew up again.

    Thanks!

    Siva.

    Did you remember to decrease initial size of tempdb files?

    January 14, 2015 at 11:44 am

    #1770195

  • RE: Connection stopped after DB migration

    ajfarroll (12/19/2014)

    I have resolved this problem. It was an entry required in the known hosts!!!! But thank you all for your input and assistance I have learned from...

    December 19, 2014 at 11:30 am

    #1765772

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/18/2014)

    So, I'm curious. Anyone have any major projects that people want before the end of the year?

    We have a business user that keeps asking for X fix, which...

    December 18, 2014 at 5:22 am

    #1765422

  • RE: Maxdop Setting Question

    JoshDBGuy (12/3/2014)

    Ville-Pekka Vahteala (12/3/2014)

    JoshDBGuy (12/3/2014)

    Perry Whittle (12/3/2014)

    JoshDBGuy (12/1/2014)

    I have less than 4 cores so my current setting is 0. However, I see some recommendations to set it to "0 to...

    December 3, 2014 at 12:32 pm

    #1762499

  • RE: SQL DBA knowing user passwords

    BTW how do you use windows login from Java EE application with application server on DMZ and database on LAN?

    December 3, 2014 at 12:13 pm

    #1762497

  • RE: SQL DBA knowing user passwords

    ScottPletcher (12/2/2014)

    eric.notheisen (12/2/2014)

    In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our development VM's...

    December 3, 2014 at 12:11 pm

    #1762496

  • RE: Maxdop Setting Question

    JoshDBGuy (12/3/2014)

    Perry Whittle (12/3/2014)

    JoshDBGuy (12/1/2014)

    I have less than 4 cores so my current setting is 0. However, I see some recommendations to set it to "0 to N". Will this...

    December 3, 2014 at 11:32 am

    #1762484

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/2/2014)

    Stefan Krzywicki (12/2/2014)

    How do you view the queries it generates? Are they persisted somewhere? Do you just see them through Perfmon? Something else?

    There are all the...

    December 2, 2014 at 11:50 am

    #1762192

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (10/24/2014)

    GilaMonster (10/24/2014)

    Koen Verbeeck (10/24/2014)

    And I thought we had a language problem in Belgium.

    At least you don't have 11 *official* languages.

    Nope, only 3 and that's apparently already enough to...

    October 24, 2014 at 2:54 am

    #1754556

  • RE: Memory and performance issues

    GilaMonster (10/22/2014)

    Ok, so what metrics/stats/info do you have for the period in question?

    I have nothing collected. I have been relying on Proactive DBA and it was shut down during the...

    October 22, 2014 at 4:40 am

    #1753988

  • RE: Memory and performance issues

    We are using Proactive DBA timeline for monitoring.

    Unfortunately I have no records for last week since I was on vacation and our support team made a version release and...

    October 22, 2014 at 3:06 am

    #1753964

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (10/21/2014)

    LutzM (10/21/2014)

    spaghettidba (10/21/2014)

    Ed Wagner (10/21/2014)

    Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so now...

    October 21, 2014 at 2:29 pm

    #1753881

Viewing 15 posts - 16 through 30 (of 108 total)