llevity (10/1/2008)

---

If we did that, would it cause objects with the same name to clash? In other words, if databaseA had an Employee table, could databaseB also have an...

They might. I've never used them.

blake colson (10/1/2008)

---

SOLUTION: UPDATE STATISTICS on key table used within the query. My query returned in < 10 seconds where before I was killing it after 10, 20,...

Then you have no corruption. That's...

Pretty much what I'd do.

If you're not going to use schemas, put the objects in the dbo schema and set all the users' default schemas to dbo.

Is something else perhaps reading the error log file? An anitvirus, a text file, some other process?

p.s. could you please edit your post to fix the width?

Appropriate indexes?

Not really enough info. Can you post the table structure, the existing indexes and the query. Also an idea of the number of rows in the table would help.

DBCC CHECKDB( < Database name > ) WITH NO_INFOMSGS

Post the output here, and we can help you interpret it.

Apparently the issue was related to bug no. 6646512, whatever that is. 😉

The creation of the publication now runs in a reasonable time, but the log reader's still timing out....

Normally SQL systems that I see have 2 or 4 GB...

Maxer (10/1/2008)

---

It seems like it grabs Phone and Email from its leaf level, but still has to jump to the clustered index to get the Fname and Lname since it...

See this blog post, specifically the first section "SQL Server Uses One Thread Per Data File"

http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

As has been said before in this thread, if the table variable...

bcronce (10/1/2008)

---

GilaMonster (9/26/2008)

---

One other misconception. A clustered index scan is not better than a table scan. It's the same thing. It's called a table scan when run on a heap...

Maybe. It's worth testing, however in 2005 and higher, the optimiser has the same options for optimising an 'or' as it has optimising a 'union', and there's a good chance...