Forum Replies Created

Viewing 15 posts - 3,901 through 3,915 (of 14,953 total)

  • RE: Same database in two places

    krypto69 (6/27/2011)


    if the can be reconsiled at the end of the day..then you could compress the bak file and restore on the other server at the end of the day.

    this...

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

    The Dixie Flatline (6/23/2011)


    Has anyone seen the Green Lantern movie yet?

    Yep. Liked it. My review is here: http://my-incompletethoughts.blogspot.com/2011/06/movie-review-green-lantern.html

    - 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: Search for Ambiguous Column Names after upgrade to SQL2008

    toddasd (6/22/2011)


    Ninja's_RGR'us (6/22/2011)

    Nope and I'm on a )*(/$"*(U case sensitive server.

    Ya, major PITA. Screw everything about that. :pinch:

    On both my 2005 and 2008 servers, I get

    Msg 4104,...

    - 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: need help explain a query

    codrutza_m (6/22/2011)


    so definitely saying WHERE Type = 'Cust' means the query retrives records when WHERE Type <> 'Cust'?

    It will ignore any that have a match in that sub-query, so...

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

    Craig Farrell (6/22/2011)


    GSquared (6/22/2011)


    Driving this in reverse is what comes to mind here.

    So, Bob, What the hell? That's all you got on here? I thought you were 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: Search for Ambiguous Column Names after upgrade to SQL2008

    Just keep in mind, everyone who uses it, all it tests for is "does it compile". It doesn't make sure it works right, it just tests compilation.

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

    Grant Fritchey (6/22/2011)


    Where'd you get the pictures of my yard?

    My lawyer says I shouldn't answer those questions any 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: Are the posted questions getting worse?

    Chad Crawford (6/22/2011)


    Steve Jones - SSC Editor (6/21/2011)


    Just an update, the horse looks good. Vet came today, said there will be a scar, but full recovery expected.

    Make sure you...

    - 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: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    Before you do anything oddball with the files, can you post the actual backup command being issued?

    - 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: need help explain a query

    Ah! Now that's a question I can answer.

    The left outer join finds rows that have a match in the second query, AND keeps rows in the first query that...

    - 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: Which one is better select * into # temp from tableA Vs create #temp table insert into...

    Craig Farrell (6/21/2011)


    opc.three (6/21/2011)


    Whether supplying an explicit column list or a * SELECT...INTO generates a table with no clustered index, i.e. a HEAP. If you're managing large quantities of data...

    - 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: Analytical Interview Questions

    On the "give them a database with known problems and see what they say and do", that's my prefered interview/screening method.

    I actually posted a couple of such database in 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: Search for Ambiguous Column Names after upgrade to SQL2008

    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

  • RE: Data nearing to 4GB. is there is a way to extend size?

    Brandie Tarvin (6/20/2011)


    GSquared (6/20/2011)


    There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in...

    - 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 User-Defined Function

    MikeAngelastro-571287 (6/21/2011)


    Hi GSquared,

    Are there any guidelines for an editorial as opposed to a post?

    Mike

    Check the "Write for us" link on the left side of the site.

    - 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 - 3,901 through 3,915 (of 14,953 total)