By accessing external ressources out of trigger will hold open that specific transaction until the triggers finishes. If an another transaction will try to insert a new record the table...

Even the maintenance plan is doing a kind of cursor.

Anyhow you cann't make a reindex without any cursor. Of cours you can generate a script in one shot (what I'm...

You should set the cluster size to the extent size (8 pages = 64K) because AFAIK SQLServer is reading at least an extent from the disk. But the cluster size should...

What about this?:

exec master..sp_MSforeachtable 'dbcc dbreindex ("?")'

in a stored proc you have to use scope_identity()

See SCOPE_IDENTITY in BOL with a goodd explanantion

No We didn't tried out Tarantella. But what do you think about pure MS based Terminal Service solution. We are using it because of our security requirements and also remote...

Citrix is simply too expensive.

You have to by the whole MS Terminal server infrastructure, then again the "same" (I know it is not the same but anyway...) from Citrix.

We have...

http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

You cannot switch off the cache.

But what you can do is you can clean up the cache between eauch consequent SP run by using:

DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE

you can check this site for numerous pivot table scripts threads and articles.

Those could answer your question

An another way is to use SQL Server Agent to run sp_who or sp_who2 every 20'. you can collect the data then analyse it.

There is one drawback: neither sp_who nor...

Simply:

=NULL will only work if you have set explicitly the value NULL to your column

is null will always work because it checks for value NULL (explicitly set, "nothing", not...

Why you are not using a temp table corresponding to the structure of your Sybase data? So you could import the data from Sybase (via bcp, DTS...) into the temp...

Inside Microsoft SQLServer 2000 by Kalen Delaney.

Excelent book not for beginners

Also you can have some books. This is one of my favorit Inside MS SQLServer by Kalen Delaney. But that one is not really for the beginner.