I've played around with schemas a bit and the problems I have had have been to do with security. To be more precise, granting access to objects in one...

In terms of design I would have 3 tables

1. Location

2. User

3. LocationUserMap

This means that locations and users are independent and the relationship between them is held in the mapping table.

Using SELECT INTO to create the initial table structure with no records is "blink of an eye" fast.

SELECT INTO to...

So why would SELECT INTO not lock sysobjects?

Surely any form of creation of an object would have a small lock on sysobjects?

The other point is, how often are records created...

Jeff, I have found that small amounts of data in table variables outperforms the same thing done in temporary tables.

As data volumes increase table variables rapidly lose any advantage. ...

Let us suppose you have tables with say 25 million bank account details and child benefit information.

You allow direct read access on these tables so said government half wit can...

I don't really understand what you have written but it sounds as if you want to use a case statement within a SUM.

SELECT SUM(CASE Transactions.TollDiscountID WHEN 4 THEN 1 ELSE...

The Microsoft article says that table variables are not memory only structures and are created in TEMPDB if needed. My experience has been that large inserts into table variables...

I would do this in two stages.

SELECT * INTO newtable FROM oldtable WHERE 1=0

INSERT INTO newtable

SELECT * FROM oldtable.

The first statement creates the table in the desired structure but with...

Fantastic. Thanks for the link. The old problems I described were with the old windows task manager application which simply wasn't geared up to cope with hyperthreaded CPUs...

When your developer says "An event" does he mean an event in a database?

Does he need it to be synchronous i.e the instant the event happens, generate a file? ...

I read somewhere that you have to be careful of the standard windows tools for monitoring memory usage as they don't give an accurate picture of higher memory usage.

I used to use...

I work in an environment with SQL2000 and SQL2005 and have found that I run into problems where replication thinks it should be running sp_MSdelMyTable

but replication has created

sp_MSdeldboMyTable.

Check to...

I've found that having PULL subscriptions helps because the subscriber has to do alot of the work. With PUSH subscriptions the distributor has to do absolutely everything.

I would also...