Forum Replies Created

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

  • RE: Nested Subquery vs Correlated Subquery

    rinu.gour123 - Thursday, February 21, 2019 5:24 AM

    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 21, 2019 at 11:31 am

    #2022583

  • RE: SQL Server Database Administrator Interview Questions

    elea.grig - Thursday, February 21, 2019 5:19 AM

    As a beginner DBA I am really interested what kind of question do employers ask...

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

    #2022574

  • RE: xp_cmdshell problem

    call.copse - Tuesday, February 19, 2019 8:44 AM

    If anyone still cares BTW I came across this today; the ALTER...

    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 19, 2019 at 9:35 am

    #2022395

  • RE: Are the posted questions getting worse?

    TomThomson - Saturday, January 26, 2019 6:57 PM

    rodjkidd - Thursday, January 24, 2019 8:28 AM

    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 27, 2019 at 3:48 am

    #2020214

  • RE: Are the posted questions getting worse?

    drew.allen - Friday, January 25, 2019 9:46 AM

    Got back from a meeting this morning to discover that I suddenly had a second...

    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 10:31 am

    #2020145

  • 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

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