SELECT TOP 1000 WITH TIES DT.telephoneid , DT.Requests

FROM (

SELECT telephoneid,count(*) AS Requests

FROM tbl

GROUP BY telephoneid

) AS DT.

ORDER BY DT.Requests DESC

This will return the TOP 1000 but also take into account...

I am very much of the opinion that it is small inch pebble steps that change the world rather than the big bang approach.

If you take a step out of...

I would plan to convert the queries over time because Access can cause huge locking problems.

Someone on this site recommended using pass thru queries but that means converting your queries...

Actually, 15 miles probably isn't enough!

On March 29th 2004 in Manchester UK an underground fire in a tunnel containing telecommunication wires took out an area that certainly extends to where...

This confirms what is written in BOL i.e. each table can only appear once in a cascade relationship and you can't have circular references.

Basically, you have to design your database...

Don't use SELECT INTO.  It is an expensive way to do it.

DECLARE your table variable or create your temporary table then use INSERT ... SELECT

I would also split out your...

Was that underground fire the one in the British Telecom exchange in Manchester?

I am not aware of any issues with it other than the obvious mechanics i.e. you accidentally delete the wrong parent record and lose reams of irreplaceable data.

I know that...

In SQL2000 when declaring referential integrity there is an option to "Cascade Delete" related records.

If this option is set then deleting a parent will cascade delete the children with no...

Don't forget that it isn't just action queries that need to be converted to procs.  Select queries that accept parameters will also need conversion.

I seem to remember a package called...

We use a standard DES algorithmn that is wrapped up in a DLL.

You can download one off the net.

The DLL looks at a registry key value to get the seed...

The way that we did it was

• Set up a domain level account to run MSSQLSERVER and SQLSERVERAGENT.
• Give the account bare minimum priviledges on the network.
• Set up an Exchange mailbox for...

I would go further and say that "wrong" tends to be a matter of opinion rather than hard fact.

The general recommendation is that you don't use sp_ as a prefix for stored procedures because internally SQL Server will look in the MASTER database first causing a cache miss.

I'm with...

One plus point on using prefixes is that you are unlikely to use a reserved word accidentally.

Given the plethora or languages out there it becomes ever easier to do this.

I...