quote:

---

I have problems with a sqlserver 7 machine with 4 processors and queries running very slowly because of bad queryplans. On...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17178&FORUM_ID=8&CAT_ID=1

--Jonathan

Detach the database (sp_detach_db), rename the files, and then attach the database (sp_attach_db) using the new filenames.

Or you could leave the filenames on the old database alone and do a...

We recommend at least once a year and whenever any component of the backup process changes.

--Jonathan

Normalize your schema. Here's a solution that normalizes your data so that the SQL is easy:

SELECT v.Id, l.LabelName, v.Val

FROM 

(SELECT Id, Label_Id, CAST(Text1 as sql_variant)...

quote:

---

Amazing what an hour's thought can do. Have figured it out. Probably not the most efficient way of doing it but it...

quote:

---

My solution was similar to Jonathan's but I had reservations about performance using it against 200,000 records. If it is a one...

quote:

---

But, what about CALs for a webserver/database server that runs SSL for secure credit card processing. All users would be anonymous cause...

quote:

---

Jonathan,

Something I almost missed. You said: "(no mixing)"...

Does that mean if we have user CALS we can't use device CALs?

Hopefully that's...

I don't understand either of the above "answers," but I think you need to read the updated BOL entry on Security Account Delegation.

--Jonathan

This should be faster than a cursor:

UPDATE Tracking

SET Transaction_Change =

 CASE WHEN HBMID_CODE = 

  (SELECT TOP 1 HBMID_CODE

   FROM Tracking t

 ...

Wow; is it just me or is that some scary code?

Just this might be equivalent:

CREATE PROCEDURE USP_GetOneCompletedRecord

--This Stored Procedure will get the accounts that are completed

@intMasterAcctID...

quote:

---

I would like to take out the columns from the update statement, but unfortunately, I can't. The users have to have...

Use "queryout" rather than "out" with a query ordering by the clustered index. Then, if you don't change the indexed values, you can load using the ORDER hint.

quote:

---

quote:

---

Uh, you realize that this will add all rows into your audit table...