Around here, I've found that either the recruiting companies or HR don't really know what the job requires, so scatter the add with buzzwords.

As far as I know, the smallest granularity for freeing the caches is at the database level.

Alter Index is only 2005 and higher. 2000 didn't have the command at all.

Not necessarily useless, just not of value for what you're doing. You can remove the starting event from the trace if you wish.

The client process ID is the ProcessID (from...

Are those from the Statement started events?

Those are logged when the statement begins. Since it hasn't finished, there's no duration, reads or CPU to log. Those are logged for the...

It's in microseconds on 2005, but in the profiler GUI it will probably...

Shouldn't cause any problems, unless you start tracing the very frequent events (object access, lock taken and such) but there's no need for that here.

The standard template is a good...

You've got 1 redundant index. Rest look OK. Depending on the queries, they could maybe be widened.

create index scanndx2 on scan(boxid,client)

create index Boxid_idx on scan(boxid) -- redundant

An aggregate with a group by will return the 1 value for each unique set of columns as per he group by.

In your case, it will return the max effective...

No replies here please.

Question has been reposted in the sQL 2000 forums

http://www.sqlservercentral.com/Forums/Topic486341-8-1.aspx

sp_executesql

DECLARE @SQLString nvarchar(500);

DECLARE @a int;

SET @SQLString = N'SELECT @OutVariable = bp_id from bug_posts where bp_bug=4648 ';

EXECUTE sp_executesql @SQLString, N'@OutVariable int OUTPUT', @OutVariable=@a OUTPUT;

PRINT @a

You know, I'm glad there's no chance that I'll ever be involved at a company you're working at.

Tell me, what will you do if you have to demonstrate the skills...

What defines your ordering?

Please post SQL 2000 related questions in the SQL 2000 forums. Posting in the 2005 forums means you'll probably get answers that use SQL 2005-specific features.

If you're using SQL 2005, rather use the view sys.database_files. the statuses are given in text, no decoding necessary.

Could you post the code please?

Are you getting the error every time?

Are you using snapshot isolation level, or read committed snapshot isolation?

Is it possible that other queries are accessing the...