|
Message Closed
modified 11-Nov-16 17:44pm.
|
|
|
|
|
Your signature (Jassim) points to a site seems to be commercial... It is not really accepted here and can cause you to be banned for spamming...
Please remove it (or restore it to its previous value - your personal site)!
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
I suspect it may be a site he created, or at least customised the template for!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Not enough info, how's your tables looking like?
|
|
|
|
|
In employees table:
- employee_number
- first_name
- last_name
In employee_job
- employee_number
- reporting_to (refers to employees->employee_number)
Technology News @ www.JassimRahma.com
|
|
|
|
|
I have table for instructor in university
This center give courses for programming language specialized to Microsoft product
this interface as following in image .
Simple File Sharing and Storage.[^]
SQL,c#,access,c++ courses that given by center
D(4),G(2),G(5),G(6),G(3) is sections
B.A ,I.S is departments of year in university
university consist from 4 year as following department as (INFORMATION SYSTEM (I.S) OR BUSINESS
ADMIN(B.A)OR TRADE ENGLISH (T.E)
I make ERD design as following :
This ERD for interface above
Can you tell me are this design is true for table above .
Simple File Sharing and Storage.[^]
|
|
|
|
|
DayNo => DayID in section is probably not a good idea.
Instead of using ID for every primary key use tablenameID, sql server will do a lot more work for you.
The structure looks ok.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The instructor table looks a bit odd to me, having both ID and InstructorID I would assume you meant InstructorID and InstructorName .
And as an addition to what Mycroft said, in a fully normalized database you always use the same name for an entity throughout the database. It's not just a good idea, it's a standard[^].
And just like Mycroft said, for a surrogate key, using <tablename> + "ID" is a good idea
|
|
|
|
|
What is the most complex SSIS package you have worked on? What did you learn from its implementation?
|
|
|
|
|
|
Actually SSIS is very much databases. It is a tool to transfer data from one data source to another.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
So we are now allowed to discuss resharper in the C# forum? It is a tool for C# after all
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Where would you suggest posting a discussion on SSIS? Is there a forum that you think is more appropriate than this one?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
It's really a Lounge discussion subject, it's not a technical question.
|
|
|
|
|
Richard MacCutchan wrote: Lounge discussion subject, Could be, but I would bet if OP put it in the Lounge they'd get flamed by many.
Richard MacCutchan wrote: it's not a technical question. It's a good topic for discussions, which is what these forums are, discussions. However, I now notice that at the top of the discussions forum it says "how to ask a question."
Personally, I see QA as quick questions with direct answers and these discussion forums for discussions. I found it very appropriate.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: if OP put it in the Lounge they'd get flamed by many. I don't see why, as it is not a programming question, more a general request for opinions and experiences. Plenty of similar discussions appear in the Lounge. I know these forums are titled "Discussions", but in reality they are for asking Technical Questions.
|
|
|
|
|
RyanDev wrote: Where would you suggest posting a discussion on SSIS? The Lounge.
RyanDev wrote: Is there a forum that you think is more appropriate than this one? Nope. Are you suggesting we need a new forum for SSIS or tools?
Just wondering how this would reflect on the C# forum, and no, I don't have a decent answer.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: need a new forum for Tools? No, we already have Facebook, er, I mean the Lounge.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
"The Lounge" was answered in jest, but it should be allowed there; it's not a programming question.
The C# forum would become a very broad subject if we discussed/accepted each utility available.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Not sure why you were downvoted but I think this is a great discussion topic. I upvoted to help counter it.
I used SSIS very little, thank goodness.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Ignore Richard and the bastard, this is an appropriate question in the correct forum.
Unfortunately your question is a little too broad to elicit a reasonable response. SSIS is such a wide subject.
I do know that we moved from ETL to ELT where the transforms are done via stored procedure. It is faster and I find it easier to debug and test. So SSIS just moves the data from the source into staging tables and launches the transform stored proc.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
1] What should I write in Timeout Attribute to achieve maximum timeout limit ?
2] Is there any change needs to make in IIS6 ?
3] What is the maximum limit ?
<authentication mode="Windows"><forms loginUrl="~/Account/Login.aspx" timeout=""/>
|
|
|
|
|
0 = unlimited timeout
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
put Maximum value in timeout value timeout=100000
|
|
|
|