Max DB Size for SQL Server Express
-
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.
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]
-
mark.hanson 59091 (7/24/2015)
"Nice easy one today!" - 48% of us disagree 🙂Now up to 60%. I'll take that upon myself for not reading the title as well as the question! :pinch:
-
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.
Not considering the title at all for a moment, the question itself should bring to mind the edition, as it's a factor in the answer. For example, if I asked a question about LEAD, you should know I'm not on 2008. If I asked a question about the resource governor, you should know I'm not on Standard Edition.
I got the question wrong and I have no one to blame other than myself. Yes, I thought of the edition, but I didn't look at the whole problem (the title) to find the edition.
-
I only read the title and got it right. 😛
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]
-
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. 😉
-
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.
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]
-
Ed Wagner (7/24/2015)
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.
Not considering the title at all for a moment, the question itself should bring to mind the edition, as it's a factor in the answer. For example, if I asked a question about LEAD, you should know I'm not on 2008. If I asked a question about the resource governor, you should know I'm not on Standard Edition.
I got the question wrong and I have no one to blame other than myself. Yes, I thought of the edition, but I didn't look at the whole problem (the title) to find the edition.
You my good friend were not one of the people I considered as complaining. 😉 Much like you thought, without the edition the question is incomplete. I looked around a little bit and noticed the edition in the title.
_______________________________________________________________
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/ -
edwardwill (7/24/2015)
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.
It was a bad question. No, I haven't submitted my own QOTD but you can be sure that, if I did, I'd take a little bit more care about it.
We will have to agree to disagree on that. The question was not a bad question. It is in fact a good question. It was however unfortunately missing an important word due to a typo. Keep in mind the people behind these questions get paid the same as you do for answering them. And more importantly they are people just like you and me which means they are highly prone to making mistakes from time to time.
I have seen a fair share of the QOTD around here and trust me when I say this. There is nothing like a really bad question, and this one is nothing like a really bad question.
_______________________________________________________________
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/ -
Sean Lange (7/24/2015)
Ed Wagner (7/24/2015)
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.
Not considering the title at all for a moment, the question itself should bring to mind the edition, as it's a factor in the answer. For example, if I asked a question about LEAD, you should know I'm not on 2008. If I asked a question about the resource governor, you should know I'm not on Standard Edition.
I got the question wrong and I have no one to blame other than myself. Yes, I thought of the edition, but I didn't look at the whole problem (the title) to find the edition.
You my good friend were not one of the people I considered as complaining. 😉 Much like you thought, without the edition the question is incomplete. I looked around a little bit and noticed the edition in the title.
I know. I saw immediately that the question was incomplete, but didn't look as well as you did to find the missing piece. Granted, I didn't put much effort into looking. Maybe it's because I don't do much with Express Edition or maybe it was because I wasn't caffeinated enough yet. 😛
-
Another victim of missing the title....
-
I didn't even know the questions had titles. I read the question in the newsletter, and then look at the answer options when I pick "Click Here" to answer. Learned 2 new things today instead of just one 😀
-
Leaving aside the sloppy way in which the title and the body of this question have been put together, can I make a plea for obliging question writers to put as much effort into their wording as SQL Server's syntax checking obliges us to do with our code?
This question so badly worded that all my brain says is: "Syntax error".
Kenneth Spencer
You never know: reading my book: "All about your computer" might just tell you something you never knew!
lulu.com/kaspencer -
kaspencer (7/24/2015)
Leaving aside the sloppy way in which the title and the body of this question have been put together, can I make a plea for obliging question writers to put as much effort into their wording as SQL Server's syntax checking obliges us to do with our code?This question so badly worded that all my brain says is: "Syntax error".
Kenneth Spencer
Exactly what I was thinking. Of course, the provision of a QOTD is a free service, for which we are all, I'm sure, very grateful (and caveat emptor, you get what you pay for, etc. etc). Some of them are quite complicated, with lots of DDL, creating data etc. This was not. The question itself was fine, in and of itself. The execution was a bit on the sucky side.
-
edwardwill (7/24/2015)
Richard Warr (7/24/2015)
edwardwill (7/24/2015)
Another terrible question. Only 16 words in the question - you could have extended it to 18 by adding "Express Edition".This was the question titled "Max DB Size for SQL Server Express"?
Mind you, 55% wrong answers - it does show how easily things can be missed.
No, it's the question that appeared on my daily newsletter "What is the maximum relational database size of the SQL Server 2014 edition can grow to?". Somehow, the author lost his typing skills just before the word "edition". It should have read "What is the maximum relational database size of the SQL Server 2014 Express edition can grow to?"
Of course, it's perfectly possible that this was the author's intent. In which case, it's pretty tragic.
The newsletter can be a little misleading - true. The express edition is easy to miss there.
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 -
michaelf.fitzpatrick (7/24/2015)
And no mention of SQL Server Express in the 'Question of the Day' in the SQLServerCentral daily dispatch....It's there but it is easy to miss.
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
Viewing 15 posts - 31 through 45 (of 72 total)
You must be logged in to reply to this topic. Login to reply