Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 2,783 total)

  • RE: Are the posted questions getting worse?

    So someone dug in to how MS has SQL2016 working on Linux[/url], only to find that *horrors* they're using essentially a containerization type solution. Just enough Windows kernel for...

    November 18, 2016 at 7:18 am

    #1913422

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2016)

    Hugo Kornelis (11/17/2016)

    Grant Fritchey (11/17/2016)

    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...

    November 17, 2016 at 11:18 am

    #1913178

  • RE: Are the posted questions getting worse?

    GilaMonster (11/17/2016)

    Luis Cazares (11/17/2016)

    GilaMonster (11/17/2016)

    jasona.work (11/17/2016)

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

    And with...

    November 17, 2016 at 10:56 am

    #1913165

  • RE: Are the posted questions getting worse?

    Phil Parkin (11/17/2016)

    jasona.work (11/17/2016)

    Hugo Kornelis (11/17/2016)

    EDIT: To clarify, *some* features that were enterprise only were in my opinion also easy to explain and understand. But not all. Stuff like compression...

    November 17, 2016 at 10:53 am

    #1913162

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (11/17/2016)

    EDIT: To clarify, *some* features that were enterprise only were in my opinion also easy to explain and understand. But not all. Stuff like compression and TDE should,...

    November 17, 2016 at 9:37 am

    #1913135

  • RE: Are the posted questions getting worse?

    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...

    November 17, 2016 at 7:30 am

    #1913063

  • RE: short date q.

    Presuming by "short date" you mean yyyy-mm-dd format, you could do this:

    CONVERT(date, getdate())

    You could also further tune that with the various date style options.

    But, it's possible if this is in...

    November 16, 2016 at 1:19 pm

    #1912912

  • RE: NEWBIE TO THE DBA LIFE

    Another book I'd suggest would be "Troubleshooting SQL Server: A Guide for the Accidental DBA"

    You can get the PDF for free from Red Gate (disclaimer: I don't work for Red...

    November 16, 2016 at 10:08 am

    #1912861

  • RE: Are the posted questions getting worse?

    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...

    November 16, 2016 at 9:18 am

    #1912832

  • RE: Are the posted questions getting worse?

    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...

    November 16, 2016 at 8:57 am

    #1912825

  • RE: Are the posted questions getting worse?

    GilaMonster (11/16/2016)

    Ed Wagner (11/16/2016)

    Care to drop any hints?

    No. Not until the announcements are made.

    Check Twitter later (Grant, Tom LaRock, Kendra, etc) they should be tweeting the highlights (I'm trying...

    November 16, 2016 at 8:38 am

    #1912820

  • RE: Log Shipping: From SS2014 Server to SS2016 Server?

    Gail Wanabee (11/15/2016)

    3) Cannot open backup device "\\serverName\TestLogShipping\TestLogShipping.bak"

    4) Operating system error 5(Access is denied.).

    Those two lines right there indicate a permissions problem.

    As Kevin indicated, make sure the SQL Agent service...

    November 15, 2016 at 12:54 pm

    #1912647

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/15/2016)

    VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

    If I recall, though, to give...

    November 15, 2016 at 7:57 am

    #1912520

  • RE: Are the posted questions getting worse?

    Cool!

    Hmm, now to plan a Mexican vacation with the wife...

    😀

    November 15, 2016 at 7:55 am

    #1912518

  • RE: Are the posted questions getting worse?

    So I get asked about index maintenance and in looking at the table in question for the dev, I notice something...

    Something...

    Off...

    A bunch of columns defined as "VARCHAR(1), NULL"

    :rolleyes::ermm:

    It's not all...

    November 15, 2016 at 7:27 am

    #1912502

Viewing 15 posts - 1,306 through 1,320 (of 2,783 total)