Forum Replies Created

Viewing 15 posts - 481 through 495 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    MSSQL Tips Newsletter headline "Properly Secure SQL Server."

    Well, duh. You don't need an article for that. Just revoke all access.

    ALL access.

    Problem solved. Server secure....

    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 25, 2019 at 8:08 am

    #2020115

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, January 24, 2019 4:16 PM

    Yes... I end up summarizing a lot of things.  For example, the following...

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

    #2020086

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, January 24, 2019 8:28 AM

    So under the context of my current project, my boss asked me to put...

    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 24, 2019 at 8:30 am

    #2019972

  • RE: Are the posted questions getting worse?

    So under the context of my current project, my boss asked me to put in some technical debt. Basic code clean up and performance enhancement of code I wrote back...

    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 24, 2019 at 8:28 am

    #2019971

  • RE: Are the posted questions getting worse?

    <Headdesk>

    You know that moment when, after 5-6 hours of unit testing (sometimes the entire previous day) and trying to find out why all your records disappeared, you realize that the...

    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 24, 2019 at 6:32 am

    #2019941

  • 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

Viewing 15 posts - 481 through 495 (of 9,715 total)