Viewing 15 posts - 3,556 through 3,570 (of 6,216 total)
We used to get the license error if we deleted the logreader job without stopping the log reader agent first. I'd recommend a restart of SQL Agent. On the timeouts...
August 6, 2002 at 11:56 am
August 6, 2002 at 10:49 am
Do you have it set to truncate on checkpoint? The log will grow if you have a transaction that exceeds the ability of SQL store it in the log at...
August 6, 2002 at 5:09 am
Depends on the cursor type. What you've described is a dynamic cursor. Other cursors vary. For example a keyset cursor only stores the key in tempdb, the other info is...
August 6, 2002 at 5:07 am
I'll agree to. And I just wouldnt tolerate an app from a 3rd party that used SA either.
Andy
August 5, 2002 at 7:47 pm
No point in trying JDBC until you resolve your connection issues. Do you have someone at work who can help you with that? Could be something as simple as the...
August 5, 2002 at 7:45 pm
Havent used JDBC, but we can start by making sure everything else is ok. You ARE able to use Enterprise Manager to establish a trusted connection? What about using a...
August 5, 2002 at 2:55 pm
Its worth doing. The reason the performance benefit is hard to guess is that SQL does some significant caching which hides some disk delays. Even if the pages are contiguous...
August 5, 2002 at 1:46 pm
With 8 disks I'd usually say RAID5. Maximizes space available and you need the spindles to keep access time down. Usualy want to put the log files on separate RAID1,...
August 5, 2002 at 1:43 pm
Well, at least it got you guys talking!
Leen, you make some fair points. Article probably could have been a little richer in some places. As with all our content posted...
August 5, 2002 at 9:45 am
Not sure I agree about the GUID's. From a pure size perspective, GUID's will be slower because they take up a bit more space. The offsetting advantage is that you...
August 4, 2002 at 3:32 pm
Agree that the permanent temp table is a good idea.
Andy
August 4, 2002 at 6:24 am
I think it defaults to 1252 - case insensitive. Tempdb will have the collation of model.
Andy
August 4, 2002 at 6:23 am
You'd have to use ##temp to make it visible. It is possible to return an output parameter using sp_executesql, you could return your count there.
Andy
August 3, 2002 at 7:55 pm
Viewing 15 posts - 3,556 through 3,570 (of 6,216 total)