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
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...
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...
when I use these queries:
--which processes are blocked
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...
-I have a weekly REINDEX job that runs on Sunday for 7 hours.
-3+ hours is spent on REINDEX of one table (very large)
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
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.
Has anyone had great performance gains by using 'with recompile' on procedures
that take 50+ parameters??
Any idea how to determine per proc/per seat licensing for
an existing sql installation.
I have Sql compilations/sec averaging 150 and higher. I've just
discovered that sp_updatestats runs every night. Could this be causing
Separate names with a comma.