25 .... I can do it with DNS record ...thanks

i put in dbConn.CommandTimeout = 0 and it worked - shame on the web developer.....

Hi im about to do similar transfer some large tables to a new database.

YOu mention bcp as this uses the log...Do you have an alternative method to use when transferring...

Thanks guys i be doing some analysis in the next weeks.....i post some new threads.

RBAR stands for ?

In the READS is this * 8192 / 1024 to get mgs of data.

CPU is in ms ...

Just checking.

I have a look at the thin lines rows...

i going to run my entire process using profiler with the SHOWPLANXML on to see what it is doing too....:)

What are the things i should look out for in the...

) You need to start using the correct datatypes. This is a VERY common error by database developers. For example, (CONVERT(varchar, GETDATE(), 101) <= dbo.ACADEMICCALENDAR.END_DATE) requires an implicit...

How did you check for the there is no parallelism i have open your sqlplan...Can you explain how you know there is no parallelism - sorry not really study one...

Hi there - i had similar thing this week - where it took over 10 minutest to run a process and cpu went to 100%....and stayed there...I turned off the...

Now there a challenge.

Totally agree but this is a vendor's software and thats how they do this...........not much i can do 🙂 So much overhead building temp tables userid.table each time a process...

Oh the process is a report that went back for 5 years worth of data, it takes the data from one table and does inserts into temp tables which are...

How do you start the sql server with the /f command if it is part of a cluster.

I had the auto statisics set to true on......and the CPU would stay at 100% for 10 minutes...i turned it off and it runs in 2 minutes cpu remains 35%...

Is that script just since server started or per the hour. If you run that now would it be the amount per hour vs since day one.