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 ...
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 ║
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 ...
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 ...
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.
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 ...
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 ...
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
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, ...
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.
Based on Crow's Foot notation:
Intended meanings as drawn (artistic licence employed):
One (and only one) Database Administrators site
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 ...
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 :-)
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 ...
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 ...
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 ...
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 ...
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:
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.
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 ...