Worldcrafter's learnt blog

Tech stuff I done learned while in IT.  And probably should remember.

[rick-james-us]

Walmart2

[rick-james-us]

Walmart1

[rick-james-us]

Insert comma into rows of numbers

like let’s say you wanted commas in front of all rows so that you could run a sql statement with a bunch of values separated properly

well you could do this with excel, formula is = value & “,”

OR

you can do this with notepad++ by clicking the "start recording” button, doing the action of adding a comma or whatever to the text, then stop recording, then click the “run a macro multiple times:” button. you could then run the macro to the end of file to insert commas as necessary.

[rick-james-us]

Interesting Walmart find

[rick-james-us]

Can’t say I’m a fan... came from Costco...

[rick-james-us]

find location of exe for .lnk shortcut

Just start the application by double clicking the link/shortcut, then open process explorer to see exactly where it’s running from.

[rick-james-us]

SQL trim leading and trailing spaces

update table set CompanyName = LTRIM(RTRIM(CompanyName))

[rick-james-us]

Sangria small bottle but 1.79

[rick-james-us]

Is sys memory low SQL Server script

Question: How to Know When Memory Constraints are Negatively  Impacting CPU in SQL Server?    Answer: the other day, I was asked this question when someone  wanted to sign up for my Comprehensive Database Performance Health Check. I  indeed thought it was a very much loaded question as I have been never asked  this question before.    Let me just tell you what essentially user is asking that when Memory  Pressure or Memory issue is actually affecting CPU so bad that it is together  negatively affecting the SQL Server Performance.    So before I answer this question, let me ask you back, do you know the answer  to this question? If not, please bookmark this blog post as you are going to  learn something new and you can use this script for your business in the  future.  Now run the following query:   

 SELECT current_workers_count, scheduler_id, cpu_id

              status, is_online, failed_to_create_worker

FROM sys.dm_os_schedulers

WHERE status='visible online'

GO

 Now, look at the results of the above query. If you see the column  failed_to_create_worker as 1, that indicates that when there is a memory  constraint, SQL Server failed to create a new worker thread for that  particular schedule. There you go, you now know exactly when Memory pressure  negatively impacts CPU performance, which eventually leads to poor  performance of your SQL Server.

[rick-james-us]

kill processes in sql mgmt studio

open up activity monitor, then in processes list, right click on a process then kill process.  helps to do this after doing an sp_who2, to find out which processes are blocking other processes. good technique to unlock an application that might not be responding for some reason.

[rick-james-us]

sp_who2

One of the first lines of defense in determining the causes of database slowdowns is to use sp_who2. sp_who2 shows all the sessions that are currently established in the database. These are denoted as SPID‘s, or Server process Id’s. Running sp_who2 is easy, all that is required is to type sp_who2 and execute it, however it’s a good idea to call it with EXEC. or just type sp_who2 and F5.

[rick-james-us]

This is how to tell IE to remember pwds that you type in for sites...

https://support.microsoft.com/en-us/help/17499/windows-internet-explorer-11-remember-passwords-fill-out-web-forms

[rick-james-us]

TortoiseGit showing red exclamation

even if you’re already up to date on the branch you’re working on?

The current workaround is to kill TGitCache.exe with the Windows task manager.

[rick-james-us]

close a file that’s open in windows server

if you can’t delete a file that’s open in windows 2012, then go to 

computer management

shared folders

open files

find the open file, right click, close open file.

tada. that sucka is now free to delete.

[rick-james-us]

Eclipse, java runtime arguments

right click on the Main.java, Run As, Run Configurations...

Then click on the Arguments tab, put args in the Program arguments text box.

Sometimes, eclipse will be stupid and not show the arguments tab.  Just restart Eclipse cuz who knows what the fuck else to do when it disappears...

[rick-james-us]

Java JAX-WS example

How to interact with a web service.  In this case, we were interacting with a WCF web service with a Maven Java project, using JAX-WS as a dependency.

You’ll have to copy and paste the link because tumblr is being dumb about linking.

https://www.mkyong.com/webservices/jax-ws/jax-ws-hello-world-example/

[rick-james-us]

More sightings