Chowdary's (7/30/2014)
Hi Eirikur Eiriksson,Pls find the below
1. What is the output of this query?
A:Enterprise Edition (64-bit),3
2. Can you post the CREATE TABLE script for the table?
A.PFA
3. Is this a production server :Yes
Regards
Chowdary....
Few of more questions,
4. How many rows are in the table
5. What is the output of this query? SELECT SUM(DATALENGTH([MEMBERPHOTO])) AS PHOTO_SIZE FROM [dbo].[tblSalesMemberMaster]
6. How is the [MEMBERPHOTO] used?
7. Where does the [MemberNo] value come from?
8. Is the [MemberNo] ever increasing?
Reason for asking is that the [MEMBERPHOTO] (Image) will not compress and Image is also a depreciated data type. An option here might me to move the column into another filegroup, table or filestream, certainly cannot recommend keeping it in the primary filegroup.
😎