Questions tagged [shrink]

249 questions
0
votes
1 answer

sql server shrink a >5 varchar string to fit a varchar(4)

I'm a total newbye to SQL functions, this is my first question after searching a lot about this topic. I'm trying to select a list of values which are varchar (8) and transform them into varchar (4) To do this i would need to truncate the value at…
0
votes
2 answers

Threshold for BayesShrink

I used a Function to calculate Threshold for BayesShrink. Normally the result of the Threshold gives me one value.when I use an image with size 128*128, the code work, but my image has a size of 380*992. the result gives me a Matrix oh threshold…
hajer
  • 11
  • 6
0
votes
0 answers

jqGrid's shrinkToFit causes horizontal scrollbar to appear

I've started using jqGrid recently and encountered a problem which causes horizontal scrollbar when setting shrinkToFit option to true. Do you have any ideas how to get rid of it, as I don't need it in my table yet Here's the JS piece of…
Oscar
  • 805
  • 2
  • 10
  • 24
0
votes
1 answer

SQL Server scheduled stored procedure was working, but now runs very slowly

We have a stored procedure being called by a daily job schedule that used to work within a reasonable time frame but is now performing very badly and failing. Whatever the cause, it seems to also be bogging down our whole system. We tried rebooting…
ptownbro
  • 1,240
  • 3
  • 26
  • 44
0
votes
1 answer

ToolBar with EditText and Floating Button

I Have added edit text to ToolBar. Now i Want to Shrink EditText to a limit when scrolled. Floating Button Should always be visible. When Not Scrolled When Scrolled Below are the file contents Main XML…
0
votes
1 answer

reduce matrix by sum of elements in Matlab

I'm sure this is basic, but I can't come up to an easy way to reduce a matrix of population count by grid cell by adding up all the elements of the "small" cells which would fit in the new ones. My matrix is 720x360 and would like to change it to…
0
votes
3 answers

Reduce if/else statements

I've written a very simple if statement to check the url. It works perfectly fine, but is there any way to trim it down?
0
votes
1 answer

How to align UILabel text to the vertical centre of box

After using Auto shrink the text aligns itself to the top of the text box ____________ | AutoSized | | | | | ____________ I need the text to align to the very centre like this ____________ | | | AutoSized | | …
Jackster
  • 41
  • 7
0
votes
1 answer

Shrinking database in SQL Server

I have shrink the large database. I have shrink the database log using SSMS and by query both way. on the properties it is showing the reduced size. But on the drive where it is mounted showing the previous size. What can I do to release the space…
0
votes
1 answer

Is there any harm if i shrink my WSS logging database inside my Dev machine

I know my question is about SharePoint, but it is a pure database question. I am working on my SharePoint 2013 Dev machine, and i am running out of space, now i checked the WSS_Logging database inside my SharePoint database, and i find that it have…
John John
  • 1
  • 72
  • 238
  • 501
0
votes
1 answer

Is it possible to shrink a log file on a linked server using DBCC SHRINKFILE?

I am doing a large archival of data from one DB to another DB on a linked server. I am copying from MS sql server 2000 to MS sql server 2005. This involves copying millions of records and then deleting them. This all happens via a dynamic script.…
Grik
  • 3
  • 5
0
votes
1 answer

How do I shrink my database?

I have a 800 GB size database, and the storage is out of space. I have only 3,2 GB free space. I have tried right click on database ->tasks -> shrink->file but nothing happened. It runs for 2 seconds. i have tried with this, but at 99% the status…
MySQL
  • 11
  • 1
0
votes
0 answers

Sharepoint 2013 and Sql Express reached Full

I've a standalone farm configured with SharePoint 2013 Foundation and sql server 2012 express. I reached out on my content db limit(10gb) and I can no longer perform CRUD on the elements of sharepoint . I would simply remove two large document…
RiVA
  • 1
  • 2
0
votes
1 answer

JTextFields and JTextArea shrinking when inputting large quantity of text into JTextArea

I have a JTabbedPane in a JDialog box that uses GridBagLayout on all the JPanels contained within the pane. On the first panel displayed there is a JTextArea (descTxt) that is ready to input a film description in. When you input a large amount of…
blueprintchris
  • 1,053
  • 1
  • 16
  • 38
0
votes
1 answer

Oracle tablespace resizing with consecutive free blocks

I often reduce tablespace in our Oracle instance (11g). Using the following script (from system user) I can know exactly the allocated space for each object in choosen tablespace (e.g. MY_TABLESPACE): select tablespace_name, file_id, block_id, …