A few things to look at

http://en.wikipedia.org/wiki/Nested_RAID_levels

http://en.wikipedia.org/wiki/Standard_RAID_levels

For databases, RAID 10 would be better than 5. Anything less than 5 is commonly not considered as redundancy.

To add to the list

1. missing indexes

2. amount of data

3. disk configuration

4. log file fragmentation (VLF)

There are a lot of things to look for when trying...

Compiled applications? I don't know of any in particular.

There are a bunch of applets and scripts available for download.

Check out Glenn Berry's DMV scripts

Simple-talk.com has some SMO things to...

NP

Chad Crawford (3/4/2010)

---

BTW - I thought of a few more assumptions that should have been included:

--Assume you are in the database containing tblUsers

--Assume you have been granted rights to...

Henrico Bekker (3/4/2010)

---

Please explain why you would recommend a nested select on the same table, looking for NOT IN on the same column, instead of selecting it and excluding the...

Kingstons response is more accurate for your desired results.

Not all databases need to be in Full recovery model.

If you currently need to, or may need to in the future, be able to recover your database to a point...

Please attach a screenshot of the connection properties for the connection you are using to perform the insert statement.

Thanks Saurabh, I learned something about sparse columns today.

Idera Diagnostic Manager

Quest Spotlight

Confio

Those are options to purchase. Or you can develop some inhouse stuff to monitor performance counters, jobs, database files, backups, etc.

When I use your last set of code, I get successful (expected/desired) test results.

Msg 229, Level 14, State 5, Line 1

The INSERT permission was denied on the object 'paramore1', database...

That doesn't answer my question though. You created that user for testing. Did you login with that user prior to creating that...

How did that one perform in comparison to your other scripts on your system?

Did you run the deny prior to or after running the insert?

The order of your statements shows insert and then deny.