Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 14,953 total)

  • RE: Avoiding Stored Procedures

    Paint me cynical, but I've never yet seen anyone but a database professional build a database, or the code to access it, in such a way that it didn't end...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Just starting first job - SSIS & SSAS

    Do you learn most easily from books, from hands-on, or from mentoring through examples? Different people learn differently, so that will matter. (Some can mix-and-match, too, of course.)

    If...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Tempdb log file location and Filegroup optimizations

    GilaMonster (8/10/2012)


    GSquared (8/10/2012)


    All I asserted is that multiple I/O channels is best, if tempdb optimization is needed. I don't get why that's being disagreed with.

    Late, and I have not...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Confused about how to design a new process (third week into new role)

    Steve Thompson-454462 (8/10/2012)


    GSquared (8/9/2012)


    On the point of "don't lose sight of the big picture", I'll just say that this is one of the biggest mistakes people make, assuming they can't...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: What is meant by set based programming?

    Shadab Shah (8/12/2012)


    Jeff Moden (8/10/2012)


    Shadab Shah (8/9/2012)


    Hi all,

    I have come across various section on this website where it is mention that SQL Server is a set based programming language.

    My...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: No blocking, queries running slowly, what to check next?

    I primarily use Read_Committed_Snapshot on most transactional databases these days. Not so useful on staging/bulk-import databases, but on OLTP systems it can be great.

    Unless you routinely have large numbers...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: formatting numbers

    I think you can set the formatting for a column by setting a property on it. I know I've done what you're asking about before, but it's been a...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    jasona.work (8/10/2012)


    Wi nøt trei a høliday in Sweden this yer?

    See the løveli lakes

    The wonderful telephøne system

    And mani interesting furry animals

    Including the majestic møøse

    A Møøse once bit my sister ...

    No...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: What is meant by set based programming?

    What I've found most useful when designing set-based vs row-based coding, is a few tips:

    1. Assume rows don't have an order to them. So you can't do "row...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    jcrawf02 (8/10/2012)


    Brandie Tarvin (8/10/2012)


    I thought we were all being snarky on The Thread.

    nope, just you

    < snark > yeah, right! < /snark >

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Tempdb log file location and Filegroup optimizations

    Robert Davis (8/8/2012)


    The reason you use multiple data files for tempdb is not for disk bandwidth. It is to avoid contention on the allocation pages. Saying that there is no...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: No blocking, queries running slowly, what to check next?

    Fly Girl (8/9/2012)


    Next time it's hung I will try dbcc freeproccache just to see if that resolves the problem. Seems like an easy way to see if that is the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Remove redundant data from address column

    adrian.facio (8/9/2012)


    Maybe we could use the google geocoding web service with a clr object to normalize an address.

    https://developers.google.com/maps/documentation/geocoding/#Geocoding

    According to this link, we can sent an address and get the coordinates....

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Crazy Interviews

    FunkyDexter (8/9/2012)


    Wierdest interview I ever has was only about my second job after finishing my degree. The boss turned up an hour late and the only thing he seemed...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/9/2012)


    GSquared (8/8/2012)


    Evil Kraig F (8/8/2012)


    -- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 1,021 through 1,035 (of 14,953 total)