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

Yes you can, but will it give you the result you expect ?

select top 1 field2

from yourtable

where field2 is not null

order by id -- if id is...

does he also know what composite material the engine of his care is made of ? :hehe:

Do I know what exotic language is used for the SQL-engine ? No

Do I...

1) keep in mind there is no order in a table's rows.

If you want results handled in a certain order, you should use an order by clause in your...