Runakay

When I helped someone to sell her laptop on internet I needed first to look at what applications were installed in this Windows 7. But, having this list in a file was not an easy task, therefore I searched on internet to get a way to do this. Finally, I used at that moment the command line " wmic " which also allows you to export this list in few formats, always remember first to open your command line window and type the command as shown in the image.     As you can see it's very simple just don't forget to specify the destination path and the format you want your output file (the options are: HTML , Table, XML and more). Once you got your file open it and you will see something like this. If you want to have this file in a more comfortable scheme just do what is said here and it will look like this.   Ready to be used.

Some time ago I saw one problem as a consequence of a project, this consisted on moving all directories from one network device to an external drive as a backup policy. But, during the copying process happened problems with certain directories and files, an unknown error actually. However, I got the impression that this problem could be produced by the large length of the paths of this directories or files and yes, that was the reason. As a proof of this, I created a large path for a directory that just contains one text file, as you can see "D:\Large Named Directory" has a lot of similar inner directories, having the last one the "Large Named Textfile.txt" file. Pay attention, because it's not possible to create more directories inside the last one, because Windows has a limit... like everything in life.     Now, the image showed before represents the directories in the network drive, and we are going to copy them to a new directory located in the...

Finally I'm posting again, the time has been very tough with me... but I'm here again with one subject that I was thinking to post long time ago. This is something that I found really curious when I was helping someone, this person asked me why in certain part of an stored procedure the programmer used the text() function to improve its execution time. Actually, I didn't have idea at that moment why that function gave that kind of benefit, I mean, we had this: CREATE PROCEDURE [dbo] . [SP_Test] @xml xml AS Insert    Into dbo . temp_table Select    Id1 =           D . Item . value ( 'Id1[1]' , 'bigint' ),          Id2 =           D . Item . value ( 'Id2[1]' , 'int' ),          Text1 =         D . Item . value ( 'Text1[1]' , 'varchar(...