Evil Kraig F (6/6/2013)

---

ScottPletcher (6/6/2013)

---

Dird (6/6/2013)

---

Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the MIN/MAX functions) which I...

Dird (6/6/2013)

---

Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the MIN/MAX functions) which I don't see as a...

Sean Lange (6/6/2013)

---

ScottPletcher (6/6/2013)

---

Ask them::

Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:

Describe the essentials of a single query (no subquery,...

Ask them::

Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:

Describe the essentials of a single query (no subquery, CTE, etc.) to...

Keep in mind that float is an imprecise data type, and the value actually stored in the table may not be exactly the same as the value that was inserted.

GilaMonster (5/22/2013)

---

An absolute statement that you chose to ignore parts of.

I said shrink...

GilaMonster (5/22/2013)

---

Only when you quote me out of context.

If, for the sake of argument, some/all of the...

Purely fyi, I personally think a cross apply that names the value being used makes the code much easier to follow and easier to change later. For example:

Select

*

from...

Isn't that an overly broad assertion? If, for the sake of argument, some/all of the disk extents added were scattered all over...

This should "turn off" the identity property:

SELECT *

INTO dbo.newtable

FROM dbo.table

UNION ALL

SELECT TOP 1 (*)

FROM dbo.table

WHERE 1 = 0

ALTER TABLE dbo.tablename

ADD CONSTRAINT tablename__UQ_SalesmanSSN UNIQUE ( SalesmanSSN )

--of course you can name the constraint...

If you have an (extremely) large table(s), compress them [if on Enterprise Edition], particularly if they are (almost) never used, such as log/audit tables, etc..

First, you need an index on ceb.New_IndividualId: I'll assume you have that already.

Second, I'd cluster the #tmpIndividualCreateDates table by i.IndividualID: I'll assume you've done that already.

I guess the OUTPUT clause...

dwilliscp (5/14/2013)

---

Thanks for the warning Jeff.

On the Jobs front.. We almost never put SQL into the Job, but thanks for reminding me to check there too. Thanks to everyone...

I also search table sys.sql_modules, which contains the code for all sys.objects members of type P, RF, V, TR, FN, IF, TF, and R.

If you want to check for use...