Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Heading to Seattle soon and wondering if MS gives campus tours or not. Because... why not?

    Anyone know if they do?

    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.

    February 8, 2016 at 11:15 am

    #1857192

  • RE: Are the posted questions getting worse?

    Alvin Ramard (2/5/2016)

    SQLRNNR (2/5/2016)

    WayneS (2/5/2016)

    Lynn Pettis (2/5/2016)

    jasona.work (2/5/2016)

    So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had...

    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.

    February 5, 2016 at 10:58 am

    #1856945

  • RE: Are the posted questions getting worse?

    Luis Cazares (2/4/2016)

    Phil Parkin (2/4/2016)

    Grant Fritchey (2/4/2016)

    Grumpy DBA (2/4/2016)

    In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code...

    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.

    February 4, 2016 at 8:47 am

    #1856572

  • RE: Are the posted questions getting worse?

    Just found an interesting article on ethics in data science. What do you think?

    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.

    February 4, 2016 at 8:27 am

    #1856561

  • RE: Are the posted questions getting worse?

    So we were talking about Safe Harbor and data laws the other day, yes?

    And now Slate.com has this article about a new data transfer agreement.

    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.

    February 4, 2016 at 5:40 am

    #1856501

  • RE: Are the posted questions getting worse?

    Stuart Davies (2/4/2016)

    BL0B_EATER (2/4/2016)

    ChrisM@Work (2/4/2016)

    Luis Cazares (2/3/2016)

    This got me by surprise. I'm not searching for jobs, but it got my attention because it was totally unexpected (but possibly logical).

    https://www.linkedin.com/jobs2/view/99695736

    Stuart's BS...

    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.

    February 4, 2016 at 4:47 am

    #1856487

  • RE: Are the posted questions getting worse?

    Jo Pattyn (2/3/2016)

    I guess its Azure now.

    Thanks for your input Brandie, got a possible workaround.

    Glad I helped, even though I'm not sure what brilliant thing I'm sure I said. 😀

    I...

    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.

    February 4, 2016 at 4:45 am

    #1856486

  • RE: Find and Remove Duplicate Records SQL Server

    Luis Cazares (2/3/2016)

    Brandie Tarvin (2/3/2016)

    Luis Cazares (2/3/2016)

    Brandie Tarvin (2/3/2016)

    SQLian (2/3/2016)

    Not sure if I am missing something here, but why can't the following be used?

    delete [FROM] Customers

    where CustID 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.

    February 3, 2016 at 9:59 am

    #1856345

  • RE: Find and Remove Duplicate Records SQL Server

    Luis Cazares (2/3/2016)

    Brandie Tarvin (2/3/2016)

    SQLian (2/3/2016)

    Not sure if I am missing something here, but why can't the following be used?

    delete [FROM] Customers

    where CustID NOT in (

    ...

    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.

    February 3, 2016 at 9:50 am

    #1856342

  • RE: Do wildcards wipe out underscores?

    Hugo Kornelis (2/3/2016)

    John Mitchell-245523 (2/3/2016)

    Having said that, I don't understand why you're getting a result for that fourth stored procedure.

    My guess is that the comments in that procedure contain a...

    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.

    February 3, 2016 at 6:39 am

    #1856267

  • RE: Do wildcards wipe out underscores?

    GilaMonster (2/3/2016)

    Brandie Tarvin (2/3/2016)

    But when I tried escaping the underscores in my code, I got no results at all.

    WHERE Column LIKE '%/_%' ESCAPE '/'

    That would find anything with an _...

    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.

    February 3, 2016 at 5:49 am

    #1856248

  • RE: Do wildcards wipe out underscores?

    John Mitchell-245523 (2/3/2016)

    Brandie

    An underscore is a wildcard for a single character - if you want to find literal underscores then you need to escape them in your search pattern. ...

    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.

    February 3, 2016 at 5:41 am

    #1856244

  • RE: Find and Remove Duplicate Records SQL Server

    SQLian (2/3/2016)

    Not sure if I am missing something here, but why can't the following be used?

    delete Customers

    where CustID NOT in (

    ...

    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.

    February 3, 2016 at 5:24 am

    #1856232

  • RE: Are the posted questions getting worse?

    Jo Pattyn (2/2/2016)

    To the experts of DBCC TIMEWARP

    Why can't system databases be restored "with move" like the others?

    Example: RESTORE database model with move -> The system database cannot be moved...

    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.

    February 3, 2016 at 5:13 am

    #1856229

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/1/2016)

    GilaMonster (1/30/2016)

    Ed Wagner (1/29/2016)

    Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.

    Oh, hell, yes....

    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.

    February 3, 2016 at 5:11 am

    #1856226

Viewing 15 posts - 2,041 through 2,055 (of 9,715 total)