Forum Replies Created

Viewing 15 posts - 766 through 780 (of 14,953 total)

  • RE: Unable to compare text datatype fields to extract salient data

    High Plains Grifter (9/24/2012)


    Ok, well I don't quite get why SQL Server only truncates some strings, but I have a way that fails to work and your example using CAST()...

    - 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: Teammates

    TravisDBA (9/24/2012)


    It's all Bush's fault.:-D

    I'm still blaming everything wrong with the United States on George III. More fun that way.

    - 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: Unable to compare text datatype fields to extract salient data

    Another possible:

    IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

    DROP TABLE #T;

    CREATE TABLE #T

    (EntryID INT NOT NULL,

    EntryTime DATETIME NOT NULL,

    ...

    - 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: Please help connecting to SQL !

    The error message you're getting says that Named Pipes may not be enabled on the server you're trying to connect to. Is it? (SQL Server Configuration Manager allows...

    - 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 (9/21/2012)


    Well, the thread appears to be locked, so I can't reply, but:

    Celko


    First, email is so obviously not a natural key for a human being that I'm always shocked...

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

    Stefan Krzywicki (9/21/2012)


    capnhector (9/21/2012)


    ok im breaking out my "Realy? WTF" card on the behaviour twards the end of http://www.sqlservercentral.com/Forums/Topic1357081-392-3.aspx. did we really hit Godwin's law?

    Wow, I frequently disagree with...

    - 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: Nvarchar(Max) vs text in sql server 2000

    Text/NText is the SQL 2000 version of (n)varchar(max).

    Whether it will work or not depends on how you're using the data. For example, most of the string functions won't work...

    - 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: DBA Interview Questions needed - Serious only please.

    CptCrusty1 (9/21/2012)


    =====UPDATE=====

    We brought a guy in that indicated he was very experienced as a dba. He had lots of stuff on the resume that sounded right.

    As 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: Reports won't run from client computers but works fine from Report Server

    I'd have to get a network admin to answer that. I know just enough about Kerberos to know when it's being a problem, but not enough to solve 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: MERGE vs IF EXISTS with INSERT UPDATE

    TheSQLGuru (9/21/2012)


    For concurrency reasons it is MUCH preferred to use MERGE I think. I have seen a number of clients over the years get bad data in their system...

    - 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: T-SQL Help Needed

    ScottPletcher (9/20/2012)


    GSquared (9/20/2012)


    SomewhereSomehow (9/20/2012)


    Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as...

    - 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: Static way to get last day of the month from the past quarter

    drew.allen (9/20/2012)


    GSquared (9/20/2012)


    I use nested DateAdd and DateDiff functions to get last and first days of various time periods. For example, find the number of months (DateDiff) from 1...

    - 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: Monitoring Volume Mount Points

    So far as I can tell, you need to use WMI for this. WhatsUp and Solarwinds both say they can't do this.

    I've seen a suggestion that you could have...

    - 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: T-SQL Help Needed

    SomewhereSomehow (9/20/2012)


    I'm not a Celko agent =)

    Just try to understand =)

    He once explained to me that he acts this way online, because it follows a method of teaching his wife...

    - 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: T-SQL Help Needed

    SomewhereSomehow (9/20/2012)


    Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as I like...

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