Actually, there is nothing wrong with your original SQL but think about what the requirement to compare every name and address to every other combination of name and address what...

This solution uses each hit as a starting point to look at the next one minute of time for hits on different ports to the same host and source.

This could...

An additional comment on tracing.

If one uses the SQL Profilier to capture the trace information, I have found that this tool does have an effect on the overall performance of...

Regarding your comments on the trace invalidating the statistics.

"But every execution of UDF adds extra record into statistics log."

It depends on how the trace is configured.

The trace used to capture...

After re-reading the post, I realize that I did NOT use Terminal Services to perform the upgrade but instead used Remote Desktop Protocol (RDP).

You can download RDP from...

I have at least 5 other sets of comparisons to run to be included in the final article and the results make the DATEONLY UDF look good. A lot...

UDFs and the impact on performance.

Abstract:

Most SQL Database Management Systems include the capability of allowing the user to implement an algorithm by writing their own functions either in a SQL...

"Carl, you started this and have been amazingly quiet... are you just taking notes and waiting for the dust to settle or what?"

Someone has been out sick for the last...

"have you tried to upgrade SQL Server 7 to 2000 using Terminal Services?"

Yes.

"Did it work?"

Yes, eventually, but it does leave the directory structure rather messy. You will have...

Thanks for the feedback especially that the benchmark needs to be run on a variety of hardware. I will make sure to run the benchmark on hardware varying between...

System procedure sp_MSobjectprivs can be used with all types of objects.

-- Table

exec Northwind.dbo.sp_MSobjectprivs @objname = 'dbo.Customers'

-- View

exec Northwind.dbo.sp_MSobjectprivs @objname = 'dbo.Alphabetical list of products'

-- Stored Procedure

exec Northwind.dbo.sp_MSobjectprivs @objname = 'dbo.Sales...

Please provide DDL and sample data.

For an explanation, see http://www.aspfaq.com/etiquette.asp?id=5006

Yes, I have run into this situation many times especially when the root cause is loss of connectivity to SANs and therefore, loss of the ability to access the database...

Temporary tables are useful for development and debuging where you need to examine the intemediate results.

Say you have:

insert into #One (select ... from ONE ....) as One

insert into #Two (select...

Based on your post:

1. For each email address, get a count of unique usernames.

SQL:

select email, count(distinct username)

from dup_emails

group by email

Result:

brad@yahoo.com4

jack@gmail.com2

john@gmail.com3

mike@yahoo.com3

2. For each username, check to see that it...