Or, rather than hard coding all those values in a query, create a table and store them there. It'll sure make maintenance easier.

Can you break it down and run a couple of steps at a time? I tried duplicating the script in miniature and it worked fine.

CREATE TABLE x ( id INT,...

Another vote for using the OUTPUT clause. That's incredibly useful for doing exactly what you're asking for.

Also, I wouldn't recommend using @@IDENTITY. @@IDENTITY is not limited by the scope of...

GilaMonster (9/10/2008)

---

Itzik Ben-Gan did a demo last year at PASS. It's got nothing to do with bad data. All it requires is that a page split occurs during a scan...

Ah, that's a shortcoming with the tool, not SQL Server. Ummm, you might try associating to the first column and then renaming the association (not sure how to do that)...

I'd start by attempting to kill the process. That should initiate a rollback, meaning whatever changes that process had been making will go away, but you shouldn't have problems with...

The best description of this I've seen is contained in the first two chapters of Itzik Ben-Gan's book, Inside SQL Server 2005: T-SQL Querying.

If I understand the question, you simply add the relationship three different times, relating the lookup value to the three different columns individually. It's a fine method.

Hooey.

If it's a reporting system, and only a reporting system, you should mark the database itself as read only.

Dropping the tables every time and then recreating the entire data set will eventually become much more painful than joining between the tables to move only the new data. For...

Batch complete and RPC complete measure the time on the SQL Server. They don't, necessarily, include network time. The reason I put a caveat there is because very large data...

You can't just remove a lock. That's data being manipulated and stopping the manipulation mid-stream will break the integrity of the data in the table, possibly losing that data, the...

Yeah, MAXDOP has been useful situationally. Although if I see a lot of queries suffering from parallelism, I'll raise the threshold.

lklein (9/8/2008)

---

They were report starving. I just don't see how I can give them the data they want without using temp or declared tables. Any other ideas or...

lklein (9/5/2008)

---

It was just filling up. Then it got to big obviously and caused other issues. It had been 3 weeks since that server was restarted. Is...