Forum Replies Created

Viewing 15 posts - 496 through 510 (of 9,725 total)

  • RE: Using Cross Apply with WHERE clause

    Brandie Tarvin - Tuesday, January 15, 2019 5:31 AM

    Jonathan AC Roberts - Tuesday, January 15, 2019 5:06...

    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 15, 2019 at 5:39 am

    #2018920

  • RE: Using Cross Apply with WHERE clause

    Jonathan AC Roberts - Tuesday, January 15, 2019 5:06 AM

    1. CROSS APPLY needs a space between CROSS and APPLY
    2. 'or' is 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.

    January 15, 2019 at 5:31 am

    #2018919

  • RE: Claculated field in Where clause

    My suggestion is to force the NULLs. And since you're accepting parameters, might I also suggest adding a bit of code to help you get around SQL Injection issues? You'll...

    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 15, 2019 at 5:03 am

    #2018915

  • RE: SQL 2017 Dev edition

    Beatrix Kiddo - Thursday, January 10, 2019 8:25 AM

    Maybe he thinks that if you put it on a server that automatically makes...

    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 10, 2019 at 10:47 am

    #2018592

  • RE: SQL 2017 Dev edition

    I'm beginning to think he's got the edition information mixed up with a corporate policy. IE, "you aren't allowed to install this on a server" vs "this isn't the version...

    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 10, 2019 at 8:22 am

    #2018537

  • RE: DbccLOBCompact on table with no LOB datatypes

    Jeffrey Williams 3188 - Monday, January 7, 2019 12:27 PM

    Here is a nice write up: https://sqlity.net/en/1051/blob-and-row-overflow-storage-internals-row-overflow-data/

    Even if you don't have LOB data...

    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 7, 2019 at 12:39 pm

    #2018217

  • RE: Does Stored Proc Complete if Machine Rebooted?

    It is possible that the client machine is being updated. Our workplace does that. In fact, corporate IT forcibly reboots EVERYONE's PCs on a nightly basis (or they did for...

    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 7, 2019 at 5:22 am

    #2018150

  • RE: Linked Server issue

    vivek52 - Wednesday, January 2, 2019 2:07 AM

    Hi..we are experiencing same sort of issue in our production environment. SQL job is getting...

    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 2, 2019 at 11:54 am

    #2017783

  • RE: Availability Groups Removed & Readded Database Problem :exclamation:

    Chris.null - Thursday, December 27, 2018 1:15 PM

    We are experiencing the same exact problem. I believe this issue was fixed with KB3152965. 

    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 31, 2018 at 11:40 am

    #2017668

  • RE: CASE to table conversion

    ScottPletcher - Friday, October 26, 2018 9:13 AM

    But it seems to me the real problem is that a simple code change...

    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.

    November 5, 2018 at 6:19 am

    #2012379

  • RE: CASE to table conversion

    Sue_H - Friday, October 26, 2018 11:06 AM

    I like the idea of decision tables. They are still around but I 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.

    November 5, 2018 at 6:14 am

    #2012378

  • RE: Are the posted questions getting worse?

    GAH.

    I hate having a SSIS package fail and fail again when being run from a job, but works fine from the desktop. And I look and look 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 26, 2018 at 6:16 am

    #2011314

  • RE: CASE to table conversion

    I'll look into decision tables. Thank you for the suggestion, Joe.

    Scott, I appreciate your input, but I want to make a non-code based solution if possible. The reason...

    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 26, 2018 at 5:16 am

    #2011311

  • RE: Are the posted questions getting worse?

    Am I really the only one annoyed by Mr. Ansi's "Please post DDL and follow ANSI/ISO standards when asking for help." response to the debate when the question didn't even...

    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 26, 2018 at 5:05 am

    #2011310

  • RE: NOT IN vs NOT EXISTS

    Thom A - Thursday, October 25, 2018 4:59 AM

    Perhaps my initial post mislead people, but the query in my initial post wasn't...

    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 25, 2018 at 5:11 am

    #2011109

Viewing 15 posts - 496 through 510 (of 9,725 total)