Forum Replies Created

Viewing 15 posts - 6,091 through 6,105 (of 14,953 total)

  • RE: Automated Driving

    jay holovacs (11/12/2010)


    GSquared (11/10/2010)


    Kevin Hood (11/10/2010)


    The true test of an automated driving system will be how it responds when a squirrel runs onto the road.

    Or someone's kid.

    Or knowing the difference....

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

    Henrico Bekker (11/12/2010)


    another one....

    http://www.sqlservercentral.com/Forums/Topic1019796-1550-1.aspx?Update=1

    oh and I reached a 1000 point...small milestone 😀

    Congrats on the millennial mark!

    - 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: Duplicate Index Performance

    GilaMonster (11/11/2010)


    GSquared (11/11/2010)


    Another way is to have a multi-column clustered index, and to include those same columns in a non-clustered index. Since the clustered index is automatically included, duplicating...

    - 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: Recursion counting problem. Not your usual issue

    ;WITH CTE (ID, ParentID, TopID) AS

    (SELECT CategoryID, ParentCategoryID, CategoryID

    FROM dbo.Category

    ...

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

    WayneS (11/11/2010)


    Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all the other...

    - 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: Assign negative number to bit variable

    Because 1 bit of data only stores on/off, not "on/off/negative-on". Some use -1/0, which is essentially the same thing. Some allow 1/0/-1, but that means they're using more...

    - 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: Using Excel as A Front End to A SQL Server Database Table(s)

    Sean Lange (11/11/2010)


    Guess I need to pick my head up off my pillow...that happens after lunch sometimes. 😛

    Pillow ?= Keyboard

    - 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: Automated Driving

    Freddie-304292 (11/11/2010)


    Good blog here on why automated cars will take over. I'm inclined to agree with him.

    I agree partially. If his "car-on-demand" or "just-in-time-car" or whatever you wanted...

    - 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: Using Excel as A Front End to A SQL Server Database Table(s)

    Sean Lange (11/11/2010)


    David.Poole (11/11/2010)


    This is on my list of "stupid things no-one in their right mind would try" and I apologise to any DBA for revealing how you do this.

    EXEC...

    - 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: Strange sql Agent Backup Job

    eseosaoregie (11/11/2010)


    ...I edited the domain details and username etc beforehand....

    Good. Had me worried for a bit there.

    - 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: Model Database log file is full

    It should only grow through either transactions, or someone deliberately growing it.

    - 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: 2 questions... first x > '' vs x <> ''

    David.Poole (11/11/2010)


    WHERE s.column >'' will be marginally more efficient than WHERE s.column<>''

    Nulls are sometime necessary, for example if I have a DrivingConvictions table in a car insurance database I might...

    - 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: SELECT * INTO vs INSERT INTO Performance

    Are the queries different?

    - 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: Duplicate Index Performance

    Wildcat (11/11/2010)


    GilaMonster (10/28/2010)


    Hint: What makes a clustered index different from a nonclustered index?

    Yes, it may be possible with work to make a nonclustered index larger than the cluster, it's 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: Recursive query with a twist

    You're welcome.

    - 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 - 6,091 through 6,105 (of 14,953 total)