Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 14,953 total)

  • RE: Issue with Global Temp Tables and SQL Connections

    To my knowledge, all that Keep Alive does is check if the other machine is still turned on (effectively). I could be wrong about that, but I've never found...

    - 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

    June 9, 2011 at 12:14 pm

    #1336603

  • RE: Are the posted questions getting worse?

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

    Brandie Tarvin (6/9/2011)

    Hey, Steve (and other Prius owners), I just heard about this and wanted to pass it along:

    Toyota says a problem with electric power...

    - 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

    June 9, 2011 at 12:09 pm

    #1336596

  • RE: Shown up by a developer

    The reason I asked about it being a heap in the first place is because that exact behavior is one of the reasons Microsoft recommends against using heaps in SQL...

    - 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

    June 9, 2011 at 12:04 pm

    #1336588

  • RE: (Nolock) created blocking?

    clare.xia (6/9/2011)

    "Now back to the question. The nolock is not 100% guaranteed, if there are inserts updates affecting that exact row, or other memory resource issues, and sometimes a clustered...

    - 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

    June 9, 2011 at 11:55 am

    #1336581

  • RE: Issue with Global Temp Tables and SQL Connections

    To my knowledge, SQL Server doesn't hold onto connections or dispose of them on its own. The application, or its data access layer, does 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

    June 9, 2011 at 11:51 am

    #1336576

  • RE: Couple of questions about trigger

    Here are the articles I wrote on the subject.

    http://www.sqlservercentral.com/articles/Auditing/63247/

    http://www.sqlservercentral.com/articles/Auditing/63248/

    Make sure to read the discussions as well, since there's a lot of good data in those.

    - 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

    June 9, 2011 at 9:30 am

    #1336430

  • RE: Shown up by a developer

    Is the table a heap?

    - 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

    June 9, 2011 at 9:28 am

    #1336427

  • RE: Are the posted questions getting worse?

    Chad Crawford (6/9/2011)

    So I just started a consulting company and I have a question for you. What should my title be? If I'm the CEO, the company...

    - 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

    June 9, 2011 at 9:27 am

    #1336425

  • RE: Are the posted questions getting worse?

    GilaMonster (6/9/2011)

    I post too much.

    Nah. It's measured on a ratio of knowledge:posts, which actually means you post too little.

    - 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

    June 9, 2011 at 9:23 am

    #1336420

  • RE: Why compatibilty level is important

    Because of what it is and what it does.

    Do you have a more specific question? There's a lot to the subject of compatibility levels, what they do, what they...

    - 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

    June 9, 2011 at 7:44 am

    #1336300

  • RE: Why Can't We Code?

    Revenant (6/8/2011)

    ". . . That's the federal guideline (US)."

    On a secopnd thought, it does sound like something that came from the DC. I am afraid the next step will...

    - 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

    June 9, 2011 at 7:29 am

    #1336282

  • RE: Null values

    Per your first post, the value would be "blank", per the code you just posted, it will be "0", in the cases where you want it to be NULL instead....

    - 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

    June 9, 2011 at 7:17 am

    #1336266

  • RE: Copy 2005 Database containing table with varchar(max) to a 2000 database

    Backwards compatibility has limitations, especially on new data types.

    What would you do if you had to convert CLR data type columns to SQL 2000? Varbinary maybe? Still wouldn'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

    June 9, 2011 at 7:15 am

    #1336263

  • RE: Data file has been dropped but sql server wont let go

    bopeavy (6/8/2011)

    GilaMonster

    This is specific and unique to tempDB and likely has to do with what uses tempDB and how it's used.

    To determine that a TempDB data file can 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

    June 9, 2011 at 7:09 am

    #1336255

  • RE: Suggestions for documenting database

    Take a look at RedGate's SQL Doc tool. I've used that for this kind of thing, and it works quite well.

    You can add extended properties to database objects pretty...

    - 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

    June 8, 2011 at 7:52 am

    #1335660

Viewing 15 posts - 4,036 through 4,050 (of 14,953 total)