A Database with 70 Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » A Database with 70 Table

12 posts, Page 1 of 2

1 2 »»

A Database with 70 Table

Rate Topic

Display Mode

Topic Options

Author

Message

vahid.arr

Posted Tuesday, September 18, 2012 3:04 PM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 12:11 PM
Points: 42, Visits: 130

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

Animal Magic

Posted Tuesday, September 18, 2012 3:18 PM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:08 AM
Points: 983, Visits: 13,350

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

Lynn Pettis

Posted Tuesday, September 18, 2012 3:25 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:51 PM
Points: 21,627, Visits: 27,482

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)

Post #1361036

Sean Lange

Posted Tuesday, September 18, 2012 3:29 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 8,641, Visits: 8,273

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

Post #1361038

Evil Kraig F

Posted Tuesday, September 18, 2012 3:31 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:29 PM
Points: 5,688, Visits: 6,141

vahid.arr (9/18/2012)

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

Jeff Moden

Posted Tuesday, September 18, 2012 4:51 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 32,923, Visits: 26,811

vahid.arr (9/18/2012)

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

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

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1361055

vahid.arr

Posted Wednesday, September 19, 2012 12:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 12:11 PM
Points: 42, Visits: 130

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

Sean Lange

Posted Wednesday, September 19, 2012 8:00 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 8,641, Visits: 8,273

vahid.arr (9/19/2012)

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

Post #1361372

vahid.arr

Posted Wednesday, September 19, 2012 10:46 PM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 12:11 PM
Points: 42, Visits: 130

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

rhythmk

Posted Wednesday, September 19, 2012 11:46 PM

Old Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603

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/
Smile

Post #1361743

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions