Viewing 15 posts - 1,261 through 1,275 (of 3,061 total)
DBA Rafi (12/28/2010)
Yes. I agree that this cannot be 100% achievable by SQL as this depends on the code from C# or other which is out of SQL scope.
All those...
December 29, 2010 at 9:28 am
ALZDBA (12/28/2010)
performance: because the are physically split like their corresponding table, so the engine will only use the part needed by the query
I'm in agreement IF queries are hitting a...
December 29, 2010 at 9:21 am
Core6430 (12/28/2010)
PaulB-TheOneAndOnly (12/28/2010)
Core6430 (12/26/2010)
The database design is similiar to the tables below...
What you are posting is not a database design per-se but a physical implementation of some database design.
Would you...
December 29, 2010 at 9:10 am
Core6430 (12/29/2010)
Business logic for enforcing constraints is good. Buisness logic that changes frequently should be in code, not SQL.
I'm sorry to break the news but this statement contradicts what the...
December 29, 2010 at 8:59 am
I'll take #2
Assuming SAN/Network are working properly chances are you are facing some hot spots. A single file Tempdb sounds like a possible cause but I'll suggest to further investigate.
Please...
December 28, 2010 at 2:21 pm
You are welcome.
Just as a foot note let me add that it is imperative to have a sound data model before jumping into building tables.
Step #1 would be to identify...
December 28, 2010 at 12:25 pm
Core6430 (12/26/2010)
The database design is similiar to the tables below...
What you are posting is not a database design per-se but a physical implementation of some database design.
Would you consider posting...
December 28, 2010 at 11:47 am
Mrfixit1170 (12/28/2010)
I am a new DBA with no mentor, not even 8 months into this job.
I also understand your question refers to database design - if this is the case...
December 28, 2010 at 11:24 am
TheSQLGuru (12/28/2010)
December 28, 2010 at 11:12 am
sawantpl@gmail.com (12/28/2010)
Can you please complete my example & give solution for 3NF.
Post a proper ER model and we will gladly help out 🙂
December 28, 2010 at 10:01 am
mitch.fh (12/27/2010)
The idea for partitioning is that I have about 100 million users from different portals united in one dwh.
Load processes...
December 28, 2010 at 9:58 am
mitch.fh (12/23/2010)
So Many Hits no answer... Is that a Problem that no One has or no One knows an answer to? :w00t:
You know the old saying... "if you have nothing...
December 27, 2010 at 2:35 pm
sawantpl@gmail.com (12/27/2010)
2. Upto which normal form it is advisible?
3. I read so much documents of normalization,...
December 27, 2010 at 1:39 pm
Resender (12/23/2010)
If i log into sql*plus how can i determine on what database I am.
From SQL*Plus issue:
SELECT name FROM v$database
.ORA-00942: Table or view does not exist[/quote]
Try...
select instance_name from sys.v_$instance;
select name...
December 27, 2010 at 1:28 pm
palla.sureshbabu (12/17/2010)
This may result in a performance degradation. Duration: 0 seconds.
Let me show you how I read it... MAY result in a performance degradation, duration ZERO seconds.
So... what you initial...
December 18, 2010 at 11:50 am
Viewing 15 posts - 1,261 through 1,275 (of 3,061 total)