If you don't invest in determining the correct datatype for you attributes/columns, don't even wast time at performance !

Indeed,with sqlserver you only have a...

Move your sp-validation to your vb-code and use SQLBULKCOPY (vb.net).

this is a "fast load" if you have ordered your data according to the clustered index of your table.

"tell me why I don't like Mondays"

check out : Moving SQL Server databases to a new location with Detach/Attach

(http://support.microsoft.com/default.aspx?scid=kb;en-us;224071)

if I'm correct, after you changed your systemdate, sqlagent will change the "next rundate/time" to 27/05/2005 12:00AM. So the only thing it does is check wether it has the correct...

Do I really need to wait 4 hours until I can start differential backup? Yes

Do I need to check error code (probably, yes, and how to do this) after full...

Keep in mind some of them are created by implementing a constraint and need to be removed by drop constraint.

Here 's a little testcase to show how you can do...

yep

Check sqlagent master-server

I cannot test it right now, but if i remember correct, it would for...

in queryanalyser run :

 restore headeronly FROM DISK = 'path\yourbackupfile.BAK'

I hope this helps.

from BOL :

Use sp_denylogin to explicitly prevent users from connecting with SQL Server, regardless of their Windows NT group memberships

With revoke you "drop" the user's login-id from the login's...

I don't know of any executionpriority you can set, but you can set deadlock-priority.

set deadlock_priority low -- I wish to be the victim in case of deadlock !

Guess what : I found this litle article ...

The waittype and lastwaittype columns in the sysprocesses table in SQL Server 2000

available at http://support.microsoft.com/default.aspx?scid=kb;en-us;822101

how about :

select ft.fno as DocGestao,

,round(sum(fi.ecusto*fi.qtt),2) as ValorGestao

,ml.adoc as DocCTB

-- ,(select (case when sum(edeb)=0 then sum(ecre) else sum(-edeb) end)

--   from ml ml1 (nolock)

--   inner join ft ft1 (nolock)...

Thanks for the reply, but the thread is over 1 year old

The sp-recompiles is what we've worked on, as well as ram-extention.

We've...

I think you only need this :

SELECT

 a.fieldname,

 a.Code,

 CASE a.fieldname

   WHEN 'Thing1' then  b.Thing1

   WHEN 'Thing2' then  b.Thing2

   WHEN 'Thing3' then  b.Thing3

   ELSE 0

 END As Description

FROM ATable a

left join  Thing1...