SQL server questions
I have your book and I am studying it now. Yesterday I got asked a question on that interview that asked how does using an identity column versus using a guid for a primary key field on your tables effect accessibility when you are setting up and using SQL Server disk partitions? What is the difference between a cursor in Oracle and a cursor in SQL Server as to how they both access data and how they effect memory usage on the database server?
Anyhow those are just some of the 50,000 deep, nitpicky questions that a company in Dallas, Texas by the name of FilesAnywhere.com asked me on a job interview just recently. I am sorry but those are just a very small sample of some of the questions that got thrown at me on a job interview and I am not a living and walking example of Mr. encyclopedia, ASP.NET googleboy.
|