Viewing 15 posts - 40,441 through 40,455 (of 49,571 total)
peace2007 (3/11/2009)
March 11, 2009 at 6:21 am
Post table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached)
March 11, 2009 at 6:20 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic673017-147-1.aspx
March 11, 2009 at 1:14 am
clive (3/10/2009)
Can anyone provide a statisfactory solution.
On SQL 2000?
If I may be blunt, the first thing I would look at is changing the DTS so that they use a username/password...
March 11, 2009 at 1:12 am
TaylrJ (3/10/2009)
I think I have a handle on it with one exception. I only want to update a record if it is inserted...
March 10, 2009 at 3:02 pm
Dave Mason (3/10/2009)
Oh, as far as the fragmentation threshold goes, it was 3% (or more) this morning. Prior to that, it was 5%.
I wouldn't worry until it reaches 25-30....
March 10, 2009 at 2:56 pm
Dave Mason (3/10/2009)
I was under the impression that updates to non-indexed columns don't affect index fragmentation.
It does if the update makes the row grow (null to non-null, longer entries in...
March 10, 2009 at 2:32 pm
Dave Mason (3/10/2009)
MJ,I rebuild indexes once per day at 6am. On some days, a second index rebuild is required.
Auto_shrink? Manual shrink?
What's your threshold for rebuilding the indexes and how...
March 10, 2009 at 2:09 pm
TaylrJ (3/10/2009)
if exists(select usr_Ipaddress from Database1.dbo.usr_hardwareasset where usr_IPAddress like '10.4.10.%')update usr_hardwareasset
set usr_location = 'Some location1'
What you're saying there is if there are any rows at all (even 1)...
March 10, 2009 at 2:04 pm
Why do you want to update through the view instead of updating the base tables?
March 10, 2009 at 1:58 pm
Tony (3/10/2009)
SELECT TOP 1...
March 10, 2009 at 1:55 pm
Bob Hovious (3/10/2009)
Hey Lynn... somebody is impersonating you 😉http://www.sqlservercentral.com/Forums/Topic672323-1291-1.aspx
A jedi master he is not.
March 10, 2009 at 1:17 pm
There's a garbage collector that cleans up the files later, after it's certain that they're not needed any longer. iirc it runs when the log is truncated ie on log...
March 10, 2009 at 1:14 pm
Viewing 15 posts - 40,441 through 40,455 (of 49,571 total)