Hi, Could you please attach or paste a sample of what the flat file should look like?

Regards,

Iulian

Thank you for the question,

Regards,

Iulian

Thank you for the question

I have got the answer from msdn which says:

"Some of these factors, such as a very long-running transaction or a paused database mirroring session, can...

Nice one, thank you

Iulian

Thank you for the question,

regards,

Iulian

I did not knew it is case sensitive.

Thank you for the question,

Iulian

Nice to see a question on SQL Server Workloads with Resource Governor.

Thank you,

Iulian

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data

it is preety fast. I am not sure what do you mean by Load.

Regards,

Iulian

Interesting! according to msdn "GROUPING SETS can generate a result equivalent to that generated by a simple GROUP BY, ROLLUP or CUBE operation."

Thank you,

Iulian

Indeed, the question and the explanation are great.

Thank you,

Iulian

SQLSandwiches (8/15/2011)

---

Thanks Sean, but I'm not sure that would work.

DECLARE @a int = 123,

@b-2 int = 0 ,

@C int =102733019

select case when

...

Thank you for the question.

Is there any chance to simulate soft-NUMA on a dual-core?

Regards,

Iulian

Nice question. Thank you

Regards,

Iulian

Nice question and the script is also very nice, thank you.

Regards,

Iulian

I have thought the key word is different server and it looked obvious that it needs a copy of the key. But that was more like a feeling. After reading...