SELECT INTO and non-nullable columns

SQL Server
21 Comments
SELECT…INTO  is one of my favorite SQL Server features. It’s great for creating table skeletons with false WHERE clauses (1=2), moving a real table to a staged/temp location for testing, etc. In SQL Server 2014 It acquired the ability to go parallel, which is pretty neat, but that’s not what we’re talking about here. It…
Read More

Satya Slips a SQL Server Standard Secret?

SQL Server
3 Comments
Everybody wants to know the next SQL Server release date, pricing, and feature lists, but anybody who knows those facts is bound by non-disclosure agreement and can’t say it publicly. Every now and then, though, we get lucky and someone from Microsoft slips up. That’s why I pay particular attention to Microsoft interviews as we…
Read More

New DMVs in SQL Server 2014 CTP1

SQL Server
27 Comments
When you download and start playing with SQL Server 2014 CTP1, here’s a few of the new instrumentation tables and views: New Internal Tables plan_persist_context_settings plan_persist_plan – Hey, lookie there! Implies that we can persist execution plans beyond a SQL Server service restart. plan_persist_query plan_persist_query_text plan_persist_runtime_stats plan_persist_runtime_stats_interval New Views column_store_row_groups dm_db_merge_requests dm_db_xtp_checkpoint – Note that both…
Read More
Menu