|
INURED - toughened
anag of RUINED
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
YAUT 
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Insert section break should be on the 'Insert' ribbon. Grrrrr......
Idiots!
|
|
|
|
|
sorry testing CP
Charlie Gilley
"Fill your hand you son of a bit...."
|
|
|
|
|
Ribbon? What's that? 
Insert | Break... it's right there on the Standard toolbar where it's always been. I've been using it all day.
|
|
|
|
|
I think I still have those old disks.... You have a good point.
|
|
|
|
|
Trouble with that is when you get sent "modern" word documents and can't read them ... 
Bring back Ami Pro, that's what I say! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I've never "up"graded from Office 2003 ... installed the docX and xlsX import/export filters, all good.
|
|
|
|
|
|
|
RickZeeland wrote: I am very happy using the free TextMaker from SoftMaker
I suppose I could try it and see, but if you have a lot of experience with it does it do index marks, and create indexes as easily as Word? I did all the formatting for a book in Word, and it worked well. Tried it in Libre and other offices, and always started swearing when I found out how difficult it was to edit index entries. Indexing a book with thousands of index marks is a real chore if they can't be edited easily.
|
|
|
|
|
|
That video doesn't address the editing stage of the indexing process. The following video only briefly touches on the editing capabilities of Word at the timestamp I've linked it to: Building An Index In Word: How The Experts Do It - YouTube. When the entries are visible like they are at that stage you can use Word's find and replace on the entries themselves to adjust them. For instance, if your document used the words 'thunder' and 'thunderbolt', and you realized it after creating the entries for them, you could find the 'thunder' in the entries by searching for "thunder" (with quotes) to step to each one, and replace them with "thunder/bolt". Repeat the process for 'thunderbolt' and recreate the index! Easy! But not in any of the freebies I've seen. Unless TextMaker has it, but it isn't in a video.
|
|
|
|
|
David O'Neil wrote: Tried it in Libre and other offices, and always started swearing when I found out how difficult it was to edit index entries.
For general needs (simple documents, basic formatting, TOC), most office tools work just fine, even GoogleDocs. But if the need is more complex, the only one with which I've had success that didn't have me pulling what's left of my hair out is Word.
A couple of years ago I was required to use LibreOffice, but the formatting was taking me 10 times what Word did. So I wrote the document in Word, then did a 1-time conversion to Libre. It was the only way I could complete the job on time and within budget.
|
|
|
|
|
BryanFazekas wrote: But if the need is more complex, the only one with which I've had success that didn't have me pulling what's left of my hair out is Word.
That has been my conclusion as well. Long ago everyone was bragging about how excellent Serif PagePlus was for the price for a layout program. Word was far easier, especially editing index entries. I do hate how fiddly inserting graphics can be, but once you've 'got it,' it works.
|
|
|
|
|
I installed MS SQL server developer 2019 edition last year. but now I find it occupied almost 300G on my C drive.
the total size of my C drive is 500G, so I have to uninstall this SQL server 2019 instance to get enough space to install new Windows patches.
what's wrong with my SQL sever developer 2019 installation?
diligent hands rule....
|
|
|
|
|
Check the database sizes. One or more of them may have grown. Maybe time to shrink some log files.
|
|
|
|
|
I used a free tool to check the file size and find the SQL log file folder is with the biggest size:
5.| PATH: Program Files\Microsoft SQL Server\MSSQL15.Peaker\MSSQL\Log | SIZE: 346.30 Gb | DEPTH: 5
how to shrink these log folder size?
diligent hands rule....
|
|
|
|
|
Checking table sizes in a database:
DECLARE @str VARCHAR(500) SET @str = 'exec sp_spaceused ''?''' EXEC sp_msforeachtable @command1=@str
Shrinking the database and logs:
ALTER DATABASE [database name] SET RECOVERY SIMPLE WITH NO_WAIT;
DBCC SHRINKFILE('database name', 1);
ALTER DATABASE [database name] SET RECOVERY FULL WITH NO_WAIT;
|
|
|
|
|
thank you for your tips! I learned new things from you.
I think I find the reason: my PolyBase feature is not installed correctly, so it caused SQL server keep dumping big files.
Now I fixed this problem.
diligent hands rule....
|
|
|
|
|
As Jacquers said, it's probably your database files. Specifically, if you have the "recovery model" set to "full", and you're not taking regular backups of the transaction logs, they will just keep growing.
You can check the log_reuse_wait_desc column in the sys.databases management view to check for other reasons why the transaction logs might not be shrinking.
SELECT name, recovery_model_desc, log_reuse_wait_desc FROM sys.databases ORDER BY name;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I run this query and here is my result:
Name recovery_model_desc log_reuse_desc
AdventureWorks SIMPLE NOTHING
master SIMPLE NOTHING
model FULL NOTHING
msdb SIMPLE NOTHING
tempdb SIMPLE NOTHING
Do I have any issue with these tables?
diligent hands rule....
|
|
|
|
|
"If you're still lying with your payment, we recommend that you contact your credit card issuer."
"Lying"? Me? Noooo... 
|
|
|
|
|
Well, what can I say? Amazon seems to know their customers VERY well... 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
Never argue with a fool. Onlookers may not be able to tell the difference.
Mark Twain
|
|
|
|
|
Well, I couldn't be bothered to stand up
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
