Cons. 1  Cannot span multiple databases... at least not easily. 2  All entities (tables, views, etc) need a primary key. 3  If you want to update a single column in a 100+ required columns table (not my table design), you have to pull down all 100 columns to make the update. Or use a Stored Procedure. I've had issues with some default values defined on SQL server not getting pulled into the entity model after a new record gets added. Usually this is with computed values, or values that get added in an INSERT Trigger On occasion, the SQL queries get badly written and are slow to execute.
Buying in advance is cheaper than buying at the station on the day and you could save an average of 43% on your train ticket. Advance tickets usually go on sale 12 weeks in advance, so the earlier you book the more likely you are to save.Ticket Alert.uying in advance is cheaper than buying at the station on the day and you could save an average of 43% on your train ticket. Advance tickets usually go on sale 12 weeks in advance, so the earlier you book the more likely you are to save. Ticket Alert.
Use these promo codes and dedicated links to save up to 20% on your train ticket and up to 30% on a companion fare. By Sascha Segan. Gas prices are headed up again, but Amtrak fares are holding steady -- making our nation's rail service a smart bet for your spring or summer getaway.f you're riding the Adirondack train (that's the Montreal train) on a Thursday-Sunday before April 28 and if the resulting fare is higher than $89 round-trip, use this link for an $89 Adirondack round-trip instead. If you're traveling to/from Philadelphia before July 13, use this link to save 15% off each ticket.