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

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

Last year, the early-bird rate effectively became your code, and you couldn't specify two codes. Thus, all the pre-con discussion about how to buy in to the party if...

Normal aggregate functions (SUM(), AVG, () COUNT(), MIN(), MAX(), etc.) are available to be used as windowed functions (using OVER and PARTITION BY).

SELECT Title,Subject, Max(Price) OVER(PARTITION BY Subject) As MaxPriceBySubject

...

I've used MBOPartners.com (formerly mybizoffice.com) for this very thing. You go find your own contracting opportunity, then they execute the statement of work. You enter your time on...

Garadin (12/16/2009)

---

Navigate down in the object browser, then switch to the details window, browse all the way down (I've found the whole filtering system extremely annoying...

I don't know about documentation, we simply ran our own tests on our 3PAR sans:

1. Record SAN allocation

2. Create thin-provisioned LUN, and mount it

3. Record SAN allocation

4. Format mount point

5....

Mani-584606 (11/30/2009)

---

Here, when the entire network goes down, will the SQL Services from active node try to move to passive node? or will they stay at active node itself as...

The key point with IFI is that it doesn't write those zeroes. Using the NTFS Sparse File mechanism, the file is merely marked as being the new size and...

It's been a few years, but I have used this on NetApp SANs without problems.

The feature relates to what Windows/NTFS does with the modified file; the type of storage has...