umarrizwan (1/28/2015)

---

DECLARE @dbid INT

SELECT @dbid = DB_ID(DB_NAME())

SELECT OBJECTNAME = OBJECT_NAME(I.OBJECT_ID),

INDEXNAME = I.NAME,

I.INDEX_ID

FROM SYS.INDEXES I

JOIN SYS.OBJECTS O

ON I.OBJECT_ID = O.OBJECT_ID

WHERE OBJECTPROPERTY(O.OBJECT_ID,'IsUserTable') = 1

AND I.INDEX_ID NOT IN (

SELECT S.INDEX_ID

FROM SYS.DM_DB_INDEX_USAGE_STATS S

WHERE S.OBJECT_ID...

Should be in the default trace, but that's only 5 files of 20MB, it gets overwritten quickly.

venoym (1/28/2015)

---

An index on the ID (even unclustered) would solve the speed up the ordering problem with the TOP (1), but you could also would have add an "ORDER BY...

ChrisM@Work (1/28/2015)

---

It returns every row:

SELECT

n,

[AllZero] = n%1,

[(n-1)%2]...

That doesn't return alternate rows, it returns rows with odd even values of BusinessEntityID. There's a...

I'd bet you lunch that they won't...

Any reason why all but one of those connections are running in the Serializable isolation level? Is that intended? Do you need the isolation that serializable provides?

Well, that's a nice example of database abuse....

Yes, that'll have multiple effects.

First you've broken the log chain of the database and lost the ability to do point in time restore.

The...

In my opinion, 1 unless you have a good reason.

The only advantages of multiple instances over multiple DBs on an instance are memory partitioning,...

Why not just change the column f2 to not be nullable?

Err, yes it is possible.

Query splits the sentences into words (look for a split function, Delimited8ksplit is fastest). If large, insert into temp tables, then use INTERSECT and EXCEPT to...

Table definitions please, some sample data and what is it supposed to do?

Summer, glorious summer.

Might swing past my parent's place tomorrow for a swim, it's going to be a hot...

Backups do not take locks. Full stop. End of story.

Yes, in my experience backups do usually have some impact on the system. To be honest that's pretty unavoidable. It is,...

Starting with the basics. Backups do not take locks, so the timeouts can't be from there.

Before looking for a solution, I'd suggest identify the problem. Why do queries time out?...