January 29, 2009 at 3:03 pm
Dear all,
I know there are lot of forums which talk about what are SQL DBA interview questions .
Well my question is that the company who will interview me , has TB's of databases and i havent handled such big databases (may be max 250GB).
Now what type of questions they will ask and can someone give me some best practices in handling such big databases.
for example :
1) Disk drive allocation (which data/log file to put where and why)
2)Any other special measures which i should take while handling such big databases.
Thanks in advance.
H.
January 29, 2009 at 3:12 pm
I had my interview in similar kind of company with same question. His question was, we have Really big size databases and sizes are becoming bigger day by day. So my answer for an immediate solution to this kind of problem was, I told him that I would go with partitioning tables horzontally or vertically or can create indexed views becaue normally in big databases its usually 3 or 4 tables whose size keeps on growing, not all the tables.
January 29, 2009 at 4:57 pm
HI THanks for your reply.
May i have more details , if possible (from other users).
Just to get equipped more.
H.
January 30, 2009 at 3:17 pm
I would guess that you will also get questions about backup / recovery processes - think filegroup backups, striping backups over multiple drives, possibly snapshots and snapshot restores etc. You should also expect something about maintenance processes eg rebuilding indexes / stats only as needed etc.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply