WayneS (5/20/2011)

---

This ORM link was just pointed out to me: EntityFramework 4.1 RC – Code first; review.

Wondering what you'll think of the "Lack of good identifiers generators" section? Especially the...

Nah.

The way you did it there is pretty much what you had to do in SQL 2000. In 2005 and beyond, you...

There's a good overview of CTEs here: http://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/

Another: http://msdn.microsoft.com/en-us/library/ms190766.aspx

Start with those.

Just to clarify: You don't want to calculate from the specific date given if it's in the middle of a series of YES values, you want to calculate from the...

Did you try running the third query more than one time? Since the fourth ran much faster, you may be running into SQL Server having to build stats and...

The options seem to lack a "we are upgrading soon" selection.

We're on SQL 2005 right now, upgrading to 2008 R2 in very short order (the project has already started).

Those look like reasonable technical screening questions.

Given the position and purpose, I'd probably incline towards:

What are the advantages and disadvantages of stored procedures compared to inline code?

What's SQL injection and...

It's not really "reserved", and the procedures will still work in 2005 or 2008. It's just a bad idea, because it can have performance issues while SQL Server looks...

Actually, if you want to write directly to pages, you could. You'd have to get a HEX editor, and write directly to the disk sectors the pages are stored...

Richard M Karpel (5/20/2011)

---

If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as...

As mentioned, you need some way to tell SQL Server what order the rows are in. Is there a column in the real table that has that? Maybe...

I agree. While I could certainly rewrite the code, I wouldn't want to touch a banking system without a lot more information on what this does and why.

In cases where C# or other applications need a row ID before the row is inserted, I recommend GUIDs generated by the app.

They'll take more space than an ID, but...

Virtual database servers suffer a significant performance hit in almost all cases.

There are whole books of information on the subject. There are solutions to speed things up, but you'll...

I've spent a lot of time recently fixing bugs caused by a prior database dev who didn't actually understand SQL as well as he thought.

For example, an insert that had...