Jeff Moden (11/20/2014)

---

ZZartin (11/20/2014)

---

There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one who...

No, DBAs should not know and definitely not store end user passwords, period.

App passwords are a different matter, and it can depend on the app. But stored passwords should...

You can't calculate "work hours" without "in" and "out" markers. The work time calc is very easy if you a matching "out" for every "in".

In other words, you need to create a new table that explicitly specifies the clause:

CREATE TABLE ... (

...

TEXTIMAGE_ON [new_filegroup_name]

...

It's almost certainly the NTEXT that is the bulk of the data, and you can't move it without recreating the table entirely. Btw, you should change the ntext to...

No, that's true, but you could use it in a view.

I wasn't not sure what '20140601' was relative to the run date. Is it the current month, the next month, 6 months ago?

Therefore, I used @month_1 to hold the...

swhetsell (11/20/2014)

---

ScottPletcher (11/19/2014)

---

Probably the big thing is to reduce all the gyrations around UnitLog. Please try the query below. If you tend to restrict UnitLog rows using fldDateTime...

NULL will never be "LIKE" or "=" anything. To allow NULL values, you'd have to add:

WHERE (column_name LIKE '%' OR column_name IS NULL)

Try "LIKE" '%' rather than "=" :-).

Something else to check:

Did you explicitly specify the schema name of the table on the ALTER?

If not, make sure you are not accidentally working with a similar table / table...

D'OH, got interrupted by work, forgot one thing.

Let's see if we can also reduce the number rows in the dates side of the JOIN. I'm assuming here that "Sunday"/"Saturday"...

Yeah, that join is not being processed well.

First, try just forcing a HASH join, i.e. writing "INNER HASH JOIN" instead of just INNER JOIN: that should be better here than...

swhetsell (11/19/2014)

---

ScottPletcher (11/19/2014)

---

Didn't see the test data when initially coding. I had to add RCN to the ORDER BY in case there are duplicate times ... although it seems...

Better would be an inline-table-valued-function.

If you intend to stick with a scalar function, at least get rid of the variable:

create function dbo.fu_salesTotal(@idSale int)

returns decimal(12,2)

as

begin;

return isnull((

...