Do you have some sort of weekly deployments or script refreshes? If you drop and re-create a procedure, any explicit permissions granted for that procedure get dropped with the...

A couple things:

1. < and > are not allowed in attribute values. Change all of the "<Unassigned>" values to "& lt;Unassigned& gt;" (remove the spaces between "&" and...

MSDN Article "How to resolve blocking problems that are caused by lock escalation in SQL Server":

http://support.microsoft.com/kb/323630/en-us

Note: Sessions can deadlock themselves, due to parallelism. Rare, but it happens, and troubleshooting it is a real pain.

Not one hand clapping so much as the fingers getting into...

The problem is that the base string value must be assigned a datatype in order to be processed before it can be assigned to your variable. Even though that...

Correct. With SQL Server 2000, you cannot feed a TVF from the query itself.

SELECT *

FROM @source_data sd

CROSS APPLY dbo.ft_kulcs_lista(sd.kulcsok) fkl

Without seeing the table DDL, I'm guessing you're storing the encrypted values as varbinary. String values can easily be converted into binary values (each byte represents an ASCII character...

At 25 bytes per row, and only 700 rows, this is a tiny table taking up only a few data pages.

From Books OnLine, in the ALTER INDEX topic, under the...

Re: Certificate expiration dates

From BOL (CREATE CERTIFICATE):

Built-in functions for encryption and signing do not check the expiration dates of certificates. Users of these functions must decide when to check certificate...

It must always be opened. However, if that key has been encrypted by the...

Two thoughts:

1. Check out the article "How to: Create Identical Symmetric Keys on Two Servers"

Here: http://msdn.microsoft.com/en-us/library/ms366281(SQL.90).aspx

2. In your sample script, you are not opening your database...

I've picked up a lot of certs over the years, and one thing I can say with certainty: I have learned something new each time.

For nearly everyone, studying for...

Like most SQL Server questions, the answer is "It depends" 🙂

To plan something like that, there are a number of questions about the config and usage I would take into...

I grabbed this from an earlier post by someone else, but I've forgotten who the original poster was.

You can run the following on each instance periodically to view recent CPU...