Forum Replies Created

Viewing 15 posts - 526 through 540 (of 1,243 total)

  • RE: TRY_CONVERT smaller

    Steve Jones - SSC Editor (2/18/2016)


    BWFC (2/18/2016)


    To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version...

  • RE: TRY_CONVERT smaller

    To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version but many people testing that, like...

  • RE: Forcing Strong Passwords

    As somebody mentioned the other day, this[/url] sums things up well.

  • RE: Are the posted questions getting worse?

    Since I know you and I have the same smoker, have you done anything to protect it from the weather? I never found a decent cover for it and it...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (2/9/2016)


    Sean Lange (2/8/2016)


    Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time...

  • RE: Changing Granularity of Fact Table

    Jack Corbett (2/5/2016)


    BWFC (2/5/2016)


    It's done through stored procs called by SSIS. We first load a staging table then the fact table.

    Okay so that makes the process...

  • RE: Changing Granularity of Fact Table

    Jack Corbett (2/5/2016)


    How do you load the data warehouse?

    Can a person have risk at one load and then not have a risk the next load?

    How will...

  • RE: Differing Row Counts

    That was just a back-of-a-fag-packet, as-I-type guess. I'm in the process of breaking things open to have a look now and already I've spotted one reason why I've lost...

  • RE: Differing Row Counts

    Thanks Hugo, I appreciate I didn't provide a lot of detail but at this stage I only wanted find out whether it was always a problem or not. I'm...

  • RE: Select Statement retun records between 12:AM and 12:03 AM

    Welsh Corgi (2/4/2016)


    I'm trying to perform a Select Statement to a record between 12:AM and 12:03 AM

    select

    j.name as 'JobName',

    run_date,

    run_time,

    msdb.dbo.agent_datetime(run_date, run_time) as 'RunDateTime'

    From msdb.dbo.sysjobs j...

  • RE: Today's Random Word!

    Stuart Davies (2/4/2016)


    djj (2/3/2016)


    whereisSQL? (2/3/2016)


    Ray K (2/3/2016)


    Ed Wagner (2/3/2016)


    Revenant (2/3/2016)


    Ed Wagner (2/3/2016)


    DonlSimpson (2/3/2016)


    Ed Wagner (2/3/2016)


    Grumpy DBA (2/3/2016)


    Ed Wagner (2/3/2016)


    Padmay

    Naboo

    Coruscant

    Rome

    Italy

    Pasta

    Fettuccine

    Alfredo

    Parmesan

    Chicken

    Licken

    Finger

  • RE: Today's Random Word!

    Ed Wagner (2/2/2016)


    Grumpy DBA (2/2/2016)


    Ed Wagner (2/2/2016)


    HappyGeek (2/1/2016)


    Ironside

    Constitution

    HMS Guerriere

    Battle

    Abbey

  • RE: Spatial Index not applying

    There are certainly some great minds on here.

    If you're looking for a MySQL forum, the first place I'd try is here. I can't vouch for how good it is...

  • RE: Spatial Index not applying

    Hi Evan,

    welcome to the forum. Although I'm now about to try and scare you off. This is a SQL Server forum and although I'm sure there are...

  • RE: Are the posted questions getting worse?

    Sean Lange (1/29/2016)


    BL0B_EATER (1/29/2016)


    Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?

    For me IT...

Viewing 15 posts - 526 through 540 (of 1,243 total)