Yeah whatever it is you need to store. I would guess the signed version would be the best option.

valeryk2000 (3/28/2012)

---

Sean, this article deals with R2 and mentions that "FILESTREAM RsFx driver is certified for Windows Server 2008 R2" - mine is just plain ss2k8 - does it...

LOL yes in fact they will. The option of course is always...

Sounds to me from your description that everything except Day is the same as the business definition? I would say you have a solid argument about dropping Day from the...

Agreed. 😀 A key that models after the business is certainly preferred. All I was getting at is that a business modeled key tends to be a composite key a...

ScottPletcher (3/28/2012)

---

I would do a query with:

SELECT

COUNT(*) AS [Total],

COUNT(DISTINCT column_1) AS [Column_1],

COUNT(DISTINCT column_2) AS [Column_2],

...

If you need to store them in the database you can use the varbinary(max) datatype. Another option is to use FILESTREAM. http://msdn.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx

Hope that helps.

Really the best way is to analyze what the data represents. Just because there are no duplicates today does not mean there won't be tomorrow. And yes if there is...

Charmer (3/28/2012)

---

Sean Lange (3/28/2012)

---

You asked for some advice on structuring your data better and I was trying to figure out why every table and column have names that are only...

Pretty sparse on the details here. Could you be dealing with parameter sniffing?

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/%5B/url%5D

It is pretty hard to say what the issue is without some a lot more information.

Charmer (3/28/2012)

---

Sean Lange (3/28/2012)

---

Do you have to interface with a mainframe or some other older system? The reason I ask is all of your names are so short. It is...

For reference here is ddl for the missing table. It would be helpful if in the future you would post this directly in your post instead of attachments (especially Word...

Do you have to interface with a mainframe or some other older system? The reason I ask is all of your names are so short. It is nearly impossible to...

DISTINCT???

If you want real answer you need to give us some information to work with. See the first link in my signature.

It sounds like you have some question other than the first case statements but you didn't say what the question is.

The first set of case statements

casewhen vol.subclient is null...