Viewing 15 posts - 1,126 through 1,140 (of 2,010 total)
there are a number of scripts on this site and others which will at the very least be able to identify fragmentation levels. some even include code that lets...
February 6, 2009 at 7:35 am
PER BOL...
DBCC INDEXDEFRAG is an online operation. While this operation is running, the underlying table is available to users of the database. A relatively unfragmented index can be defragmented faster...
February 6, 2009 at 6:34 am
Also silly question but did you apply the post SP4 hotfix that fixes the way AWE uses memory? I can't remember the KB number off the top of my...
February 5, 2009 at 11:22 am
latch waits are fine and to be expected because of the transactional nature of your or really any database. But you need to have a base line for which...
February 5, 2009 at 10:41 am
My understanding is that average lock timeouts/sec should be 0, and if it's not that means you have queries that are timeing out while waiting for locks... These should...
February 5, 2009 at 9:00 am
No ideas about working with text columns as I've never really had to do much of that.
All I can say is read the appropriate section in BOL and...
February 5, 2009 at 7:52 am
what's the longest column length of your body column? This will work on a varchar(8000), but I don't think it likes text columns because of how they are stored....
February 5, 2009 at 7:05 am
So if they'll all be the same "NewPath" just prepended to the original, why not replace
'a href="' with 'a href="MyPath/' ?
This should take care of records with multiple links...
February 5, 2009 at 6:23 am
You'd be surprised how often that happens...
The accountants think that they don't have to pay benes and such for contractors so they are "cheaper" even if they're paid a higher...
February 4, 2009 at 11:07 am
OK now we're getting somewhere, you posting a bit better data helps. I know there are limitations to what characters you can put together on this site, but I don't...
February 4, 2009 at 11:02 am
Do you really have links that are like test\test1.pdf?
You may need to get pretty creative with your Charindex statements, to make sure you only change test once and not more...
February 4, 2009 at 8:45 am
You could check Books Online for the Update and Replace() Commands
Used together I think you could very easily come up with a solution to your problem.
Without some better sample data...
February 4, 2009 at 8:26 am
I'm not sure I would switch to a contracting job, as I'm a big fan of job security, but that also depends on a) how long the contract is for,...
February 4, 2009 at 8:18 am
A lot of it would depend on how they want the data. When you fill in the web form and then post the data, does it go into a...
February 4, 2009 at 8:05 am
Viewing 15 posts - 1,126 through 1,140 (of 2,010 total)