SELECT COUNT(*) FROM (

select distinct firstname,lastname,address,Null as address2,city,state,zipcode,country,phone,email,'ms' as datagroup

from marketscout02.dbo.users

...

What do you see in the sql error log about this issue?

If nothing there, windows logs?

It looks like no source & change management control to me :-).

That'd be the real issue!

Alexander Suprun (11/8/2011)

---

Ninja's_RGR'us (11/8/2011)

---

TheSQLGuru (11/8/2011)

---

Andy Reilly (11/7/2011)

---

Hi,

I have a query that is causing me problems. I restore the db run the sp and it takes 20+ seconds. I...

Please save the plans as .sqlplan and upload here. You can't possibly retype everything we need.

The only point I can bring on the table is that it's really annoying to load all those projects on startup. I have a "small" solutions with 200 reports...

Sapen (11/8/2011)

---

Shd i still consider it a best practice to have the checkdb run before my differential backup that runs every night (except friday night). I am running the checkdb...

Why are you asking?

That's the code that is run internally by checkdb().

Both checkdb and backup are real heavy on the disks so it's quite likely that they are slowing each other down (not...

Go back to read the business requirements of this code.

That screams bug to me.

I've seen this type of code often when the user actually needs top 1 order by x....

TheSQLGuru (11/8/2011)

---

Andy Reilly (11/7/2011)

---

Hi,

I have a query that is causing me problems. I restore the db run the sp and it takes 20+ seconds. I do nothing but...

sjimmo (11/8/2011)

---

Using openrowset will allow you to perform selects between servers that are not using linked servers. We do this amongst many servers on our network. We do this because...

It's the way it's supposed to be used by DESIGN.

No way around it except openrowset / openquery. I forget which one doesn't required the linked server.

Dev @ +91 973 913 6683 (11/8/2011)

---

I am sorry,...

How did you make sure it doesn't even reach sql server?

The standard answer is to tune the queries so they run faster.