Click here to monitor SSC
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
Valued Member
Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)

Group: General Forum Members
Points: 57 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
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1064 Visits: 13728
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-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24276 Visits: 37987
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
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16667 Visits: 17030
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)
Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5715 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-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45390 Visits: 39941
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
vahid.arr
vahid.arr
Valued Member
Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)

Group: General Forum Members
Points: 57 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
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16667 Visits: 17030
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)
vahid.arr
vahid.arr
Valued Member
Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)

Group: General Forum Members
Points: 57 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
Say Hey Kid
Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)

Group: General Forum Members
Points: 662 Visits: 1062


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