Can you join a partitioned table to other tables that either are/are not partitioned?? When you join partitioned tables ... Do they have to be...
All, I have a partitioned table (1.7 billion rows) that is across 97 partions. The table is partitioned on datetime field. When I query only this...
All, I have a datawarehousing environment with multipe db's up to 400gb and a table with 1.7 billion rows. This table is often involved in complex...
Also, first table (entries) has 1.7 billion rows
-I've checked query plan and no table scans occur here -Also the result of this join returns many millions of rows -subquery not using where clause...
Anyone have any ideas why this insert statement would hang thanks for your help INSERT INTO jb.SR_Rolledup_AVG (aibFK, Loc_FK, PartFK, US4WkAvg)...
thankyou
all, Can SQL standard see/use above 2G when the 3/gb switch is in the boot.ini. Os = Winserver2003 standard edtion thank you
All, I first ran indexdefrag on a table with 1.5 billion rows. logical fragmentation was at 95%. logical frag went down to 3% with no real effect...
Did you set your max memory with sp_configure and if so to what min/max thanks
so AWE must be turned on with sp_configure ????? thanks
All, I'm new to x64 bit architecture. Server OS is 2003 R2 EE x64 Sql is 2005 Std sp2 with hotfix 4 way processors 4 GB of RAM I reading that all...
thanks
thanks,
Yes, there is something in 2000sp4 for awe memory. If the problem still persists check sql log for any errors relating to AWE
good article, thanks much
Enterprise Edition8.00.2040SP4
when I use these queries: --which processes are blocked use master go SELECT * FROM dbo.sysprocesses WHERE blocked <> 0 --which processes are...
Actually AWE is not supposed to be enabled to use /3gb switch. AWE is only for >4gb memory in server.
Separate names with a comma.
