I was wondering the same thing, but since he is including the ids for both customer and person that seems appropriate. What do you think?

SQL and C# are a complete paradigm shift. You have to think in terms of sets. For your issue there isn't a great way to do it (that...

No, but it will give you a count of the matches. What are the columns in the match table? When they ask for ddl's they really want you...

Is that what you are looking for:

select

a.customerid,

a.firstname,

count(distinct b.profileid)

from customers a

inner join persons b on

a.firstname = b.firstname

group by a.customerid,

a.firstname

I guess it just always depends...I should of known.

Thanks for the tips though!

Do you have a rule of thumb for functions? I am timid to use them after some disastrously

horrible code I had written at one point 🙂

I hate...

Found it! If you create an index on an existing temp table that currently contains data you will request showplan data from tempdb. Not sure this is the...

So my question needs to be what are they using that is requiring access to run SHOWPLAN on tempdb!

Thanks for the example!

Modulus is much nicer than the substring with the cast!

Thanks!

That is prettier, but I think the duration will have to be converted to seconds prior to the average and back to their format post the average.

You are right...

They received an error about being able to view SHOWPLAN on tempdb, and I assumed it was the temp tables they were creating and querying against.

Is that not the case?

Will...

You guys are all kinds of super nerds.

Well apparently I should of looked at it some more this morning before posting...when I switched to CONTAINSTABLE instead of FREETEXTTABLE it returned valid ranks. The word I searched...

Thanks! I read your blog and it answered all the questions I was going to attempt to answer through testing. I will probably try them anyways just to...

I tested the following:

I created a full recovery database and ran this code:

use A

create table a (b int)

create table b (c varchar(64))

declare @i int = 0;

declare @j-2 int...