Jeff Moden (2/1/2015)
The bottom line (I think) here is that there's really no way to actually know what will happen during the interview and you have to be prepared for whatever. One also has to remember that the right kind of experience helps and if you're not getting such experience at your current job, then it will be strongly beneficial to spend some time learning the trade by participating in forums and doing your own training. Part of what I'm in awe of is that some people will pay good money to get questions or interview training but they won't spend the nearly trivial amount of money to buy a copy of the Developer's Edition of SQL Server and invest the time in self training. People also have to remember that most companies don't mind training you a bit but, all else being equal in a group of candidates, the person that actually knows their stuff better than the others will be the winner of the position.
I tried going that route, but I feared that I would train myself to do the bad things and never know it. So, I spent my time finding a senior and learned from him while also doing the Microsoft certification training to get the fundamentals down. It worked out great.
Paying for answers to common questions is not something I would do for sure, but I understand the reasoning.