I'm not sure if my experience is typical, but every DBA I've known has been asked by management to "teach the basics of SQL to the team". And they all had their own stack of PowerPoint slides to teach people how to join tables and use GROUP BY. It's far from a good use of their time (why not br...
@JackDouglas if he means: create a one time library of so called basic Questions and answers so in the future we can always redirect people with similar questions to these existing ones, I would say +1
Well I dont really mind if the default q/a is hosted on SO or on DBA, what I'm bothered about if we go for the " closed because of to basic" approach. that you leave a newby out in the cold. At the minimum I should point him to a source where he can find his/her answer
I have no objection to basic SQL questions here, so long as they are good questions. The line between basic and not-basic has always seemed illusory to me.
@JackDouglas I don't like the idea either. I was always under the impression that DBA was for more advanced DB stuff including SQL - basic stuff goes to SO
@bluefeet if we are the expert board then we should make sure all are answers are of expert quality even for simple questions:
-1 because copy only option with a full backup has nothing to do with LSN chains. Itresearcher pointed that out but you didn't update/delete your answer. — Edward Dortland6 hours ago
@JackDouglas but I also see the argument that DBAs still need to learn basic SQL and coming to DBA would be helpful - but it is a catch-22 because we open ourselves up to crap!
@JackDouglas I'm not so sure. There really aren't all that many good basic SQL questions. Once enough good answers exist, new ones just close as a duplicate. Hard to see how high-rep low-knowledge users could arise from that.
@MarkStorey-Smith no need to answer the actual question: just, you are a complete beginner, never mind your actual problem go away and learn some basics.
@JackDouglas We don't have that many super-active users with the ability to VtC questions. It wouldn't be so hard to get into the habit of closing as duplicate instead of VtC to move to SO, too localized or whatever people do right now.
@MarkStorey-Smith The Oracle Database Concepts guide isn't that well know but is a great place for an overview. I think there are folk that are worth helping who would not know what to Google.
@Mark if that is the case, Why should we act on Basic questions at all? Lets just auto delete them if they didn't generate a truly "added value" answer?
leave them on for x perdio of days and them auto clean...
I can totally understand that if you've been here for a long time that the same old question drive you crazy.... but my point is, that closing questions qith just the reason. To basic, bye bye, sound to arogant, and at the minimum is not helpful...
@EdwardDortland Fair point. The close reason does have an explanation as to why a Q was closed however and a link to the relevant portion of the FAQ. Consider also that the majority of this type of questions arise from unregistered users that have no interest in participating here beyond getting someone to fix their current problem.
@mark @PaulWhite, that why autoreculating might be the best thing. If nobody bothered to answer, then the community apperently found the question not interesting enough... You'll never have decission on a personal level.
That still doesn't deal with the M.ali situations ;-)
There may be value in maintaining a short per-product list of links to official documentation and maybe books we could recommend as part of the site FAQ. Not at all sure about the need for a close reason to point to it though. The ones we have already seem sufficient to me.
@EdwardDortland Hm. Seems a bit unfair on good questions where someone able to answer it hasn't encountered it yet. Don't bad questions (heavily down-voted, no answers) already get deleted after x days?
@EdwardDortland take a poll of how many questions - regardless of complexity - go unanswered for very long. The list is very small, and usually it's the too complex ones that people can't answer. There's always someone willing to get rep for simple questions (this is one of the negative aspects of SO IMHO).
@PaulWhite probably true, but if we add a link to the close reason, and/or are diligent about pointing people there in comments when they do ask simple questions
Shame, because to create a CW list of references using the Q & A format, we'd have to break our own rules. A question like "what are good/official resources for learning SQL in Product x" would be closed as too broad, shopping list etc.
OTOH "Where can I find the official Oracle database concepts documentation?" seems quite reasonable. Why doesn't it exist?
@PaulWhite In Sydney for a wedding 24th Feb to 3rd March, then visiting friend in NZ until 13th. In Auckland, out Welly, majority of time around Napier.
Long Story Short... my Database server died a month ago. I restored everything but the MSDB as the tape backup failed. I reconstructed some jobs but some essential ones are missing. I finally found the MSDB backup in an old partition, but here's the gist... it isn't a .BAK file but the actual dat...
All,
I am running into a deadlock in SQL Server 2008.
Using a profiler I was able to determine that the deadlock happens as I am trying to select and update row(S) in table in 2 different sessions.
The select query from the profiler is shown below
select
nodeinstan0_.id as id35_,
nodeinstan0...
Real life example from Edinburgh
The table below holds data for some popular pubs in the city.
Name Capacity Area
Brass Monkey 100 Centre
Tourmalet 100 Leith
Cask and Barrel 70 Leith
Captains 60 Centre
There are no functional dependen...
@bluefeet What's is got to do with Clustering? Seems a very specific (localized) question. A better, more general question would likely be closed as duplicate of:
Recently one of our ASP.NET applications displayed a database deadlock error and I was requested to check and fix the error. I managed to find the cause of the deadlock was a stored procedure that was rigorously updating a table within a CURSOR.
This is the first time I've seen this error and d...
@PaulWhite As part of the answer to a question about good SQL resources, it would seem to me meta enough. I think the more reasonable part of common shopping list questions about SQL could reside on Meta.
@JackDouglas It would be a FAQ resource that this community could manage, unlike the standard help FAQ. But Paul is correct, I was actually somewhat confused indeed. If Meta is about the (main) site, but not about the subject of the main site, then my suggestion is irrelevant
All,
I am running into a deadlock in SQL Server 2008.
Using a profiler I was able to determine that the deadlock happens as I am trying to select and update row(S) in table in 2 different sessions.
The select query from the profiler is shown below
select
nodeinstan0_.id as id35_,
nodeinstan0...
Real life example from Edinburgh
The table below holds data for some popular pubs in the city.
Name Capacity Area
Brass Monkey 100 Centre
Tourmalet 100 Leith
Cask and Barrel 70 Leith
Captains 60 Centre
There are no functional dependen...
