Have you got a server somewhere where you can do a test restore of your backup. I know restoring system databases is a pain but for peace of mind...

See if this helps

http://www.sqlservercentral.com/articles/Administering/utilityprocedures/2272/

ISO8859 seems to refer to Latin character sets.

Can you give a specific example of what is going wrong?

I use XML EXPLICIT when I need a specifc layout but only when...

I deployment and rollback scripts for everything as a matter of course that way I know I have a way of installing and uninstalling software in a hurry if need...

I would create a table that holds a flag.

Have your trigger set the flag

Set up a schedule job that runs every minute or so with a task that says

IF EXISTS(SELECT...

SELECT *

FROM tblEmp

WHERE empjob=1

AND emprole <>'clerk'

Sad:

Just found out why it was so important to back up the database master key.

Forgot to put a WHERE clause on a DELETE/UPDATE.

Selfish:

Implements something in LIVE 5 minutes before leaving...

Do you have the option to move use another server as your distributor?

I'm thinking that if your production server fills due to growth in your distribution database then this will...

I'm not sure about that Jeff.

I have come across situations where the firehose cursor is faster than the loop.

I pinned it down to the loop running many separate queries where...

SELECT P.*

FROM PurchaseOrders AS P

INNER JOIN (

SELECT PurchaseOrderNumber, Max(Posuf) AS LastPosuf

FROM PurchaseOrders

GROUP BY PurchaseOrderNumber

) AS PM

ON P.PurchaseOrdernumber = PM.PurchaseOrdernumber

AND P.Posuf = PM.LastPosuf

I know of a company who use "The company can't afford it" whenever staff perks com up, or for that matter whenever the annual bonus is due.

This is the same...

You could always fall back to the old

SET ROWCOUNT @Variable

SELECT ....etc

SET ROWCOUNT 0

In terms of set based processing it simply means that you look at the data as a whole...

The fundamental ideas about Agile Development XP, RUP, AUP etc are good, it is the practice that worries me.

In Britain, industry wants a cheap temporary fix that will last for...

I sometimes think that companies hire DBAs...

All the articles I have read on agile development acknowledge that the database layer is the one that acts as a bottle neck.

Agile development is about completing a single project...