?

I will add, for those who are interested, this table supports a dynamic form-builder application. Users create their own custom forms with any number of custom fields of string,...

Can you even change the EAV to use type SQL_VARIANT?

declare @testFieldType table(fieldId int, code varchar(20))

declare @testDocDataFieldValues table(fieldId int, fieldvalue SQL_VARIANT)

insert into @testFieldType values (1, 'fieldTypeNumeric')

insert into @testFieldType values (2, 'fieldTypeString')

insert...

What is "reader" ??

Congratulations, Gianluca 😀

ROW_NUMBER() is an EXCELLENT way of identifying dups and getting rid of all but one.

Good job.

pdanes2 (12/19/2010)

Hmm, yes, I...

I have this huge table. The SELECT perfromance is very bad. So I was thinking to add more indexes, which of course will affect INSERT perfromance. So I was just...

I wonder, might it be worthwhile for the initial load to create separate Boolean fields whose values corresponds to the results of such queries? That is, one Boolean field...

Here is an example of pulling 20 random rows from a million row table.

Note to Jeff Moden: It may not be "Nasty Fast" but it's "Wicked Quick" 😀

Had...

Using ORDER BY NEWID() with huge files is slow, because of the sort time.

Generating TOP (X) WHERE (random number test) is fast, but tends to skew towards the front of...

Anytime you don't know the tables in advance, you will have to use dynamic SQL to get there. Either way, you may find the Cross Apply easier...

You tell 'em, Steve !!!

I wander in here for the first time in a month and get bombarded with utterly useful technical information.

Now I know how...

Sorry for the delay, I was working at my paying job. 😉

This should work for you too if you are running SQL2008.

In production, you should consider indexing...

Put a PRINT @sql statement right before EXEC sp_ExecuteSQL and lets see what values you are passing.