Post reply

Are the posted questions getting worse?

  • November 16, 2016 at 10:12 am

    #1912863

    Brandie Tarvin (11/16/2016)

    So I did a quick google on polenta and found this interesting article.

    That's interesting. I have never heard most of those "rules" about polenta.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • November 16, 2016 at 1:13 pm

    #1912910

    GilaMonster (11/16/2016)

    jasona.work (11/16/2016)

    My response to that was two words, one of which I shouldn't use in polite company and the first was "holy"

    :w00t:

    I was screaming at my monitor last night.

    I'm sitting here grinning like a madman :-D:hehe:

  • November 16, 2016 at 1:18 pm

    #1912911

    GilaMonster (11/16/2016)

    Lynn Pettis (11/16/2016)

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in late.

    Yes. https://connectevent.microsoft.com/

    That works for the live event. Is there a way to get the keynotes for viewing/sharing later?

  • November 16, 2016 at 3:28 pm

    #1912929

    Lynn Pettis (11/16/2016)

    GilaMonster (11/16/2016)

    Lynn Pettis (11/16/2016)

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in late.

    Yes. https://connectevent.microsoft.com/

    That works for the live event. Is there a way to get the keynotes for viewing/sharing later?

    Yes. The link I gave. As they have for the last few events, it's a live stream or delayed stream or watch later all in one. You can go there now (after it's finished) and start watching from the start.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 16, 2016 at 4:05 pm

    #1912933

    GilaMonster (11/16/2016)

    Lynn Pettis (11/16/2016)

    GilaMonster (11/16/2016)

    Lynn Pettis (11/16/2016)

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in late.

    Yes. https://connectevent.microsoft.com/

    That works for the live event. Is there a way to get the keynotes for viewing/sharing later?

    Yes. The link I gave. As they have for the last few events, it's a live stream or delayed stream or watch later all in one. You can go there now (after it's finished) and start watching from the start.

    Okay, that would explain it. thank you.

  • November 17, 2016 at 6:56 am

    #1913043

    Grant Fritchey (11/16/2016)

    Announcements include:

    SP1 for 2016 (which also has CREATE OR ALTER).

    A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).

    vNext community preview available (you can start testing on Linux).

    It's a pretty exciting day.[/url]

    What is CREATE OR 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.

  • November 17, 2016 at 6:59 am

    #1913045

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects like Stored Procedures, Triggers, User–Defined Functions, and Views. This was one of the highly requested features by developers and SQL Community.

  • November 17, 2016 at 7:05 am

    #1913049

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects like Stored Procedures, Triggers, User–Defined Functions, and Views. This was one of the highly requested features by developers and SQL Community.

    I know it's in the link. But none of that tells me anything.

    What is CREATE OR 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.

  • November 17, 2016 at 7:08 am

    #1913052

    Wow, ok.

    I assumed it just creates an object if it doesn't already exist and alters it if it does.

  • November 17, 2016 at 7:08 am

    #1913053

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects like Stored Procedures, Triggers, User–Defined Functions, and Views. This was one of the highly requested features by developers and SQL Community.

    I know it's in the link. But none of that tells me anything.

    What is CREATE OR ALTER?

    A single statement that let's you CREATE OR ALTER a database object.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • November 17, 2016 at 7:16 am

    #1913056

    Grant Fritchey (11/16/2016)

    in Standard and Web (WHOOOP!).

    It's a pretty exciting day.[/url]

    I didn't make it through the entire presentation, but I read the announcement - thank you for the link.

    Am I reading this right, going completely insane or both? 😉 Does this mean that our on-premise SE will be able to use the EE features like compression, columnstore and hekaton?

    What does this mean for the cost of licensing? I ask because I'm stuck on SE all the way around due to licensing costs. If I'm reading this correctly, I've never heard a better argument for upgrading.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • November 17, 2016 at 7:29 am

    #1913061

    Beatrix Kiddo (11/17/2016)

    Wow, ok.

    I assumed it just creates an object if it doesn't already exist and alters it if it does.

    I didn't want to assume because every time I do, I end up wrong. But according to the below, you're right.

    Ed Wagner (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects like Stored Procedures, Triggers, User–Defined Functions, and Views. This was one of the highly requested features by developers and SQL Community.

    I know it's in the link. But none of that tells me anything.

    What is CREATE OR ALTER?

    A single statement that let's you CREATE OR ALTER a database object.

    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 17, 2016 at 7:30 am

    #1913063

    Ed Wagner (11/17/2016)

    Grant Fritchey (11/16/2016)

    in Standard and Web (WHOOOP!).

    It's a pretty exciting day.[/url]

    I didn't make it through the entire presentation, but I read the announcement - thank you for the link.

    Am I reading this right, going completely insane or both? 😉 Does this mean that our on-premise SE will be able to use the EE features like compression, columnstore and hekaton?

    What does this mean for the cost of licensing? I ask because I'm stuck on SE all the way around due to licensing costs. If I'm reading this correctly, I've never heard a better argument for upgrading.

    My understanding is, the goodies you still don't get in SE are some of the security stuff (TDE, so I'm stuck on EE and a few others,) and some of the High Availability stuff.

    But thinks like in-memory columnstore and compression? Yep, you get them...

    https://technet.microsoft.com/en-us/windows/cc645993(v=sql.90)

    So really, if you could figure out a way to live without Agent, you could drop down to Express and *really* save some money...

    Hmm, Express (free) on a (free, but no on-call support) Linux = more beer money!

    :hehe:

  • November 17, 2016 at 7:33 am

    #1913066

    Ed Wagner (11/17/2016)

    Grant Fritchey (11/16/2016)

    in Standard and Web (WHOOOP!).

    It's a pretty exciting day.[/url]

    I didn't make it through the entire presentation, but I read the announcement - thank you for the link.

    Am I reading this right, going completely insane or both? 😉 Does this mean that our on-premise SE will be able to use the EE features like compression, columnstore and hekaton?

    What does this mean for the cost of licensing? I ask because I'm stuck on SE all the way around due to licensing costs. If I'm reading this correctly, I've never heard a better argument for upgrading.

    Both.

    Columnstore and Hekaton and compression, all on SE. No added costs. There are some things that are still EE only like some of the encryption options. Also the limits on memory & CPU are still in place. The idea is that core functionality should just work across the stack. It's pretty amazing.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • November 17, 2016 at 7:39 am

    #1913070

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects like Stored Procedures, Triggers, User–Defined Functions, and Views. This was one of the highly requested features by developers and SQL Community.

    I know it's in the link. But none of that tells me anything.

    What is CREATE OR ALTER?

    That would be CREATE (if not exists) OR ALTER (if exists), bye bye to all the variations of checking if the object exists, create dummy and alter etc.

    😎

Viewing 15 posts - 56,641 through 56,655 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply