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

The problem is that the database is the bed-rock of modern applications.

If a web-server in a server farm has a memory leak due to dodgy code then an restart isn't...

The one place I have seen a cursor used where it would be difficult to use set based logic was where the results in a row of a particular query...

I can't remember where the quote comes from but it was along the lines of "An organism that ceases to explore its environment is in decline and is ultimately doomed"....

It would be nice if there was a simple document that listed all the features that are going to be deprecated and all those that are to be replaced. It...

I was asked to review a performance issue on a database and came to the conclussion that a covering index would offer a massive boost in performance. I tried...