Name: Anonymous 2013-10-26 20:20
It's been awhile /prog/ trying to ditch front end programming because it's just tedious busy work with no thought required and trying to get into backend SQL development/database developer.
I know SQL and I know T-SQL quite a bit. I can analyze a query plan, I know the differences between tables, temp tables, table variables, Common Table Expressions, and table valued parameters. I know how to use cursors. I make frequent use of transactions.
Is there anything else I really need? I mean due to doing front end development for so long the only people I can get replies from are basic entry level which I assume I'll take just to get my foot in the door, but I'm concerned that I might be missing something as I have one interview coming up this week, which in the phone portion all they asked me was if I knew about joins (not very promising at all it would seem)...
so any advice or preping you can offer?
I know SQL and I know T-SQL quite a bit. I can analyze a query plan, I know the differences between tables, temp tables, table variables, Common Table Expressions, and table valued parameters. I know how to use cursors. I make frequent use of transactions.
Is there anything else I really need? I mean due to doing front end development for so long the only people I can get replies from are basic entry level which I assume I'll take just to get my foot in the door, but I'm concerned that I might be missing something as I have one interview coming up this week, which in the phone portion all they asked me was if I knew about joins (not very promising at all it would seem)...
so any advice or preping you can offer?