Worldcrafter's learnt blog

Walmart2

Walmart1

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.

Interesting Walmart find

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

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

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

Sangria small bottle but 1.79

 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.

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.

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.

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

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

tada. that sucka is now free to delete.

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...

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

More sightings