Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Is this right if i will do my project this way?.. Expand / Collapse
Author
Message
Posted Tuesday, October 01, 2013 9:51 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 21, 2013 3:10 AM
Points: 81, Visits: 191
Hi Everyone..I hope everyone is having a nice day


Is this right if i will do my project this way?

Please see my attachment


  Post Attachments 
MyProject.jpg (93 views, 62.81 KB)
Post #1500646
Posted Wednesday, October 02, 2013 1:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:27 AM
Points: 12,175, Visits: 9,120
What kind of project is this?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1500670
Posted Wednesday, October 02, 2013 1:54 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:47 AM
Points: 41,502, Visits: 34,418
Normally you'd go a lot further into the design phase before considering physical implementations.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1500685
Posted Wednesday, October 02, 2013 7:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:19 AM
Points: 7,002, Visits: 6,181
Your picture doesn't give a lot of detail and your question is just as vague. What do you define "right" as? What are you trying to accomplish?

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1500781
Posted Wednesday, October 02, 2013 8:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 5:41 PM
Points: 35,944, Visits: 30,229
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day


Is this right if i will do my project this way?

Please see my attachment


If it's strictly an ETL project, maybe. Otherwise, probably not.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1500787
Posted Wednesday, October 02, 2013 8:44 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:28 PM
Points: 20,453, Visits: 14,063
To me it looks like all of the arrows are going in the wrong direction.

You have a class that populates a dataset and that class also gets shipped off to a server.

It looks like there is nothing being done with the dataset.

With nothing being done by the dataset and the apparent misdirection of the arrows (assuming), I would say it looks completely wrong.

Then again, we have no real project requirements to make any determinations of right or wrong.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1500800
Posted Wednesday, October 02, 2013 6:34 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 21, 2013 3:10 AM
Points: 81, Visits: 191
SQLRNNR (10/2/2013)
To me it looks like all of the arrows are going in the wrong direction.

You have a class that populates a dataset and that class also gets shipped off to a server.

It looks like there is nothing being done with the dataset.

With nothing being done by the dataset and the apparent misdirection of the arrows (assuming), I would say it looks completely wrong.

Then again, we have no real project requirements to make any determinations of right or wrong.



SQLRNNR...i think you are the only one who get it right...thanks for the advise my friend
Post #1500954
Posted Wednesday, October 02, 2013 6:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 21, 2013 3:10 AM
Points: 81, Visits: 191
my classes contains a connectionString to a different server, because every server contains a different databases, so meaning in every classes i have different connectionString that will open the connection to a certain database....and mydataset contains all tables in a certain database...


Is this clear explaination? or should i elaborate more my friends(ladys and gentlemen) ?....

cheers
Post #1500956
Posted Wednesday, October 02, 2013 6:44 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 21, 2013 3:10 AM
Points: 81, Visits: 191
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day


Is this right if i will do my project this way?

Please see my attachment


If it's strictly an ETL project, maybe. Otherwise, probably not.


What do you mean ETL project??...



"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
Post #1500957
Posted Thursday, October 03, 2013 12:25 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:47 PM
Points: 22,472, Visits: 30,138
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day


Is this right if i will do my project this way?

Please see my attachment


If it's strictly an ETL project, maybe. Otherwise, probably not.


What do you mean ETL project??...



"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan


ETL - Extract, Transform, Load

Usually done when moving data from OLTP databases to DW databases.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1501004
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse