Forum Replies Created

Viewing 15 posts - 976 through 990 (of 9,715 total)

  • RE: Creating a temp table with dynamic SQL

    DesNorton - Monday, May 22, 2017 9:14 AM

    The nice thing is that you can have the ever-increasing value be unique across...

    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.

    May 22, 2017 at 12:11 pm

    #1943621

  • RE: Creating a temp table with dynamic SQL

    ACK! A Celko article that sounds exactly as he does on the forums... Yeah, sorry. Don't think I can finish reading that one.

    Interesting that Sequence won't let me...

    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.

    May 22, 2017 at 6:46 am

    #1943548

  • RE: Creating a temp table with dynamic SQL

    caffeinated - Saturday, May 20, 2017 11:13 AM

    If you're not too concerned about potential performance hits, you could create a new schema...

    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.

    May 22, 2017 at 6:01 am

    #1943533

  • RE: Are the posted questions getting worse?

    DesNorton - Monday, May 22, 2017 5:25 AM

    Brandie Tarvin - Monday, May 22, 2017 5:07 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.

    May 22, 2017 at 5:30 am

    #1943526

  • RE: Are the posted questions getting worse?

    Jeff Moden - Saturday, May 20, 2017 2:29 PM

    Shifting gears a bit and referring to the following post...
    https://www.sqlservercentral.com/Forums/1877279/BEFORE-TRIGGER-Idea-Posted-to-Microsoft-Connect
    I worked with Oracle...

    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.

    May 22, 2017 at 5:08 am

    #1943518

  • RE: Are the posted questions getting worse?

    Is anyone else having an issue with getting the new generic powerpoint template from SQLSaturday.com? I keeping getting a 'cannot open powerpoint out of memory' kind of error.

    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.

    May 22, 2017 at 5:07 am

    #1943517

  • RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

    JediSQL - Friday, May 19, 2017 5:47 PM

    I have wished for SQL Server BEFORE TRIGGERs for a long time. I have...

    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.

    May 22, 2017 at 4:47 am

    #1943514

  • RE: Creating a temp table with dynamic SQL

    Jeff Moden - Thursday, May 18, 2017 4:09 PM

    If you use a "sequence" object instead of an IDENTITY, there will be no...

    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.

    May 19, 2017 at 5:12 am

    #1943259

  • RE: Creating a temp table with dynamic SQL

    Thank you everyone for your answers. They are very informative. I'll get with my co-worker and we'll discuss this (it's his code but I was advising him on the dynamic...

    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.

    May 19, 2017 at 5:10 am

    #1943258

  • RE: Are the posted questions getting worse?

    GAH. Why is there always ONE?

    One person who "thoughtfully" hits REPLY ALL to an outage alert email, starting the trend of other people asking questions to the whole...

    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.

    May 18, 2017 at 9:28 am

    #1943136

  • RE: SSIS ForEach Loop Container recursion question

    Thom A - Thursday, May 18, 2017 5:08 AM

    Good to see you got a solution in the end Brandie. I did keep...

    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.

    May 18, 2017 at 5:23 am

    #1943074

  • RE: SSIS ForEach Loop Container recursion question

    It was that extra file reason why I went with the CASE statement instead of just adding the plus 1. But then, I had forgotten about CEILING since I never...

    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.

    May 18, 2017 at 5:03 am

    #1943071

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Wednesday, May 17, 2017 9:09 PM

    Email server's down, I sent you an email about it.

    I actually once had someone tell...

    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.

    May 18, 2017 at 4:25 am

    #1943061

  • RE: SSIS ForEach Loop Container recursion question

    FridayNightGiant - Wednesday, May 17, 2017 12:47 PM

    I'd do it like this

    SELECT CEILING(COUNT(*)/750000.00) AS FileCount
       FROM dbo.Mytable

    Ah. Forgot about that...

    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.

    May 17, 2017 at 12:50 pm

    #1942995

  • RE: SSIS ForEach Loop Container recursion question

    Phil Parkin - Wednesday, May 17, 2017 11:34 AM

    Bravo. Just one thing; doesn't 
    SELECT COUNT(*)/750000 AS FileCount
    FROM dbo.MyTable
    Give you one less...

    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.

    May 17, 2017 at 12:40 pm

    #1942993

Viewing 15 posts - 976 through 990 (of 9,715 total)