Forum Replies Created

Viewing 15 posts - 961 through 975 (of 14,953 total)

  • RE: The Influence of the Cloud

    As anyone aware of the Matt Honan situation knows, one primary issue with "the cloud" is security.

    His home computer, iPhone, and iPad were all bricked by some hackers who used...

    - 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: sql logics1

    asranantha (8/16/2012)


    hi firend i have small doubt in sql plz tell me answer

    Auto commit has been turned off.

    1- William logs into the database

    2- Julianna logs into the database

    3- William sees...

    - 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: Avoiding Stored Procedures

    charles.byrne (8/17/2012)


    I'm always on the fence with this one, leaning more toward Stored Procs.

    From a developer's perspective I have issues with both.

    From an enterprise data perspective, I prefer...

    - 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: Avoiding Stored Procedures

    venoym (8/16/2012)


    GSquared (8/14/2012)


    You're not disagreeing with me. You're disagreeing with the original article we're discussing. All I did was quote/reference that. Please note the sentence I emphasized...

    - 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: create procedure with execute as

    No problem.

    By "edition", I meant "developer", "enterprise", "standard", "express", and so on. Express doesn't come with some of the BIDS options, if I remember correctly. That's why I...

    - 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: “OBJECT_NAME” function no longer returns objects' names

    guerillaunit (8/16/2012)


    I wasn't specifying the database to use. I explicitly designated the DB to use in the session and the names reappeared

    Okay. That means it was connecting to 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: Table join using LIKE or PATINDEX - Challenge

    And there isn't a bill-of-materials somewhere in the data, with the component items mapped to the products they are part of, right? It's just in the string, no mapping...

    - 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: Odd table format

    In Management Studio or some other tool?

    I guess I'd need to see the script to verify it's correctly formatted or not. Since the table is working, it should be...

    - 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: “OBJECT_NAME” function no longer returns objects' names

    It still works. But it will give a null result if the number isn't valid in the context of the connection it's being run in.

    If, for example, the connection...

    - 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: Table join using LIKE or PATINDEX - Challenge

    Is the item number a "separate string" inside the product number column, or is it burried in another string?

    Separate would be like:

    Item Number = A15

    Product Number = A15 XYZ

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

    ChrisM@Work (8/16/2012)


    Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

    Not sure of the name though. Symba is a bit silly, it’s a misspelling of...

    - 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: Odd table format

    Where are you seeing those things? In the object tree in Management Studio? In some Crystal Reports log? In something else?

    - 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: sql traces capturing all the sp_reset_connections all the time

    I'm going to hazzard that one or more servers connecting to this database are rebooting, restarting services, or otherwise dropping and rebuilding connections, during the window you're looking at. ...

    - 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 REPLACE with a string where I need to replace %anystring% with some new string

    On the subject of second and succeeding instances (3rd, 4rd, 5rd, etcrd.), running the function repeatedly would handle that gracefully.

    Using the Stuff() version would allow the same %variable% to be...

    - 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: Good relationship with manager

    I don't know of a forum for that kind of thing. I know there are classes on communication skills, and on how to deal with people in various scenarios....

    - 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 - 961 through 975 (of 14,953 total)