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»»

A Database with 70 Table Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 3:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 6, 2014 6:12 AM
Points: 53, Visits: 165
hi everybody
I Have Database With 70 Tables and this my first time that i have alot table in my DB. I want Any Subject or Topic that is Good for me With This situation Secuirity or optimization or etc.
Post #1361032
Posted Tuesday, September 18, 2012 3:18 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:31 AM
Points: 999, Visits: 13,473
Wow, large subject area there. Maybe start with a couple of questions about the key things you want to find out about. The articles on the left there is probably a good start
Post #1361034
Posted Tuesday, September 18, 2012 3:25 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 9:11 PM
Points: 23,070, Visits: 31,598
That is a very small database. Wait until you work with a system like PeopleSoft with 50,000+ tables. Good thing the application handles the security there.



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 #1361036
Posted Tuesday, September 18, 2012 3:29 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 13,126, Visits: 11,964
That is not a large topic, it is more like I have lost a grain of sand somewhere in the Milky Way, how do I find it? There are hundreds and hundreds of entire books on the topics you mentioned. Just a general shotgun blast approach isn't going to gain you much insight. Are you a dba by choice or an "accidental dba"? The direction depends greatly on your experience and knowledge of computer systems, networks, sql server etc. And fwiw 70 tables is quite a small db. Best thing is to figure out a specific topic and research it.

--edit--
Lysdexia strikes again.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1361038
Posted Tuesday, September 18, 2012 3:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:14 PM
Points: 6,171, Visits: 7,237
vahid.arr (9/18/2012)
hi everybody
I Have Database With 70 Tables and this my first time that i have alot table in my DB. I want Any Subject or Topic that is Good for me With This situation Secuirity or optimization or etc.


70 tables isn't necessarily a lot. I realize it's large to you however, so I'm not dissing it, but it's really just the tip of the iceberg.

What's going to interest you primarily here is joins and query optimization for starters. The security and maintenance should be in the hands of the primary DBA, and you can use him as a resource for that. You'll initially want to investigate indexes, data normalization, and other basics of DB design. There's a series of stairway articles you'll see in the left navigation panel when you're looking at this under 'Stairways'. This is an introduction series to all sorts of different areas of databasing.

Welcome to the neighborhood. First step in a long road and all that jazz. If you have particular questions we'll help you find answers, but you're going to have to self-train a *lot*. I particularly recommend you pickup a book for SQL Server, preferably in whatever version you're running at work. Make sure it discusses normalization, table structure, views, query building, optimization, and general maintenance. Most basic books for that will cover those topics.

If you'll also notice, on the left, there's a 'books' section. These are FREE e-books. Troubleshooting SQL Server: A guide for the Accidental DBA is an excellent resource to get yourself started. You won't necessarily understand everything at first, but it'll show you where a lot of the trouble spots are to get yourself going on.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1361039
Posted Tuesday, September 18, 2012 4:51 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 8:06 PM
Points: 36,786, Visits: 31,243
vahid.arr (9/18/2012)
hi everybody
I Have Database With 70 Tables and this my first time that i have alot table in my DB. I want Any Subject or Topic that is Good for me With This situation Secuirity or optimization or etc.


Heh... it's easy... deny privs to everyone except to execute stored procedures while this DB is still small enough to "take control" like this.


--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."

(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 #1361055
Posted Wednesday, September 19, 2012 12:46 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 6, 2014 6:12 AM
Points: 53, Visits: 165
Well Thanks to all this are the things that i have doubt about it.specialy number 4:
1- i have table with 40 fields that it have 10 image Type field (varbinary(max)).image SIZE are between 15MB to 100mb
2-i have some tables that have many to many relationship i use table between them(junction table).how can i speed up them?i mean wheter or not use index in junction table for speed up?
3-what is deferent between unique constraint and uniqe index ?
4- i have tables that have relationship together and have one field in both them.is this happen in DB design?
Post #1361154
Posted Wednesday, September 19, 2012 8:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 13,126, Visits: 11,964
vahid.arr (9/19/2012)
Well Thanks to all this are the things that i have doubt about it.specialy number 4:
1- i have table with 40 fields that it have 10 image Type field (varbinary(max)).image SIZE are between 15MB to 100mb


What is the question here. Seems a bit overkill to have 40 varbinary(max) columns in the same table. I suspect normalization would help here but with no more details it is impossible to tell.


2-i have some tables that have many to many relationship i use table between them(junction table).how can i speed up them?i mean wheter or not use index in junction table for speed up?


I assume you must have queries that are running slow? There is no magic go fast button or indexing scheme that will work for everything.


3-what is deferent between unique constraint and uniqe index ?


They are very similar. This should explain it better than I can. http://msdn.microsoft.com/en-us/library/ms187019.aspx


4- i have tables that have relationship together and have one field in both them.is this happen in DB design?

[/quote]

I am not sure I am following your question. It sounds like you have some foreign keys perhaps?


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1361372
Posted Wednesday, September 19, 2012 10:46 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 6, 2014 6:12 AM
Points: 53, Visits: 165

What is the question here. Seems a bit overkill to have 40 varbinary(max) columns in the same table. I suspect normalization would help here but with no more details it is impossible to tell.

Attention I Have A table with 40 field that 10 of them is image type (varbinary(max)).



I am not sure I am following your question. It sounds like you have some foreign keys perhaps?


i have a table with initial Info and Table that every month become update with new info in this tables i Have Two fields that are Same i cant change it. is this happen in DB Design?




Post #1361730
Posted Wednesday, September 19, 2012 11:46 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:59 AM
Points: 562, Visits: 885


I am not sure I am following your question. It sounds like you have some foreign keys perhaps?


i have a table with initial Info and Table that every month become update with new info in this tables i Have Two fields that are Same i cant change it. is this happen in DB Design?






Please provide DDL of tables.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1361743
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse