A general approach to performance tuning is to first find out which part of the process is taking the longest and attack that first. Then repeat. Each bottleneck...

As long as CUs are being released, there should be a regular SP release.

When the product becomes so stable that no CUs are created, then no SP is needed.

Good question. I've learned the hard way not to assume I know the answer. I would not have expected the error in this case, and something else new...

You could use a unique index or constraint.

I agree. I would say more but I think my manager reads these.

Hi Boss! 😀

Dan Fran (4/21/2010)

I am curious to know if there is a way to determine the size of a specific row/record in a given table. I know that sqlserver only...

John, I would say that is not normal, but not that uncommon. If the lead DBA would ever like to take some time off, he should make sure you...

OK, I so did not understand this question. It wasn't until I read the explanation that I recognized that field1 and field2 were parts of the name!! (Wow,...

It's showing the same thing for me. We are at SP1, CU7.

You have to configure a different profile for each sender.

Something like this :

DECLARE @ProcessCount int

SELECT @ProcessCount = COUNT(id)

FROM MyTable

WHERE ProcessStamp < DATEADD(MM,-60,GETDATE())

IF @ProcessCount <> 0

BEGIN

EXEC msdb..sp_send_dbmail

@recipients = 'Bozo.D.Clown@MyCompany.com',

@subject = 'Process Update Status',

@body = 'Process Failed to update...

Either tune your query (assuming it's a query) in your job to run in less time, or increase the interval between job starts. Jobs will not restart if they...

Unknown might be the BOL answer, but it doesn't help from either a practical sense or a conceptual sense. It is best to think of NULL as NULL.

A good...

What is this QSL Server you speak of ? 😛

Sometimes it pays to guess. 😀