We’re rewarding the question askers & reputations are being recalculated! Read more.
59

Howdy© and Welcome aboard®! We're glad you chose dba.stackexchange.com for assistance with your homework a production emergency writing your non-trivial query. When you need help writing a Query From Scratch©, the first thing to do is make sure the query you're writing doesn't already have a lot of common answers. Some of the most popular query writing ...


32

SQL Server What's the difference between a temp table and table variable in SQL Server? What's the difference between a CTE and a Temp Table? Why use both TRUNCATE and DROP? Does restarting SQL Server speed it up? Q: Should I use NOLOCK? Is NOLOCK always bad? Justify NOT using (nolock) hint in every query Why Does the Transaction Log Keep Growing ...


31

If you have tab-delimited text you can use this web site tool to convert it into a table, either in 'MySQL' or 'Unicode Art' style, eg: +-------+-------+ | LEVEL | DUMMY | +-------+-------+ | 1 | X | | 2 | X | | 3 | X | +-------+-------+ ╔═══════╦═══════╗ ║ LEVEL ║ DUMMY ║ ╠═══════╬═══════╣ ║ 1 ║ X ║ ║ 2 ║ X ║ ║ ...


31

Probably obvious from the tone of my question, but even though I prefer upper-case keywords, I don't feel it is our job as editors or reviewers to encourage and even reward behavior that is merely the enforcing of one's preferences onto others. I understand that often the intent is to improve the post. But on its own I don't think this should be a valid ...


31



30

Jack, first forgive my English, is not as fluent as I would like. I don't know you personally, I've been in this community for 2 years and 11 months, and we have regularly met in the chat room. Honestly, I think you are one of the most fair and impartial moderators here, and this is very important. Always willing to help users, regardless of the level of ...


28

Is there a rule where the spelling of answers has to be in "American"? No. See What should the standard spelling be - British or US? From that meta Stack Exchange Q & A's accepted answer by a Community Manager: Does SOFU have an accepted standard on language and spelling? Which is it? For bodies, no. For tags, US-English. ...


27

Personally, I think this is dangerous to allow. Licensing is a vast landscape and there are mines everywhere. Being out of compliance is something that can get you and your company into serious hot water. Pulling up some Stack Exchange answer in the middle of an audit with Microsoft Legal is not going to get you off the hook. Ask yourself this: Do you want ...


26

No - it is just fine as it is.


24

Bring on the hats. edit: jcolebrand: Please no downvotes. We will ignore them. Unless it's just that cathartic for you.


24

Similar ideas have been popping up on meta.SO. Popup requesting people to specify a DBMS when they tag a question with the tag SQL? sql tag without provided RDBMS I am all for it. My favorite would be to enforce the declaration of a basic (DBMS) tag. We'd need some sort of db-agnostic tag to go with that, but with simpler wording - many people won't ...


24

Yes dba should be burninated because it... Isn't useful to connect experts in a topic area to questions they can answer Doesn't help describe the content of the question Doesn't add any meaningful information to the post Is ambiguous in that it could refer to the person or the role of a DBA Is simply the (abbreviated) name of the site


24

I'm going to give you some public tough love, but only since you asked. Your answers aren't actually all that good. Take this one: Will DB session terminate when client close DB connection The answers you posted don't actually answer his questions. They're good information, yes, but they're not answering the questions. If you want to earn points, ...


24



24

It's a sad day for Database Administrators.


23

As a lower-volume site compared to, say, Stack Overflow, we're able to manage behavior much more reliably, and we just don't get a lot of the nonsense that is inevitable with higher volume. We're also constrained to people who work with databases, rather than all people who touch computers, and that tends to weed out at least a little bit of the vitriol. I ...


23

Based on Crow's Foot notation: Symbol reference: image source Intended meanings as drawn (artistic licence employed): One (and only one) Database Administrators site Many questions Zero or many site achievements Zero or one featured meta questions (typically; of course right now we have two) The far terminator is currently a circle. I guess this could ...


23

Jack, as the person that thanked me for my first few answers & encouraged me to join The Heap, I'd like to thank you for the time you have invested in DBA.se & also for the work you have put into dbfiddle.uk. You will be missed. Please don't be a stranger :-)


22

For me the best option would be #3 - save the file as .sqlplan and post it somewhere that does not require a login to download. You want to make obtaining the file easy, not hard, for people trying to help you. Saving as a .sqlplan makes it easy for us to open it in Management Studio, Plan Explorer, etc. The problems with the other methods: A picture in ...


22

Thanks for bringing this up on meta so constructively. The consensus here is that we use the term 'SQL Server' and not MSSQL - it might not always merit an edit just to make that change but it's always preferred. Although the abbreviation MSSQL is often used, it tends to be by those who know the product less well - I just did a quick survey of blogs by ...


22

Ask a new (follow-up) question, including a link to the previous one if it provides useful context. The new question should still make sense on its own, of course. As a general rule, it is better to start a new question when a question edit would invalidate good answers. We don't charge by the question (but please don't go nuts - a hundred similar, very ...


22

These types of questions are harmful to the site and should be quickly closed and probably deleted. I know that SO has a no-shopping-list questions policy, and this feels like a shopping-list. It's not just SO, this has been established network wide for a long time. Just two meta.SE examples: List questions: Community Wiki? What is the definition of a ...


22



22



21

We do have issues with folk sometimes doing pointless edits or putting in minimal effort because they are after a badge or something, so we sometimes get a bit trigger-happy. In this case, I think you've taken the flak for others and your own edits are mainly fine so I've lifted the review ban. Thanks for not getting huffy about this and bringing it to meta ...


21

It is jarring, but taking the background colour away entirely leaves it hard to tell what is code and what isn't: I think we should consider a third option, ether a lighter grey: Or something else: Just for reference, this is what we currently have:


20

The obvious solution is to let answers that are "plain wrong" be downvoted into oblivion - where they will serve a useful purpose advertising their wrongness :) The problem is that there are two kinds of votes: informed votes from people who could have answered the question themselves or who have taken the time to double check the answer all other votes (...


20

I agree with Leigh's suggestions (see comments on the question): Remove wording from the site indicating that basic SQL is not allowed. I'm not sure if I would promote it, simply not ban it. Stop migrating basic SQL questions to Stack Overflow.


Only top voted, non community-wiki answers of a minimum length are eligible