Viewing 15 posts - 61 through 75 (of 80 total)
Ninja, thx for the reply. we can see the query eventually complete, which should cache it (thought I Havent verified that).
its not just the first run of a query that...
May 19, 2011 at 2:43 pm
Alex,
thx for the response and link.
as I understand it, forcing a recompile on a table or proc should flush query plans associated with that object. The scenario we've dealt...
May 19, 2011 at 1:42 pm
and lazy writes/second as well.
worth mentioning, disk IO metrics and cpu metrics on these servers are well within acceptable limits.
thanks!
May 19, 2011 at 12:13 pm
I just spend 20 minutes trying to figure this out, researching possible causes, etc etc...
my wrapper script that calls the xp was passing the parms for the tsmconfig file...
May 13, 2010 at 12:15 pm
also, thanks for the link, but Im not sure that is really relatable to my scenario.
I have a large table with a highly fragmented index set. My dynamic...
March 22, 2010 at 2:53 pm
From BOL:
When you create a clustered index on a table that has nonclustered indexes, you must have available as free space:
If SORT_IN_TEMPDB is set to ON, there must be...
March 22, 2010 at 2:24 pm
Perry Whittle (4/2/2009)
April 2, 2009 at 6:48 am
the wording here is a bit unclear, and this only applies to SQL2000, but leads me to believe that this isnt possible.
unfortunately I dont have a cluster that isnt in...
April 2, 2009 at 6:41 am
right, so I suppose my question is:
one default instance per WINDOWS CLUSTER or,
one default instance per Virtual Server name/IP?
April 2, 2009 at 6:39 am
by 'the load' do you mean the extraction TO bcp or the load to table FROM?
February 3, 2009 at 1:27 pm
what Im doing is effectively the same as what you describe (only renaming the existing table and its objects rather than truncating)...
the bcp out has a query, and an order...
February 3, 2009 at 1:11 pm
what Im doing is effectively the same as what you describe (only renaming the existing table and its objects rather than truncating)...
the bcp out has a query, and an order...
February 3, 2009 at 1:10 pm
oh, and the database is in simple recovery to keep log sizes down and make things move more quickly.
that was the problem with doing it via the method Paul...
February 3, 2009 at 11:17 am
from BOL:
-b batch_size
Specifies the number of rows per batch of imported data. Each batch is imported and logged as a separate transaction that imports the whole batch before being...
February 3, 2009 at 10:54 am
I have a -b10000 parameter on my bcpout, but I didnt believe that it adhered to that parameter (just had not commented it out yet)
is this the parm you are...
February 3, 2009 at 10:51 am
Viewing 15 posts - 61 through 75 (of 80 total)