June 10, 2011 at 3:15 pm
What advantages is there to moving indexes to a separate drive? What raid would you use?
How do you estimate the size of a table?
What is the process that an Insert statement goes through?
June 10, 2011 at 3:29 pm
testers (6/10/2011)
What advantages is there to moving indexes to a separate drive? What raid would you use?
Advantages - can help to spread the IO across separate physical volumes. I would use the same RAID as the volume that contains the data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 10, 2011 at 3:32 pm
testers (6/10/2011)
What advantages is there to moving indexes to a separate drive? What raid would you use?How do you estimate the size of a table?
What is the process that an Insert statement goes through?
These are pretty disparate questions. What are you trying to do? We can probably help you more if we know what's driving these.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 10, 2011 at 4:27 pm
they are just general interview questions.
June 10, 2011 at 4:43 pm
testers (6/10/2011)
they are just general interview questions.
So I figured. Since I won't let you use my knowledge and hard work to get yourself a job, I'll lend you a hand figuring out what you need to go research.
1) Go look into filegroups.
2) Look into the system views.
3) That's a deep and long subject to know end to end and you'd be better off picking up a book or two. However, as a starting point, look into explicit and implicit transactions, locks and escalation, blocking, page and extent usage, and page splits.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 10, 2011 at 4:52 pm
testers (6/10/2011)
they are just general interview questions.
Thanks for your honesty. Those are the types of things that you should learn through research and experience. You really should dive into SQL server and see if you can figure out these answers.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 10, 2011 at 4:56 pm
thanks for the help
June 12, 2011 at 8:39 pm
are we deleting posts off my topic?
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply