We have a similar role in our development, testing, and production environments. It never occured to me to set something up to automatically grant execute permissions.

I agree...

Most of our databases in production use auto shrink. None of them use auto close.

I suspect the reason we have not noticed much in the way of a performance...

In theory it should speed up the query because for those text fields that have few enough characters to fit in the row SQL Server won't have to do a...

The main problem I have noticed with text fields in a SELECT query is that you can't do a SELECT DISTINCT without casting all text fields as varchar (or some...

Unless you manage to get an execution plan that can be reused (and usually you don't) then you can say there is no performance benifit.

For me, the benefit is that...

I don't think we currently use sp_executeSQL and I have used it only a few times. So I am not an expert with its use. We have many...

Dynamic queries and stored procedures have the same potential for blocking and deadlocks. To resolve these problems you must analyze what is happening as each query in the various...

Excellent article! I debate often with myself over the use of Dynamic SQL and Static SQL. We use both in our stored procedures and applications. Right now...

I seem to remember reading something about this and as I recall the chance exists to get the same one but is so low that its basically not worth worrying...

When I first started working at bigdough.com our Cold Fussion and Visual Basic developers did not have SA permissions in our Dev environment. A few months later I changed...

Wow! How or where did you learn all that? Is there a way to see all this behind the scene activity using the tools that ship with SQL...

I'll have to try that. I didn't think to put one there before because the trigger on sysobjects was intended to capture all new objects, not just tables. ...

That's the kind of stuff I want to know about! Do you know anywhere where someone discusses these behind the scenes activity or a way I can capture it...

I think sysprocesses is a virtual table. However, I don't think sysusers and sysobjects are virtual tables. So that shouldn't be a factor in why the trigger on...

Microsoft states that triggers are not supported for system tables and has put at least one mechanism in place to block the creation of triggers on system tables.

I am wondering...