Max DB Size for SQL Server Express

  • Sean Lange (7/24/2015)


    Wow so much complaining about skipping a word in the question. I don't recognize most of the names of those complaining. I suspect that is because they haven't posted their own QOTD.

    Yes it caused me to pause and consider which edition. It didn't take too long to see Express in the title.

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Alvin Ramard (7/24/2015)


    SQLRNNR (7/24/2015)


    Vimal Lohani (7/24/2015)


    where is express edition mentioned in question.

    In the question title.

    Just like many of the forum questions asked. You have to read the title too to get the full story.

    Still hard to do, but it is a lesson learned many moons ago. People tend to put a lot of important information in the title of forum posts and qotd. IMHO - the title of a question is an important part of the question (it has given away the answer many many times). And for those that came from the newsletter link, the question is tagged as Express Edition in that newsletter - just have to read the entire section.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Alvin Ramard (7/24/2015)


    Ed Wagner (7/24/2015)


    Alvin Ramard (7/24/2015)


    SQLRNNR (7/24/2015)


    Vimal Lohani (7/24/2015)


    where is express edition mentioned in question.

    In the question title.

    Just like many of the forum questions asked. You have to read the title too to get the full story.

    Even then, you don't get the full story. I'm consistently puzzled by the questions where there is no question. 😉

    Let's not get started on that one. That's a topic on its own.

    Too late, the cat is out of the bag.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Brian.Klinect (7/24/2015)


    Learned 2 new things today instead of just one 😀

    Woot!

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

  • I'm surprised that somebody working in IT would use that argument. Face it, the question is poorly worded and ambiguous. Clarity is needed in the specification provided.

    Because the question is so ambiguous, should the 524PB have been presented as the correct answer, those who answered 10GB could have been fobbed off with 'it never mentioned Express Edition in the actual question'... The correct answer to the question as presented is 524PB. If asked to take titles, and footnotes into account, then 10GB is the correct answer.

  • michaelf.fitzpatrick (7/24/2015)


    I'm surprised that somebody working in IT would use that argument. Face it, the question is poorly worded and ambiguous. Clarity is needed in the specification provided.

    Because the question is so ambiguous, should the 524PB have been presented as the correct answer, those who answered 10GB could have been fobbed off with 'it never mentioned Express Edition in the actual question'... The correct answer to the question as presented is 524PB. If asked to take titles, and footnotes into account, then 10GB is the correct answer.

    Actually if you want to start splitting hairs there is no correct answer because without the edition the question is incomplete and therefore unanswerable. And when was the last time you actually received specifications with everything spelled out all nice and tidy? I have rarely, if ever, not needed to look beyond the typed verbiage to fully understand a problem in the work environment.

    I can't speak for everybody but getting a QOTD wrong is by no means a reason to get "fobbed off". There is nothing tangible from a good score on the QOTD. They are intended to challenge your knowledge of the topic. Sometimes there are some poorly worded ones or a key work missing (like today's). At the end of the day a right or wrong answer means nothing. If you are worried about your points on SSC you have already "earned" them by posting. If that isn't enough you can have mine. It isn't like you get a free sticker or something by having the most points.

    _______________________________________________________________

    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/

  • michaelf.fitzpatrick (7/24/2015)


    I'm surprised that somebody working in IT would use that argument. Face it, the question is poorly worded and ambiguous. Clarity is needed in the specification provided.

    Which argument? There is no more clarity in this response than in the question itself.

    Because the question is so ambiguous, should the 524PB have been presented as the correct answer, those who answered 10GB could have been fobbed off with 'it never mentioned Express Edition in the actual question'... The correct answer to the question as presented is 524PB. If asked to take titles, and footnotes into account, then 10GB is the correct answer.

    No reason for anybody to get "fobbed" off. It is only one point, and it isn't even the meaning of life point.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I do think the question should have included Express. When I test them, I see the title, so it didn't occur to me and I didn't read it closely enough.

    I've edited the question and will award back points to this time.

  • Revenant (7/24/2015)


    I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

    Make that 6.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Hilarious responses today - Some people need to have a drink and relax a little :w00t:

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • Alvin Ramard (7/24/2015)


    Revenant (7/24/2015)


    I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

    Make that 6.

    Still on page 2 for me. 😛

    _______________________________________________________________

    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/

  • MyDoggieJessie (7/24/2015)


    Hilarious responses today - Some people need to have a drink and relax a little :w00t:

    ding ding ding

    :hehe::cool:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Sean Lange (7/24/2015)


    Alvin Ramard (7/24/2015)


    Revenant (7/24/2015)


    I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

    Make that 6.

    Still on page 2 for me. 😛

    Same here;-)

    Can we drive this into a new entity of "THE THREAD"?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (7/24/2015)


    Sean Lange (7/24/2015)


    Alvin Ramard (7/24/2015)


    Revenant (7/24/2015)


    I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

    Make that 6.

    Still on page 2 for me. 😛

    Same here;-)

    Can we drive this into a new entity of "THE THREAD"?

    :w00t:

    ... Come on Hippo. Let's go for a walk in the desert.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 46 through 60 (of 72 total)

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