I'll second Loner.

Clustered PK on the identity (Custered indexes should be narrow and unique)

Add a unique nonclustered index on app_idz, msn, dash_id, received_from_dashboard

GSquared (2/7/2008)

---

Actually, as far as total points go, you get as many for posting a complaint about the question as you would get for getting most questions right in the...

1) No, however if you're concatenating pieces of string together, you'll need a space somewhere.

2) No. SQL doesn't care about whitespace. Lay things out that they are readable by you...

It's declared outside of the dynamic SQL string. If you want the variable accessible inside the dynamic SQL, you either have to declare it within the dynamic SQL string, or...

Variable declared outside dynamic SQL aren't accessible within it, and vis versa

Your first line of dynamic SQL reads 'SELECT top 1 @Rank = K.RANK...'

Within the dynamic SQL, the variable @Rank...

Michael Kipp (2/7/2008)

---

I think the question was asked in a wrong way (or I read it in a wrong way).

I answered "WHEN NOT MATCHED", as most others.

That is the part...

No there aren't. You will have to disable the foreign and primary key constraints to modify the column.

If the column you're altering is the one that the constraints are on, then you'll have to drop the constraints, make the changes, then recreate the constraints.

Thanks for the info. I forgot all about the meeting.

Does anyone know how to get in on the beta exams?

SELECT Permission_name, class_desc, OBJECT_NAME(major_id), grantee.name AS 'Permission granted to', grantor.name AS 'Permission granted by'

FROM sys.database_permissions dp

INNER JOIN sys.database_principals grantee ON dp.grantee_principal_id = grantee.principal_id

INNER JOIN sys.database_principals grantor ON dp.grantor_principal_id...

I'd love to try it, but the cost is prohibitive, and the travel and hotels, aong with the required 4 weeks off work make it just about impossible.

Exchange rates don't...

It's both. We've had one incident when one of my colleagues detached the database that the trigger...

Yup. Petty much.

I'd definitly suggest you see if she can get some SQL training, formally or informally. How long's it going to be before she does something like write an...

No. It's a query hint. It must be applied to a query, not a storedProc. It only applies to the query it's part of.

SELECT Lots, of, columns

FROM ReallyBigTable

WHERE...

A small nonclustered index (like what I suggested) shouldn't take too long. A clustered index will take a while. Depends on the hardware and the memory available how long

If you...