Ian Scarlett (7/2/2009)

---

Err, Jack, isn't

SELECT A.*

FROM...

Well, it depends.

Can you modify the table structure to include the calculated column?

Are the values in conditionvariables changing?

The beauty of Lowell's solution is that, if the...

GilaMonster (7/2/2009)

---

Anyone want to take a stab at this?

http://www.sqlservercentral.com/Forums/Topic746075-360-1.aspx

Converting the while to a select off a (large) tally table's the easy part. The no duplicate values and exact number of...

Dave Ballantyne (7/2/2009)

---

Scalar udfs are generally quite slow and should be avoided.

Try to isolated the issue , what is performance like if you make it a sequential count ?

Also i...

Nice solution though Lowell, and probably better than doing it using SSIS. I really like the concept of doing...

Okay, then if you have to use SSIS I'd use an Execute SQL Task with code like this:

-- create test table variables

DECLARE @stats TABLE (location VARCHAR(25), DATE DATETIME, a_temp FLOAT,...

Are these tables in the same database?

Just to provide an example check out this code in AdventureWorks:

SET STATISTICS IO ON

SET STATISTICS TIME ON

SELECT

SalesOrderDetailID

FROM

Sales.SalesOrderDetail AS...

I would say yes, because in the first query you are only reading one table, but in the second you are reading 2 tables. On small tables it may...

You might be best serverd by adding a computed column to the table that contains the number of seconds (milliseconds if you need this fine a granularity) and then using...

As David has said there isn't a simple answer. The Optimizer checks the conditions and then makes a best guess as to what access path will be the best,...

Whenever I recommend using sp_MSForEachTable I always include a link to this article which explains the parameters of the procedure and how it works.

I would script out all my procedures,...

I had...

All you need to do is change the owner of the app_views schema to dbo. Then the SQL Server will use ownership chaining to allow access to the base...

Yes, the fact that all the tables are on the linked server would support creating a stored procedure on that server.