Forum Replies Created

Viewing 15 posts - 511 through 525 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    In retail, people are taught to be honest when they don't know something but also to follow it up with a promise that they will find out and...

    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.

    October 24, 2018 at 11:20 am

    #2010975

  • RE: NOT IN vs NOT EXISTS

    Okay, so I do have an additional question. Why use the specific WHERE clauses you've used? Why not test the NOT IN with specific values?

    Why are you using...

    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.

    October 24, 2018 at 8:46 am

    #2010943

  • RE: NOT IN vs NOT EXISTS

    I've never actually played with EXISTS / NOT EXISTS, so I should probably try it out and see if it helps with our ITD feed processes, which are taking longer...

    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.

    October 24, 2018 at 8:41 am

    #2010939

  • RE: CASE to table conversion

    So basically I am looking at a table to store all the possible combinations in.

    I want to avoid a function if possible. I'd have to call it inside...

    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.

    October 24, 2018 at 7:05 am

    #2010916

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, October 24, 2018 5:56 AM

    So, seeing Lynn's reply to this: https://www.sqlservercentral.com/Forums/2005945/I-need-to-combine-two-unrelated-queries-to-produce-needed-results I was curious about something.

    When you post 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.

    October 24, 2018 at 6:02 am

    #2010909

  • RE: Are the posted questions getting worse?

    Michael L John - Tuesday, October 23, 2018 11:27 AM

    When I see something like this stated in a forum post, I kind...

    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.

    October 23, 2018 at 11:35 am

    #2010828

  • RE: Oracle SQL Developer to MS SQL Server

    frederico_fonseca - Tuesday, October 23, 2018 5:09 AM

    should be able to do any T-SQL required - no designers like SSMS but those...

    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.

    October 23, 2018 at 5:17 am

    #2010740

  • RE: Oracle SQL Developer to MS SQL Server

    Thanks. I'll see if the Mac client works.

    Not sure Azure Data Studio is going to work. He's doing schema development as well as coding and from what 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.

    October 23, 2018 at 4:25 am

    #2010735

  • RE: Oracle SQL Developer to MS SQL Server

    And I get this in response:

    we would like a simpler solution if possible.. Can you recommend a toolthat we can use on...

    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.

    October 23, 2018 at 3:48 am

    #2010731

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Monday, October 22, 2018 12:51 PM

    So when this sort of thing happens to you, you just "Thank you,...

    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.

    October 23, 2018 at 3:43 am

    #2010730

  • RE: Oracle SQL Developer to MS SQL Server

    Thanks. I'll let our developer know.

    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.

    October 23, 2018 at 3:33 am

    #2010729

  • RE: Are the posted questions getting worse?

    Never thought I'd say this, but I need some Oracle help please.

    https://www.sqlservercentral.com/Forums/2005273/Oracle-SQL-Developer-to-MS-SQL-Server

    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.

    October 22, 2018 at 12:50 pm

    #2010674

  • RE: badly perfoming query when IS NOT NULL used in the WHERE clause

    solus - Monday, October 22, 2018 8:01 AM

    how do i get the actual plan ?

    In the GUI, go to Query -> Include...

    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.

    October 22, 2018 at 8:14 am

    #2010582

  • RE: Are the posted questions getting worse?

    grumble, mumble.

    Why is it the DBA's job to know A) all the business rules that the users either don't care to keep track of or can't keep track...

    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.

    October 22, 2018 at 6:08 am

    #2010556

  • RE: Are the posted questions getting worse?

    WayneS - Friday, October 19, 2018 6:25 PM

    Ed Wagner - Wednesday, October 17, 2018 12:10 PM

    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.

    October 22, 2018 at 6:04 am

    #2010555

Viewing 15 posts - 511 through 525 (of 9,720 total)