Generate sql: size

Showing posts with label size. Show all posts

Thursday, March 29, 2012

Formula for Graph Size

I have a report control in my report. But I want to expand graph depending on the selected number of months (Parameter) by users.

But there is no formula option for graph control. Is there any workaround?

You might be able to do something with padding. But that would not change the space your graph takes up in the page, you would just have more (or less) white space, depending on your current data.

>L<

sql

I am trying to work out a formula that works out the change in disk size on our servers and whether they have increased/decreased in size. We have created a table on our database server, that looks at the disk space used, and total disk size. This was created on the 23 March 2007. Effectively the report needs to show the disk history from this date. I have added a parameter on my Crystal report to select the date to view the disk space history, but when I look at the database, the figures I get on my report do not correspond with what it should read. Any help with getting this formula to work would be appreciatedis the 23 March 2007 data remaining static ? if not, then you will have issues.

You should be able to write a simple formula

{field.march23} - {currentvalue}

Your result should be the march23 size, - the current size

without an example, it is difficult to know

Monday, March 26, 2012

Formatting the hard drive

I was wondering if anyone played around with changing the allocation unit size when formatting the hard drive the SQL server is running on. I would think that setting it higher to account for the larger size of the database files would help, but I'm not sure.
Anyone have any thoughts?First, make sure you have a good backup and can restore from it. Stop the service before formatting. Make sure the backup is on another machine or drive.|||While you might be able to find better drive geometry parameters, I've never seen a case where that happened. Windows 2000 and later has never yet failed to pick the best geometry for me.

-PatP|||I have never played with the allocation size in Windows 2000. Theoretically, you might (stress that word, please) get a small benefit from going to an 8Kb allocation size. Then you might be able to turn off the Torn Page Detection on your database. All very theoretical, and unproven. It would probably be better to just use raw devices, instead, but you will increase your administration costs, if you do that. Enough that you would only want to do this for really mission critical stuff, and you had already proved that it gave a significant boost to performance. And by "significant", I mean enough to offset the increased admin costs.sql

Friday, March 23, 2012

Formatting text in crystal reports

hi,
is it possible to format the size, font, color of the text displayed in the report?just right click on that text and click format text :sql

Monday, March 12, 2012

Formatted Text Data in DB

Can anyone tell me if SQL Server can store formatted text like words in
bold, italic, different font size, etc. ?
Researching and trying to find the answer to anything on microsoft sites is
impossible!
TIA
JeffThis is a multi-part message in MIME format.
--=_NextPart_000_004A_01C368C3.7A69EEA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You could create a Word document and then save it as an image datatype =in a table.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com.sql
.
"Jeff Reed" <thebigvalbosky@.hotmail.com> wrote in message =news:OJwvLROaDHA.2572@.TK2MSFTNGP12.phx.gbl...
Can anyone tell me if SQL Server can store formatted text like words =in
bold, italic, different font size, etc. ?
Researching and trying to find the answer to anything on microsoft =sites is
impossible!
TIA
Jeff
--=_NextPart_000_004A_01C368C3.7A69EEA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT size=3D2>You could create a Word document and then save it as =an image datatype in a table.</FONT></DIV>
<DIV><BR>-- <BR> Tom<BR>---<BR>Thomas A. Moreau, =BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=/">http://www.pinnaclepublishing.com.sql">www.pinnaclepublishing.com=
.sql</A><BR>.<BR></DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeff Reed" <<A =href=3D"mailto:thebigvalbosky@.hotmail.com">thebigvalbosky@.hotmail.com</A>=> wrote in message <A =href=3D"news:OJwvLROaDHA.2572@.TK2MSFTNGP12.phx.gbl">news:OJwvLROaDHA.2572=@.TK2MSFTNGP12.phx.gbl</A>...</DIV>Can anyone tell me if SQL Server can store formatted text like words =in<BR>bold, italic, different font size, etc. ?<BR><BR>Researching and trying to =find the answer to anything on microsoft sites =is<BR>impossible!<BR><BR>TIA<BR><BR>Jeff<BR><BR></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_004A_01C368C3.7A69EEA0--

Thursday, March 29, 2012

Formula for Graph Size

Formula for disk space

Monday, March 26, 2012

Formatting the hard drive

Friday, March 23, 2012

Formatting text in crystal reports

Monday, March 12, 2012

Formatted Text Data in DB

Generate sql

Blog Archive

About Me