Not enough information.

Decreasing fill factor is a decision you need to make based on how fast the index fragments and whether the increased size is worth the decreased fragmentation.

There's no 'telling the trigger' anything. As far as SQL is concerned, a trigger works...

As I said earlier

That trigger assumes that any insert operation inserts one...

A scan of a portion (range) of an index. Anything more than a single row is considered a range

Low scans, high range scans, I'd say that index is well used.

But that's exactly what user scans are, the number of scans of the index caused by user queries.

homebrew01 (2/14/2013)

---

GilaMonster (2/14/2013)

---

You have some third party tool backing up the databases as well as the native backups. My guess would be backupexec. The native and the 3rd part backups...

What is the statement's wait type?

Bottom line, you can't put a * into a float column, it's not a float. It you want to badly mess thing up, you could convert the column to a...

The process that is waiting is trying to acquire that lock.

Can you be a bit more specific? All the names from where? Not in what table?

Table definition, sample data and expected results would help.

Vera-428803 (2/14/2013)

---

Is it correct to say that orphaned users don't have an instance login but do have a db login and that loginless users have an instance login but not...

Ask the person what they meant, because your explanation does not have enough info. What users of what, what attributes, what back-end, what sessions?

The common meaning for 'database refresh' that...

Will only work if System is still a SQL login with sysadmin.

Go speak to your DBA and ask him for additional permissions on this server.

Check the error log, check the backup history tables, you have some 3rd party tool backing up your databases. Probably something one of your server admins put in place thinking...