it's going to look somethign like this: i wasn't sure ont eh join criteria: i was assuming the table ztb_IMP_Notifications has the same sales_order_number

SELECT

ztb_Carrier_Delivery_Metrics.Delivery,

ztb_Carrier_Delivery_Metrics.Delivery_Item,

...

sounds a lot like parameter sniffing;

are you able to modify the procedure?

I'd bet that by adding option (OPTIMIZE FOR (@PayrollID1 UNKNOWN)) it would build better plans.

ALTER PROCEDURE [dbo].[GetPersonalTaxesAccumulators_v2]

( @PayrollID1...

Aspet Golestanian Namagerdi (8/10/2012)

---

Thanks for your replies.This database mail setup used to work,but suddenly stopped working.As I wrote before,I am able to ping and telnet the mailserver(mashine).Regarding authentication,that setting is...

Nice post, Mr. Celko!

here's one way;

the nice thing about this technique, is it makes it very easy to change/adapt to include/exclude other special characters...at least for me it's obvious, that is.

additionally, depending on...

ok how about this idea:

if you grab the free, add-on SSMS Tools

from here:

http://www.ssmstoolspack.com/

one of the options it provides is a "default" template every time you create a new query window...

very true;

i've seem questiosn where the problem query was psoted, the issue is either a syntax issue or something like a case statement manipulation, but a knee-jerk reaction post asking...

Could it be the SSMS version?

Maybe the SSMS for Express with advanced services was installed, instead of SSMS that comes with 2005 STD?

the trick is to use a technique using FOR XML:

does your table have more columns than just the year? the solution's the same, but the detaisl are a little differnet.

here's...

halifaxdal (8/9/2012)

---

Thanks guys, I realized adding "order by" can resolve the issue but was just puzzling on why the result was generated differently and why for each DB the sp...

ok don't telnet by ip address, try to go to the mx record: mail.yoursever.com or whatever.

the DNS resolution seems to be the issue, i'm thinking...either DNS or name change?

wait, your adding a column, updaiting it to a string value, and then dropping the same column?

we can certainly help streamline THAT process.

you can probably use a CTE or something...

lol so true!

thanks for noticing Scott!

I wouldn't be surprised if some just didn't feel like enabling it for you, and used the "it's locked down for security" trump card just to cut off discussion.

I'm agreeing...

if there is no ORDER BY, SQL is free to return the data in any order it deems efficient.

only with an ORDER BY are you guaranteed consistent order by results.

in...