chugghin (8/26/2010)

---

In seeing this post - it also brings a question to mind. If I'm understanding the table structure and the following post - it appears as though they...

chugghin (8/26/2010)

---

I did some more trolling around ('cuz I like to squeeze every last bit of speed from my queries that I know how to) and came across this post:

http://www.sqlservercentral.com/Forums/Topic446175-360-1.aspx

If...

You're just going to have to do the work. You will be able to code & automate some of it, assuming your db & schema names map reasonably well. But...

GilaMonster (8/26/2010)

---

Since we seem to be sharing tales of woe, here's some things about the project I'm currently doing.

The deadline has been set for about 3 weeks.

The requirements were finished...

WayneS (8/26/2010)

---

Stefan Krzywicki (8/26/2010)

---

On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars, trains, boats,...

Yeah, that setting could certainly result in different execution plans.

To see the plan, try querying the DMV sys.dm_exec_query_plans. You'll need to get a plan handle, probably from sys.dm_exec_query_stats and you...

On a guess, check the ANSI settings for the connections. I'll bet you one of them is different.

Sounds like the owner of the database was deleted. You just need to set the owner to a valid login

WayneS (8/25/2010)

---

Hah! Read my...

Ha!...

And, to a large degree, it depends on the other data that is being retrieved by the query. Do you need INCLUDE columns? Should the SSN be part of a...

Yeah, this might be worth a blog post, there's not much out there.

In a nutshell, I'm using XML as the data source. So the type of data source is xml...

fairyuseless (8/24/2010)

---

thanks for all the replies, and sorry for the cross post.

First the "outside" i said means not only through the internet but anywhere except executing the sql code like...

Jeff Moden (8/24/2010)

---

Sorry to bug you...

Jeff Moden (8/24/2010)

---

It's...