Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greatsqldba
Starting Member
11 Posts |
 Posted - 2011-06-09 : 20:40:19
|
| Given that a EDW contains approximately 5TB of data spread across about a hundred tables, maintaining efficient indexes is extremely important to performance. Describe, in detail, how you would manage indexes so as to not impact operations.Thanks in advance for the help. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-06-09 : 22:30:27
|
| Homework?CODO ERGO SUM |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-06-09 : 22:33:54
|
| Lots of interview questions? If I answer, will I get the job? |
|
|
|
greatsqldba
Starting Member
11 Posts |
Posted - 2011-06-10 : 11:00:47
|
quote:
Originally posted by jeffw8713
Lots of interview questions? If I answer, will I get the job?
Interview questions....hmmm...more like homework! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-10 : 12:59:50
|
| If I do your homework for you do I get the qualification?Seriously, if we just give you the answer no one's learnt anything (and I don't need a course in basic SQL admin). So what do you have so far, what do you need clarifying?--Gail ShawSQL Server MVP |
|
|
|
greatsqldba
Starting Member
11 Posts |
Posted - 2011-06-10 : 21:36:12
|
quote:
Originally posted by GilaMonster
If I do your homework for you do I get the qualification?Seriously, if we just give you the answer no one's learnt anything (and I don't need a course in basic SQL admin). So what do you have so far, what do you need clarifying?--Gail ShawSQL Server MVP
thank you sir but I've already answered the question doing my own research....Appreciate your comment though! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-11 : 04:12:58
|
| Excellent. Good to hear.--Gail ShawSQL Server MVP |
|
|
|
shivasu
Starting Member
2 Posts |
Posted - 2011-06-30 : 21:27:19
|
| Would you please let me know the answer? I am trying to get answer for this question.thank you sir but I've already answered the question doing my own research....Appreciate your comment though![/quote] |
|
|
|
|
|
|
help-Managing indexes so as to not impact ops