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...

Is it the file with a Read Only attribute or the database itself as viewed from within SQL Management Studio?

On release days I have to be in work early and as a deployment involves a whole team of people we exchange mobile phone numbers. No-one wants to turn...

I have a situation where the different lines of business have specific databases but there is a common database that is shared by all lines of business.

The common database is...