That's a pretty massive request. Do you have any experience in doing any of that?

If not, I would recommend you look at getting someone in who does know how to...

Was my answer inadequate?

in sysprocess there is a column blocked which shows the processid of the blocking process.

What about using...

If you update a view, the table underlying that view is updated. You shouldn't need a trigger.

I'm not sure i understand what you're after.

If you query sysprocesses (select * from master..sysprocesses where spid > 50) you'll see there are four columns - blocked, waittime, lastwaittype and...

RPC Process? Did you identify that from profiler or from the deadlock graph?

Could you post the deatils that you have?

PRC calls are usually stored procedures. Means you'll have to dig...

You can use a normal temp table (#Tablename) as its visible in the procedure that created it, and any procedure or dynamic SQL called by that procedure.

A table variable has...

I had much the same problem some months back. Group of developers felt they were above the rules and were fiddling on Prod using a SQL account for a messaging...

The structure of the data and log files are the same for all the architectures that SQL runs on.

I've moved DBs (detach/attach) between IA-64 to x86, from x86 to...

You can't directly control it.

The cache remove occurs when SQL, for whatever reason, decides that the cached execution plan for the query its about to run is no longer optimal....

A heap can't really fragment. Since there's no defined order for the rows, pages are just added at the end of the chain.

What you can get with heaps is forward...

Firstly, see if anything's changed in tha last few days. Any code changes, large data loads, hardware changes, etc, etc

Rebuild the indexes if they're fragmented. If you do a rebuild,...

DECLARE @TblName VARCHAR(50)

SET @TblName = 'MyTable' -- can be a parameter also

IF (SELECT OBJECT_ID(@TblName,'u')) IS NOT NULL

PRINT 'Table Exists'

ELSE

PRINT 'Table Not Exists'

Ok. I said dense_rank based on the rank values you...

You can see all the logins on the server using the system view sys.server_principals. It's the 2005 replacement for syslogins.

SELECT * FROM sys.server_principals WHERE type IN ('u', 'S')

sysusers on SQL...

There seems to be a bad link in the article. The link under "Network Solutions snatching domain names" instead links to an article about online polls.