sanketahir1985 (4/9/2010)

---

Hii friends

I have one server with 4 CPU , 8GB Ram

6GB is dedicated to sql server

now we have scenario where some stored procedure get fired after every 5...

actually - i will just correct myself

you need to store the target column as text or LOB

varchar2 has a limit of 4000 byes

varchar has a length of 2000 bytes in...

you need to speak to an oracle dba on this

i'm not 100% sure on this but i beleive you need to change the target column in the oracle database to...

as far as i am aware this is correct for sql logins only

however it would be wise to check this before you accept my response as accurate

I can conformt that...

in client network utility try createing an alias for your server and specify that the alias uses TCP/IP

- that is client network utility on your cleitn machine - not...

could be that named pipes is specified in the connection string

what is the client? it it enterprise manager, or an application

can you change the connection string ? can you post it (censored of course - we don't need usernames or...

First thing you need to look at are tghe followin functions

REPLACE

SUBSTRING

CHARINDEX

LEN

RIGHT

LEFT

Example Contents of Path column

templatedata\Article\ColumbiaArticle\data\2004-09_Spalding_en

Need to change to

templatedata\Article\ColumbiaArticle\data\en\2004-09_Spalding

i'll do it in stages

first thing is to find the last...

depends on your wan

you should be able to connect via TCP/IP - port 1433 (and the UDP port for that is 1434) by default

if these ports are open you should...

ray

have you tried

DBCC DROPCLEANBUFFERS

GO

DBCC FREEPROCCACHE

GO

if you are using dynamic memory that might free it up - not sure if it just clears the memory or it clears it...

lyn - as chris morris says - looks like he doesn't need the left outer join

is there a certain time that your tempdb grows?

my guess would be you are using the sort in tempdb option when rebuilding your indexes (possibly) which would put a huge...

Bill Gates-870674 (1/28/2010)

---

If it is backed up and still not reducing the size then try to shrink the log file manually upto your required size.

if it works then the problem...

nope - a checkpoint marks the log entries as inactive - therforethey will be cleared down when the log is backed up

ini some unusual circuimstances automatic checkpointing...

I would suggest (as a dba with over 12 years experience) that you ask yourslef what about being a dba you wish to pursue

there are many facets to becoming a...