Viewing 15 posts - 2,581 through 2,595 (of 13,469 total)
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...
February 3, 2014 at 2:19 pm
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...
February 3, 2014 at 2:05 pm
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...
February 3, 2014 at 1:48 pm
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...
February 3, 2014 at 1:11 pm
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,...
February 3, 2014 at 12:15 pm
djj (2/3/2014)
Lowell, thanks for the reply. I am actually looking to delete the "bad" numbers so yes it is an IN.
well going forward, you could add a check constraint...
February 3, 2014 at 12:02 pm
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...
February 3, 2014 at 11:34 am
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...
February 3, 2014 at 9:19 am
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...
February 3, 2014 at 8:45 am
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
...
February 3, 2014 at 8:23 am
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...
February 3, 2014 at 7:16 am
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...
February 3, 2014 at 6:49 am
hayden_jones (1/31/2014)
January 31, 2014 at 9:59 am
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...
January 31, 2014 at 9:28 am
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...
January 31, 2014 at 9:06 am
Viewing 15 posts - 2,581 through 2,595 (of 13,469 total)