@MDCCL Yes, in my opinion. By the way, if you want to suggest a duplicate before you get the vote-to-close privilege, simply flag the question "should be closed...". This will put it in the review queue for close votes.
@TomV Same reason that a column is called GrosProfit in one table, and GrssProfit in one of its child tables. I don't know whether it's due to laziness, or plain stupidity. Possibly a combination of the two over the years.
I've been tempted to create views over the top to give everything sensible names
i am developing a one type of chatting website.
In this site all user can chatting through group even also upload images, video, pdf, music etc..
I don't know this type of website what is the major data for creating dictionary.
Please give me a suggestion ...
@Phil I've seen this sort of thing done for AS/400 systems, where the column names in DB2/400 are restricted to 8 characters. At one point I wrote a script that read data from a policy admin system vendor's data dictionary and generated a set of views from their 'short description' entries. You could actually sensibly run ETL or do data profiling from the views.
As I understand, table and column names in SAP are typically abbreviations of German words (or at least were historically). They're quite famous for being obtuse.
If you build something like that anybody who actually has to do reporting or data extracts from the SAP system will probably love you and want to have your children.
This can be done, very efficiently, too. Not in a single statement, though, since SQL demands to know the return type at call time. So you need two steps. The solution involves a number of advanced techniques ...
Assuming the same table as @Denver in his answer:
CREATE TABLE hstore_test (
id ...
Not certain if that is generic or specific to hstore in some way, but it does link to another answer on SO:
If you have not installed the additional module tablefunc, run this command once per database:
CREATE EXTENSION tablefunc;
Answer to question
A very basic crosstab solution for your case:
SELECT * FROM crosstab(
'SELECT bar, 1 AS cat, feh
FROM tbl
ORDER BY bar, feh')
AS ct (bar t...
Although in MS SQL (not Express) I have a limit of 10GB per database
This question of mine went in an another direction. I don't want to delete it, because I believe it can serve someone someday. But I think that the question should be titled differently. Is it OK to change the question title to...
Failed to exec query: SQLSTATE[HY000]: General error: 4004 General SQL Server error: Check messages from the SQL Server [4004] (severity 16) Helpful :(
Aha. The dodgyness I'm using doesn't like ntext columns. Had to cast it to a varchar
I have seen a rumour to the effect that the SAP R/3 database schema runs to 40,000 tables in all its glory.
Back in 2000 or so - when the Sun E10K was state of the art - they still featured quite significantly in the top 500 super computer list, but the biggest single user base of E10K systems was actually ERP users.
Think about it - people using the same model of kit that featured in the top 500 supercomputer list to run their accounts and inventory.
From insearchofstupidity.com:
ERP
Acronym for enterprise resource planning. A class of software designed to integrate every aspect of a company's operations, from customer service to warehouse management. Frequently, use of these products requires a business to "reengineer" its business processes, which in turn often leads to the need to placate angry customers who are receiving multiple bills for items they didn't order. This helps drive purchases of CRM software.
I have the following stack:
.NET 4.5.1
IIS 7.5
SQL Server 2008 express SP 4
Visual Studio 2015 update 5
SENSENET 6.5.2.8421
Windows 7 SP1
I tried to install SENSENET importing the package using the deploy option within IIS, but when creating the data base this shows up:
Microsoft.Web....
question was re-posted here, but doesn't really seem on-topic even though the original question had a comment it would be a fit here
This is a question you better ask on dba.stackexchange.com. This deals with database administration. You will have better chance of getting a good answer there. Also do not post a screenshot of the exception trace, copy the text, paste it in your question (use a code-block to make it more readable). — TT.9 hours ago
@PaulWhite Indeed, I find it very interesting. I'm thinking about adding an answer with some personal suggestions that I consider useful in order to create accessible (and, potentially, more succesful) modeling and/or design questions, but I'm not sure if that's the right place to post something like that...
@PaulWhite Yes, now that you bring it up, I definitely should have proceeded that way, I didn't recall that suggesting a duplicate would put the post in the review queue :)
Has anyone had this issue? Application has big delays connecting to SQL Server using the SQLNCLI provider but connects instantly using SQLOLEDB. Where to look to even start resolving this?
The client took the servers down the day before yesterday "to move racks". The issue appeared after they restored access. (Before the event there were no delays using either provider.) I'm not sure what could change and I'm not sure if it's even our problem, but it would be nice if we didn't have to rewrite the app to use a different DB provider as a resolution of this.
Everything I'm finding so far seems to be general questions about how to get past the delays rather than how to eliminate/reduce them
(So people are advised to increase the connection timeout, which indeed helps me to connect through SSMS but isn't the right solution for our app.)
Weird. That's about all I got. It doesn't make sense that there'd be a routing issue specific to CLI so that's out. I suspect there's some trace you can turn on somewhere whether it's a Fiddler clientside or something serverside to see the steps the connection goes through but logically, it doesn't make sense that one would be fine whilst the other isn't
if you RDP onto the server and open a connection to localhost, both via ole and CLI, does it present with the same symptoms? Restarted the service?
@billinkc Restarting the service is out of question at this point, this is a production server and it's the client's working hours now. What I've tried was creating a test .udl and playing with providers. On the SQL Server machine, both Native Client and SQLOLEDB connect instantly. Over the network, however, I couldn't make Native Client connect at all. (More specifically, it was Native Client 10.0, both locally and remotely.) SQLOLEDB connected fine, as I said before.
I mean, I couldn't make it connect using the same timeout I set for SSMS. I guess I'll try to increase it and see if it can connect at all.
I'm preparing to delete this as it is considered incorrect
Subject Name is also a non-prime attribute and it depends on part of the primary key Subject Code (breaks rule - there must not be any partial dependency of any column on primary key).
This is prohibited in 2nd Normal Form and should th...
This is really strange. It's only the hash right join that takes so much longer. I wonder if the number of columns exceeds some threshold that causes this. You probably should post that to the Postgres performance mailing list. — a_horse_with_no_name9 mins ago
aka 'How many DBAs do you need for installing Oracle?'
@a_horse_with_no_name also the hashing that precedes that join has an enormous amount of batches. It seems that work_mem is very limiting in the second case - no idea why (if the tuple width estimation if the planner is correct). — dezso14 secs ago
could someone else please say "yes optimise your queries then"
Queries are taking almost 5-15 min. 15 min for those dimension which has huge amount of data and 5 min for small dimension. As I have primary key defined on the identity key and I can see that SQL Server has generate a simple execution plan for that. I don't think I can optimize that. Nevertheless, I appreciate your response & I've marked this as an answer because what you have answered is perfectly valid. — Zerotoinfinityyesterday
the simple plans I bet are "clustered index scan > select"
Maybe we attract a sort of questions in the SSAS tag with less experienced, sort of "hey i'm de db dude I inherited this" questions you can't really answer in a single go because a lot of the basics lack and then you end up explaining
@Zerotoinfinity when seeing the word 'optimizing', one usually expects an actual query execution plan. Could you add one to your question? — dezso23 secs ago
I have been thinking about moving some of the discussion into the answer, but that would blur it too much and make it less of a general answer and more of a personal troubleshooting session
originally I hoped he would run with it and then I would have told him to post his query as a different question but that didn't work out
One more option: delete from both tables in one statement: DELETE f, u FROM user AS u LEFT JOIN feedback AS f ON u.user_id = f.user_id WHERE u.user_id = ? ; — YperSillyCubeᵀᴹ3 hours ago
i am developing a one type of chatting website.
In this site all user can chatting through group even also upload images, video, pdf, music etc..
I don't know this type of website what is the major data for creating dictionary.
Please give me a suggestion ...
I have the following stack:
.NET 4.5.1
IIS 7.5
SQL Server 2008 express SP 4
Visual Studio 2015 update 5
SENSENET 6.5.2.8421
Windows 7 SP1
I tried to install SENSENET importing the package using the deploy option within IIS, but when creating the data base this shows up:
Microsoft.Web....
Sorry.actually I want to add comment but unexpectedly I posted it.
