what about

d) whatever, just not in my database tier ?

If the db is incrementally near real time loaded, the reports are not ad-hoc or are slowly changing and the reporting performance is important; there is an argument for non-clustered...

Wanted to see what the difference aggregating by scalar functions was to see how it would perform based on a native datetime so I ran

PRINT '=============== "Normal"...

any chance of querying the cost column in the sys.dm_clr_appdomains

before...

I was surprised to see the implementation of CTE recursion (in 2005 at least) performed similarly too inbuilt functions for small string lengths (read napkin test of up to 400)...

From someone that is asked to support add hoc reports generated on an EAV it is a difficult exercise to convince end users why certain types of reports are fine...

pduplessis (5/29/2008)

---

I agree that in most cases you can avoid the use of temp tables by structuring your query slightly differently, but for sure, sometimes they are unavoidable.

[snip]...

Firstly,...

Surveys are Frequently collected for statistics.

Bit mask seems like a poor choice. You'd force the query plan to scan the bitmask field to look for all surveys that answered question...

In an ideal world consistent solutions for all instances consistent with a problem type while the technology is static.

Only problems aren't consistent and technology is always changing.

They are not the...

Consistancy aids in the quality of readability. But it is not all qualities.

There is a point when any template for a solution is used commonly enough that it should...

Software Quality and consistency is notoriously hard to measure.

An Elegant solution has risks that a solution that follows the path of least surprises does not.

It is worth...

In Sql server a table with...

INMHO the confusion comes from the clustered index term in SQL Server.

In other DBMS's for example DB2 there is no concept of a primary clustered index because the primary key...

I would be hesitant about deleting duplicates in the same statement that finds them. If the table was non trivial size (ie. you didnt want to hand list the...

Are you sure you don't mean

INSERT INTO phonebook SELECT

[phonenumber],

[firstname] ,

[lastname] ,

[company]

FROM #tmp

DROP TABLE #Tmp

at the end