Always good to see this question - the myth that TRUNCATE TABLE is non-logged (and so cannot be rolled back) is a persistent one.

Quite clever using 2008-only syntax too -...

Can you explain a bit more about the reasons behind wanting to do this?

More information often results in better answers.

Some third party products allow object-level restore:

http://www.red-gate.com/products/SQL_OLR_Native/index.htm

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

Terrifyingly, just the one it seems :blink:

Exactly, Jeff. Doing is an important part of learning!

Sweet.

The problem is...

Whoa!!! Site under construction?!

Adam - what did you do? :w00t: 😎

Grant Fritchey (4/23/2010)

---

Notice how both rows have the same index_id. There's only one index there. A row is returned for each level that the index has in the B-Tree. Here's...

Include the alloc_unit_type_desc column from sys.dm_db_index_physical_stats in the output.

There will be one row for the normal IN_ROW data, and an extra row for either LOB_DATA (or possibly a ROW_OVERFLOW_DATA).

WITH Numbered

AS (

SELECT *,

...

I never knew you could specify a table alias (x) in the INSERT column list...how interesting.

Take a look at the ISDATE (Transact-SQL) function.

I can't think of a way to change the data type of the column at the same time if values exist that cannot...

Getting this copyright wrong righted, right - or wrong?

Don't specify a column list on the INSERT statement:

insert into #temp --(a)

Having the system widely distributed adds some special considerations, but essentially the problem is the same as that faced by any locally-distributed system (e.g. a web farm) where records must...