check the MDAC level of the devices that are not able to connect to your named instance. It should be at least MDAC2.6 at client level.

btw you can download it...

you have to take care : SQLserver may want to try to overwrite the original files at the original locations if you work on the same box. !

I must say...

... One of the main differences, and actually a big advantage, is that a CTE can be referred to repeatedly within the following SQL statement unlike a derived table that...

Find out if your sqlserver service account has the needed privileges and the mapped drive for "T:\"

Try using UNC i.e. \\yourserver\yourshare\anotherpath\yourfile.ext

in stead of "t:\..."

With SQL2005 osql has been replaced...

Indeed, that's the first thing we did, specify a max server memory for each instance.

That, along with our implementation of Windows System Resource Manager, makes it all more manageble.

Marcus Farrugia (10/18/2007)

---

... ALZBA I wasn't sure how to apply your solution, because I'm comparing one column, I wasn't sure what arguments to supply to the datediff...

case when column1 =...

We have a 16Gb ram x64 server with a 24Gb pagefile. And we will change that to 4Gb pagefile asap because of this.

During a systems test, the sqlserver instance grabbed...

or in seconds

SELECT substring(convert(char(23),dateadd(ss,A.myavg,DATEADD(dd, DATEDIFF(dd,0,@x), 0)),121),11,8) as myavg

from (

SELECT avg(datediff(ss, DATEADD(dd, DATEDIFF(dd,0,@x), 0), @x)) as myavg

from whatever

)

A

for the moment I have no SSMS, so this tsql is...

Maybe you'll be better off selecting timeparts from your datetime and averaging those numbers.

Have a look at http://www.sqlservercentral.com/articles/Advanced+Querying/workingwithdatetime/1634/

maybe just a thought :

Maybe you may want to take a look at log-shipping or another kind of replication ?

Check SSC and BOL 😎

indeed.

yep, a cte may be what you're looking for.

maybe even the (free) "Microsoft SQL Server Migration Assistant for Oracle" may help you out :w00t:

and if you have doubts, just put it between brackets.

SELECT @myvariable,@myvariable *(-1)

- [90 GB] : a normal xcopy would also need quit some time to copy it.

- [No we copy to one backup server and from there we restore on the...

- how many filegroups / files in the db ?

- how big is the backupfile(s)

- do you copy the backupfile(s) to local before the restore ?

- what kind of disk...