Jack Corbett (3/30/2011)

---

Grant Fritchey (3/30/2011)

Oh, and for those interested, I've heard through the grape vine that the call for speakers goes out soon and will be abbreviated this year. Get...

Again, maybe, maybe not. You're also looking at the resources on the system. How much memory is there? Is it possible that you've pushed the DBCC check to the point...

And that blank spot is where the miracle occurs?

CirquedeSQLeil (3/30/2011)

---

Is that process that is running the same as the one we already looked into, or is a new one?

using the spid of that process, use dbcc inputbuffer to...

congratulations.

Oh, and for those interested, I've heard through the grape vine that...

Sorry, I don't get what you're getting at. The queries and the code are all available with the article[/url].

Start here:

SELECT * FROM sys.dm_exec_requests

You'll see what is running and you should be able to see what is locked. Look here

SELECT * FROM sys.dm_db_index_operational_stats(dbid, tableid,NULL,NULL,null) AS ddios

You can at least...

I knew I could get some help in here.

hlpearl (3/30/2011)

---

Grant,

I like your idea on the book management system with versions of books. But the question I have is; if part of the key contains a version representation what...

You have a lot going on under the covers here. Remote queries are likely to cause issues when you're trying to join data. This query:

UPDATE dbo.NED_Employee

SET

Department_ID=d.Department_ID

FROM [DB1].MIT.dbo.National_Employees ne, dbo.ADP_Department d

WHERE...

Andy Leonard is one of the best guys I know for teaching people how to use SSIS. Here's a blog post on incremental loads. It can help to get you...

I don't think that uploaded correctly. It's only 399 bytes.

Or watch this video on how to do it.

Access Denied is a hard error message to argue with. It's telling you the service account that is running the backup can't access that device. You need to double check...

If you drop everything and reinsert everything, you have to log the deletes and the inserts, so you need space in your log to support it.

First, best, choice; don't reload...