SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Database with 70 Table


A Database with 70 Table

Author
Message
vahid.arr
vahid.arr
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 180
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.
Animal Magic
Animal Magic
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3476 Visits: 13752
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
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90570 Visits: 38945
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.

Cool
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)
Sean Lange
Sean Lange
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59556 Visits: 17947
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 Modens 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)
Evil Kraig F
Evil Kraig F
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19555 Visits: 7660
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
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)

Group: General Forum Members
Points: 205011 Visits: 41952
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
vahid.arr
vahid.arr
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 180
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?
Sean Lange
Sean Lange
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59556 Visits: 17947
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 Modens 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)
vahid.arr
vahid.arr
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 180

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?
rhythmk
rhythmk
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1638 Visits: 1099


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/
:-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search