Funnily enough,...

Interesting, i knew about parameter sniffing in terms of a parameter being passed to a procedure but not being able to work out its value, but not when its explicitly...

what is the "normal" value? ie, before its failed over?

I believe we will have to regenerate the keys as well as when the guy who set these up did it, he used ENCRYPTION BY CERTIFICATE but neglected to supply...

sorry to piggy back this topic but i'm in a similar situation. We currently encrypt data at the column level using certs / symmetric keys. As part of our PCI...

as far as i can tell, come may when R2 is released, that is the only version you can buy licenses for, but you will be able to run "R1"...

http://blogs.msdn.com/sellinglicensing/archive/2010/02/04/sql-price-increases.aspx

SQL Price Increases

Summary:

With the release of SQL Server 2008 R2 (April price lists), there will be a

15% increase in the processor pricing of SQL Server 2008 Enterprise Edition and a...

on this, can anyone confirm for me whether the...

does anyone know of any step by step guides to setup a sample DWH. I've read a lot of the literature and installed the AdventureworksDW sample but obviously that is...

personally i'm talking about having NetApp as our storage solution for everything - including sql server. What i'm worried about iis that there isn't much on any forums regarding this...

i am also in this situation and would luv to hear any feedback....:-D

I wrote a blog regarding issues i was having with that:

http://www.sqlservercentral.com/blogs/christaylor/archive/2009/05/04/sql-server-cpu-s-at-100-anyone-checked-the-vas-virtual-address-space.aspx

I have however just realised i've negated to include in the blog the fact that we got a lot of...

they're also common when your server has ran out of VAS (Virtual Address Space)

did you ever get an answer to this? I'm in the same situation myself....

erm, not quite. I already have sql server 2005 SP3 installed (patched to CU5) on the server, what i'm asking is whether the "Common Criteria Certification" profile will work under...