Yeah, that's the great thing about any of the Object-Relational mapping tools that write your queries for you. Dynamics NAV, Linq, etc. They are amazing, incredible, wonderful tools,...

That's definitely possible.

Or they'll show up in index plans when you're reviewing performance issues.

Until it turns into something that needs fixing ...

If it's not memory pressure, then there may be ways to improve it, or may not. It really depends a lot on the data being queried, and on the...

How about this:

DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003';

SELECT DATENAME(MONTH, @Expiry_Date) + ' ' + DATENAME(DAY, @Expiry_Date) + ', ' + DATENAME(YEAR, @Expiry_Date);

Interesting. The link in the editorial takes me to an article about dynamic retail pricing.

Aha! The URL in the editorial has "amp;" in it where it shouldn't. ...

Most likely, as suggested, a worktable is being used, either because the dataset exceeds the available space in RAM, or because it has to do something with it that is...

As a note on the variations using Apply, I recommend using Outer Apply, in case you have a currency pair that has never had a valid exchange rate in your...

Will this do?

From: http://websters-online-dictionary.org/definition/technology

Technology is a broad concept that deals with a species' usage and knowledge of tools and crafts, and how it affects a species' ability to control and...

How's this:

IF OBJECT_ID(N'tempdb..#test') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test

(currency_to VARCHAR(3),

currency_from VARCHAR(3),

...

TheSQLGuru (12/19/2012)

It is my belief that this query gets a seek (i.e. is SARGable) as a function-around-a-column because Microsoft KNEW it...

I found this white paper on the subject: http://sfdoccentral.symantec.com/sf/5.1/windows/pdf/VCS_SQL_Agent.pdf

Found it by searching via Bing for: sql server on veritas cluster

Does that help?

GilaMonster (12/18/2012)

I can read one of...

Eugene Elutin (12/18/2012)

Yeah, I'm always! But "they" don't understand me.

That is common among us, great painters... :crying:

¦¦¦¦¦¦¦¦¦¦¦¦¦

...

Well, maybe we need a term like "circumstantial SARGability", to indicate that edge cases can be found where "normal SARGability" fails but a clever DBA can get seeks to happen...

Here's a dictionary definition of "technology" (from http://www.bing.com/Dictionary/search?q=define+technology&qpvt=definition+technology&FORM=DTPDIA):

tech·nol·o·gy[ tek nóll?jee ]tech·nol·o·gies Plural

NOUN

1. application of tools and methods: the study, development, and application of devices, machines, and...