Subqueries in the select clause (corrolated sub queries) have a tendency to perform very, very badly. Unless the optimiser is really smart (generally only on simpler queries) the subquery can...

Linked server drivers use the MemToLeave area. I've had a case of a buggly driver leaking memory in MemToLeave and causing slow backups and eventually a system crash.

The thread stacks...

Adam Bean (1/29/2008) Two different SQL Server support techs informed me that issuing a DBCC DBREINDEX, ALTER INDEX REBUILD/REORGANIZE, will NOT update the statistics with fullscan. They recommended having a...

Looks good.

Miranda Johnson (1/30/2008)

---

we use dbo.sp_Whatever when we execute the sprocs. I was told this will make it not look at the master table is that...

Pretty much, assuming the table tower.nbdoc exists.

You just need to specify the column names for the insert and in the select. eg

INSERT INTO ATable (Col1, col2, col3, col4)

SELECT Value1, value2,...

🙂 I'm feeling a bit lazy tonight, so very simple sample code

BTW.

order by case when @sortorder...

Yes and no.

I prefer not to force row locks unless I know that only a very small number of rows are going to be updated. Preferably tune the trigger so...

Then you can try something like this.

select col1, col2 from

(Select distinct col1, col2, col3 from sometable) subquery

order by case when @sortorder = 1 then col1 else col3 end...

aruram (1/30/2008)

---

I am the DBA working with the application team on this, but from my understanding .. the intent is to update the status on a bunch of test results...

1st suggestion - rewrite the trigger and remove the cursor.

2nd suggestion - same as the first. 😉

What's the idea behind the trigger? What are you trying to do when the...

Matt Miller (1/30/2008)

---

Secondary comment - which gets kind of interesting as to the scoping issue.

If the procedure in MASTER is marked as a system stored proc, then it overrides the...

Probably because you cleared the cache. I tend to prime the cache before running tests (run the query once so that I...

Also note that truncating a log (removing inactive log entries) and shrinking the log (reducing the size on disk) are two separate things.

goran (1/30/2008)

---

WTF, this is like kindergarten!

Gail, when you have found one (1!) application in the whole universe that uses the same name on a system stored procedure as on...