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...
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)...
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...
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,
when I use these queries: --which processes are blocked use master go SELECT * FROM dbo.sysprocesses WHERE blocked <> 0 --which processes are...
I have a weekly maintenance program that deletes around 100,000 records from various application tables. Question is : Do I need to run an...
I'm experiencing some network latency which sometimes causes my replication to fail. (timeout - was retried 10 times) I would like to increase the...
All, -I have a weekly REINDEX job that runs on Sunday for 7 hours. -3+ hours is spent on REINDEX of one table (very large) results of...
I am migrating a sql server from test to prod by copying the data directory over and modifying sysserver system table. I know this works nicely but...
Every sunday my reindex job runs and when it goes up against the largest table in db (90,000,000 rows) the reindex takes very long.. not sure exactly...
I am migrating from serverA to ServerB. Server A has 'per_seat' license, qty=50. ServerB has 'per_seat' license qty=5. I went into control panel/sql...
Is AWE memory possible with SQL 2000 standard edition. Most doco says no but when using it with win2003 server Enterprise edition I cannot find an...
Has anyone had dramatic performance improvement from turning off torn page detection on a high (90%)cpu server. Thanks
Has anyone had great performance gains by using 'with recompile' on procedures that take 50+ parameters?? Thanks
Any idea how to determine per proc/per seat licensing for an existing sql installation. Thanks
I have Sql compilations/sec averaging 150 and higher. I've just discovered that sp_updatestats runs every night. Could this be causing or...
Separate names with a comma.
