The one that...

First question, is that nonclustered index useful? Are the queries in the procedure using it or is it a waste of space?

The CPU values that the DMVs return for sessions is ms of CPU time since login time. Hence sessions that have been connected for a long time (as replication jobs...

No, you don't need to be working for anyone in particular, or even to be working at all. Anyone can register, pay for and write an exam.

You'd need to look at the query that the report is running. The DMV shows null if an index hasn't been used, so the dates you see come from the...

You can create a SQL Agent alert on the appropriate error message. You'll still have the effects of a full log on the DB though.

Why is your log filling often...

If you want to remove the nulls in the table

UPDATE <table name> SET <column name> = 0 WHERE <column name> IS NULL -- (a float cannot contain the string value...

shew (11/14/2013)

---

To DBAs, this isn't important, because *we* know that identity columns are arbitrarily assigned. However, the users of the report in question are accustomed to seeing mostly consecutive values...

Post them. Won't have a chance tonight. Maybe tomorrow, maybe saturday.

Ah, see what you mean.

Identities have never been gap-less. Why is having no gaps in what is probably an artificial primary key (column without meaning) important?

If no gaps is a requirement, you can't use...

Next time the query misbehaves, can you capture the actual execution plan (not estimated please) before and after the index rebuild? Without that, just guessing.

LutzM (11/14/2013)

---

Just a pot shot:

It might be driven by the developer who want to make sure the key is unique but wasn't able to define a UNIQUE PRIMARY KEY (for...

Or stale stats on the same table, on a different column. Or on another table. Or a bad plan (from bad parameter sniffing) getting into cache maybe.

Only if, after the reboot, someone ran ALTER DATABASE <db name> SET OFFLINE.

SQL will not set...