Can I set the page size of sql server.

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  June 28, 2011 at 11:54 pm

  #243382

  Can I set the page size of sql server.

  Actually we have a database in which only image files get stored.and those images are bigger than the default page size.

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 29, 2011 at 12:47 am

  #1345661

  forsqlserver (6/28/2011)

  ---

  Can I set the page size of sql server.

  No.

  Actually we have a database in which only image files get stored.and those images are bigger than the default page size.

  What data type are you using? Look into VARBINARY(MAX)

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Syed Jahanzaib Bin hassan

  SSChampion

  Points: 11410

  More actions

  June 29, 2011 at 2:34 am

  #1345719

  Visit on these mentioned below links

  Heading 'Large Row Support'

  http://msdn.microsoft.com/en-us/library/ms190969.aspx

  Heading 'Row Overflow Considerations'

  http://msdn.microsoft.com/en-us/library/ms186981(v=SQL.90).aspx

  Regards,
  Syed Jahanzaib Bin Hassan
  BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog
  www.aureus-salah.com

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  June 29, 2011 at 3:10 am

  #1345734

  Have you considered switch to SQL2008 and using filestream? It is more efficient when dealing with large filesizes.