Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 9,720 total)

  • RE: Non-alphanumeric Search Frustration

    Thom A (1/4/2017)

    I'm a little confused,on one part. You stated that "a hyphen is only allowed after the first character", however that the value "ABC-1245Z" is acceptable. The hyphen is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 4, 2017 at 7:54 am

    #1920622

  • RE: replace null with another column

    Or use a CASE statement.

    SELECT Col1, Col2,

    CASE WHEN cte1.Col IS NULL THEN cte2.Col ELSE cte1.Col END AS MyCol

    FROM ....

    This assumes that you can join the CTEs to each other...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 4, 2017 at 7:43 am

    #1920617

  • RE: Are the posted questions getting worse?

    Siiiiiigggggghhhhh.

    You would think when I get an alert that a log file drive is full in a non-prod system the first thing I would look at is whether or not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 16, 2016 at 11:03 am

    #1918456

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (12/16/2016)

    Phil Parkin (12/16/2016)

    Grumpy DBA (12/16/2016)

    Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 16, 2016 at 6:49 am

    #1918379

  • RE: Are the posted questions getting worse?

    Beware the Twitter list. For it is a way of defining you and boxing you into a corner!

    Actually, lists can be followed as a whole (I don't remember how) so...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 16, 2016 at 4:57 am

    #1918360

  • RE: Are the posted questions getting worse?

    JustMarie (12/13/2016)

    drew.allen (12/13/2016)

    Does any else think that this response borders on being unethical? http://www.sqlservercentral.com/Forums/FindPost1842475.aspx It sounds like she wants to use this approach just to avoid due...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 13, 2016 at 10:31 am

    #1917687

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (12/12/2016)

    Do you have Vick's First Defence (First Defense ;-)) nasal spray over there? I find it quite good- not sure how scientific it is, but my theory is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 12, 2016 at 11:28 am

    #1917449

  • RE: Are the posted questions getting worse?

    Gah. Less than a week until my parents visit for two weeks and I catch a cold. The last thing I need to do is give it to them because...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 12, 2016 at 7:31 am

    #1917372

  • RE: Are the posted questions getting worse?

    rodjkidd (12/9/2016)

    ChrisM@Work (12/8/2016)

    rodjkidd (12/7/2016)

    Eirikur,

    I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?

    Chris, are you about?

    Rodders...

    Oh poo....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 9, 2016 at 7:42 am

    #1917069

  • RE: Today's Random Word!

    Stuart Davies (12/8/2016)

    Ray K (12/7/2016)

    whereisSQL? (12/7/2016)

    Manic Star (12/7/2016)

    Ed Wagner (12/7/2016)

    djj (12/7/2016)

    Luis Cazares (12/7/2016)

    Ed Wagner (12/7/2016)

    DamianC (12/7/2016)

    Revenant (12/7/2016)

    Manic Star (12/7/2016)

    Limbo

    Stick

    Man

    Machine

    War

    Materials

    Labor

    Delivery

    Midwife

    Midtown

    Midriff

    Bare

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 8, 2016 at 5:16 am

    #1916732

  • RE: Today's Random Word!

    Ed Wagner (12/7/2016)

    crookj (12/7/2016)

    Ed Wagner (12/7/2016)

    djj (12/7/2016)

    Ed Wagner (12/6/2016)

    Manic Star (12/6/2016)

    whereisSQL? (12/6/2016)

    Revenant (12/6/2016)

    Iceland

    IceCream

    Vanilla

    Sugar

    Brown

    Molasses

    Flood (of 1919)

    Browning (first thing I think of when I see 1919)

    Rifle

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 7, 2016 at 7:00 am

    #1916502

  • RE: Are the posted questions getting worse?

    Sean Lange (12/6/2016)

    Time for the annual voyage to a destination for my wife's holiday party. They really go all out!!! They always fly the employees to a location and pay...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 7, 2016 at 6:45 am

    #1916497

  • RE: Today's Random Word!

    djj (12/6/2016)

    Ed Wagner (12/6/2016)

    Manic Star (12/6/2016)

    djj (12/6/2016)

    Brandie Tarvin (12/6/2016)

    Kaye Cahs (12/6/2016)

    Grumpy DBA (12/6/2016)

    Ed Wagner (12/6/2016)

    Cream

    Cookies

    Milk

    Santa

    Baby

    Buggy

    Walk

    Amble

    Meander

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 6, 2016 at 8:55 am

    #1916264

  • RE: Today's Random Word!

    Kaye Cahs (12/6/2016)

    Grumpy DBA (12/6/2016)

    Ed Wagner (12/6/2016)

    Cream

    Cookies

    Milk

    Santa

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 6, 2016 at 7:27 am

    #1916225

  • RE: Error updating SQL Server with CU pack

    I broached this issue to my coworkers. Turns out the system account owned all the folders in question, not allowing us to make changes to them via the install package,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 1, 2016 at 11:29 am

    #1915532

Viewing 15 posts - 1,261 through 1,275 (of 9,720 total)