Assigning processors to specific threads can improve performance under these conditions by eliminating processor reloads and reducing thread migration across processors (thereby reducing context switching) such an association between a thread and a processor is called processor affinity. Although efficient from an operating system point of view, this activity can reduce SQL Server performance under heavy system loads, as each processor cache is repeatedly reloaded with data.

To carry out multitasking, it is possible to distribute process threads among different processors. The Processors section of the Server Properties dialog allows you to configure the instance of MicrosoftВ® SQL Server by setting options pertaining to processors usage in groups: Enable processors, Threads, Parallelism. Advanced Query Builder for RAD Studio VCL.Advanced Data Import for RAD Studio VCL.Advanced Data Export for RAD Studio VCL.SQL Management Studio for InterBase/Firebird.Otbd_Forms Forms with (nolock) on s_page_id = s_page_id inner joinД¬hes ems with (nolock) on ems.email_id = Forms. Outbound_id is not null) >= 1 THEN 1 ELSE 0 END) UniqueLinkClicks,Дes_res Lnks with (nolock) inner join des_page Page with (nolock) on s_page_id = s_page_id inner join Where signer_resource_id = signer_resource_id and Also, why do you say nolock is usually a bad thing? I have changed the table names but the sql text should still be sound. It contains 334 million records with an estimated size of 400 + GB. Your explanation sheds light on the issue I am seeing.Д¬irquedeSQLeil - A couple of things. Thanks a lot CoolWebs for the info and your patience.

I have not been able to find out why the blocking is happening. I tried reproducing the error on my test machine but no luck. SELECT c.column_name, c.data_type, c.character_maximum_length, c.numeric_precision, c.is_nullable, c.numeric_scale, c.column_name, ISNULL(( SELECT 'YES' FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS pkc INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE pkcc ON nstraint_name = pkc.constraint_name WHERE pkc.table_name = c.table_name AND pkc.constraint_type = 'PRIMARY KEY' AND lumn_name = c.column_name), 'NO') AS 'is_primary_key' FROM INFORMATION_SCHEMA.COLUMNS c WHERE c.table_name = 'Bobo'Д¬an someone explain to me why this blocking is occuring? I know that somehow the creation of the table is involved but can not pinpoint why. The blocking occurs when the below statement is run after the select * into. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT * INTO MONTY2 FROM (SELECT 'rl63_at_405', 'at_176', SUM(dt.'rl1267_at_21034') 'rl1267_at_21034' FROM (SELECT rl63_activities.name 'rl63_at_405', OTBD.name 'at_176', rl1267_ELksVw.UniqueLinkClicks 'rl1267_at_21034' FROM otbd_forms OTBD WITH (NoLock) LEFT OUTER JOIN action rl63_activities WITH (NoLock) ON (rl63_activities.activity_id = OTBD.activity_id) INNER JOIN ELksVw rl1267_ELksVw WITH (NoLock) ON (rl1267_ELksVw.email_id = OTBD.outbound_id) WHERE (OTBD.outbound_id = 19801)) 'DT' GROUP BY 'rl63_at_405', 'at_176' ) createDT An example of that type of query is below. Our application allows customers to build sql ad-hoc sql statments to query information and to create a table from the result of the query. My description of the issue is below and if furthur information is needed please let me know. Hello Everyone - I have a blocking issue and need a little bit of help from the experts.

Ems sql manager locking tables