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...
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...
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
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)...
Can SQL standard see/use above 2G when the 3/gb
switch is in the boot.ini.
Os = Winserver2003 standard edtion
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
so AWE must be turned on with sp_configure ?????
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...
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
when I use these queries:
--which processes are blocked
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.