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…

Luigi D'Angelo
- 1
- 2
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…

user4004132
- 1
- 1
0
votes
3 answers
Reduce if/else statements
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…

Rohit Devlekar
- 13
- 5
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,
…

Armando Pagliara
- 3
- 2