Ah the linguistic differences again. Took me a bit to remember that "pinching" is slang for "stealing". Like the fact that a nickname is the name they gave...

Glad you all enjoyed it.

I forgot to mention that the museum curator told me that he has to replace the "turd" at frequent intervals because kids keep pinching it.

For all...

There is always a problem creating the "must have" product when you have no idea what that product the consumer will consider to be "must have".

What I read into Joel's...

If I am altering the structure of a table then at the end of my script I put

exec sp_recompile ' '

UPDATE STATISTICS

If it is a smallish table then...

Forgive my ignorance on the subject but if you have a virtual server instance with the same spec (CPU, RAM etc) as a physical server am I to expect a...

In a tech shop I can see an argument for delegating the maintenance of PCs down to a responsible team lead. Someone who can be trusted to ensure that...

Is there a service broker manager so the queue size can be monitored?

I think what constitutes an exceptional DBA changes depending on the economic climate.

Obviously technical competence comes into it but at the moment the ability to wring the last possible clock...

rbarryyoung (3/9/2008)

---

First of all you have to determine & define what the Purpose of your Audit Trail is. Is it for:

1) simple diagnostics and troubleshooting of the application &...

Date/Time formatting is always a problem. Unless you know the starting format and the locale then you are going to run into problems.

Even if you start with a date...

In addition to the previous post I believe that CAL licensing has to be done in a minimum of a block of 5.

One CAL is used by the server itself...

As the most up-to-date status for an item is likely to be important I would enclose this functionality in a view.

CREATE VIEW LastItemDetail

AS

SELECT ItemID,StatusDate,StatusDetail

FROM TableB AS B

INNER JOIN (

SELECT...

If its Adventureworks that you are replicating to 2000 I would check to see if the SQL2005 schema's are the issue.

Failing that, run the sp_MSins stored procedure at your subscriber...

The thing that worries me with Linked Servers is the security aspect.

Our SQL2000 boxes won't delegate but our SQL2005 boxes work just fine.

We have trawled through just about every obscure...

I've come across...