There's a bunch of ways. Do be aware that this often degrades performance, so rather avoid on larger tables or important queries

select * from t_rbt_data

where dt between '2014-01-01' and '2014-03-31'

AND...

Timeouts are a client-side setting, SQL doesn't give up on queries unless it's told to (kill session or attention call from client app)

There's a lock wait setting somewhere (sp_configure I...

While that's what a...

It's just how many of the DMVs are implemented, using a mechanism kinda like a linked server. Don't worry about it.

Great. Now drop the table, convert that to a char(10) (nchar if you need arabic, chinese, etc) and then run modified create table, as you have it above.

First fix your data types.

Second, how do those tables relate to one another?

Remove the TEXTIMAGE_ON clause of the create table, as it only has meaning when there is a LOB column in the table

Personally, having written more cert exams than is probably wise (and a lot of them as betas, so complete with poor spelling, grammar errors, confusing questions and nonsensical answers), I...

Table definitions and easily usable sample data please (as insert statements)

Using SQL 2008 or 2012?

Because you defined it as NVARCHAR(MAX), a character string up to 2 billion characters long. Index keys can be no larger than 900 bytes.

Is your product code really over...

No, not possible.

A SELECT returns data, the outer-most query is a select, so it is supposed to be returning data, not changing it. What are you trying to do?

Temp tables are created in TempDB. your sequence is in your user database, not TempDB, so the 2-part reference fails as the sequence can't be found.

Edit: Code removed.

Depends on what indexes are available.

The memory request is not the buffer pool space. It's workspace memory for things like sorts, hashes or other query operator operations which need memory.

If you want backups that you can restore, DB backups would be useful. Depending how they're doing the server image, it may or may not produce usable databases once restored.

Before...

Frighteningly true, especially since the people who...