i cannot find it now, but Sean Lange posted an answer to a question that was near identical to this idea, and noted all the grievous, serious problems that were...

well the things i see so far are:

you are joining other tables to a view vw_Return_Entity_Ops

it is very common that a view will grab substatially more columns thyan you...

i have this saved in my snippets; it's calculating the min and max longitudes/latittudes for a specific point, which you then use to bracket in the values search a...

certainly possible, i think it goes directly to your data;

do you have polygon boundaries for your cities, or a simple single point per city?

either way, you can build...

i baby sit a non profit that has a 6000 member email list, and we used send out various notifications just like you plan; the whole one at a time,...

well going forward, you could add a check constraint...

The only way to make it perform better is to make the search terms Sarg-able and index-able, as John referred to, otherwise you are stuck with a table scan.

you could...

Adam i think just doing UNION or UNION all would probably be better than the OR statements ; one of those simple fixes that should have a perfroamnce imact:

SELECT ..

LEFT...

you'll want to look into using the OUTPUT clause so you can capture the new identity values, along with your data, so tyou can isnert/update the second table.

here's just one...

read up at Gails blog on catch all queries: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

here's an example of a catch all query:

WHERE 1 = CASE

...

i've added Phil Factor's Regular Expressions CLRs[/url] to my servers for a while now ;

in several of my projects, the regular expressions, since they are inline table value functions, are...

nice job providing the sample data!

in this case, you need to get the "sets" organized first so they can be compared.

Someone else may have another method, but i thought using...

hayden_jones (1/31/2014)

---

I have a report to run every day in SSMS. I have selected query options to send results to a file with pipe delimited results. Tomorrow, I...

here's one that i just got bitten with and added to my common checks:

i added a filtered index, and a stored proc that updated the table with the...

ok in that case, what you want is a certificate signed stored procedure.

then the credentials of the certificate are used, and that can satisfy the cross database/instance permissions issue, i...