jbalbo (2/6/2013)

---

Hi

I have this in a where :

AND

CASE WHEN @InfoKey = 5 THEN

CLIENT_IDENTIFIER_TYPE.Code IN (028,029,030)

ELSE

CLIENT_IDENTIFIER_TYPE.Code =...

Your brute force method can't possibly be giving you the correct int result.

Given that each byte of the varbinary is 8 bits of an integer you would have to multiple...

I am sampling key performance counters from all my primary production servers every 15 minutes and save 60 days worth of this history. We have other snapshot audits that will...

I would estimate that at least 20% of processes we have running and the resulting data generated are there exclusively to satisfy PCI and ISO audits.

jimbobmcgee (1/16/2013)

---

Secondly, the complexity. XML is not fun to work with. XML is especially not fun to work with in SQL Server. Sure, anyone can write a...

IIF() is a microsoft Access construct. That won't work with SQL Server.

Look into the CASE statement instead.

If you maintain the previous days trade rate for each currency (or a default trade rate) in a table (or a CTE from historical table) you can obtain the default...

I remember running into that a while back. for whatever reason I could not put my finger on why other than assume the database status was something that resulted in...

typically asymmetric keys are used to protect symmetric keys.

brett.walker (11/29/2012)

---

2008 R2 severe performance issues

- Only 75 GB of 132 GB memory in use.

I don't understand this one. I've set max memory for SQL Server to be 104...

As other have stated it is not clear exactly what sort of logic you are trying to achieve with just a select statement.

Having said that though, your case statement is...

Guys, you should go ahead and perform a trial upgrade so you know where you stand.

If it were me, I'd try restoring a backup to the newer version and run...

Basically, yes. If you are using encryption or service broker it would make things easier if you had a backup of the service master key to be restored to a...

He means use raiserror() in the catch block.

Dev-812464 (8/16/2012)

---

From application in 2005 it was taking 22 mins to bulkinsert 10,000 Items, but in 2008 its taking 39 mins. While insert is running I am not able to...