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...

one thing everyone forgets

make sure your database is checkpointing - the log data is not truncated if no checkpoint has occured

try the following

use mydb

go

checkpoint

go

backup log mydb to disk='xxxxxxxx'

go

dbcc shrinkfile(2,1)

go

Rich

if i remember those machines (5664-server is it?) then they only have 1 disk (ok 2 disks in raid 1) on them???

1 disk and 1 Gb of memory will almost...

use the ORIGINAL_DB_NAME () feature in your classifier function

40 lac = 4,000,000 ( 4 million )

(1 lac=100,00)

is this correct ???

one more question - does the file you are importing/updating from have a unique identifier? if so is...

ok

1st you need to create a database in sql2005/2008 compatibility mode to host the proc

CREATE DATABASE test

Go

then set it to allow the use of unsigned CLR -

ALTER DATABASE...

A Good DBA will want to know everything going on in his environment - especially since he will be the one called out at 2am in the morning when it...