Create a Drive Letter from a Local Folder 10/27/2021 Programming thevictorchen 8,185 Views It's sometimes convenient to have a drive letter to mimic the development and production servers on my local machine on Windows.subst [Drive] [Path]And an example of mapping a D: drive from a folder c... Finish Reading
Preserve Created Date when Copying Files in Windows 10 11/19/2018 Programming thevictorchen 16,401 Views When processing files, you may come across a time when you need to make a copy of a file, but preserve the Created Date. By default when you copy a file, the Modified Date is preserved, but the Create... Finish Reading
Must Have SSMS Queries 5/8/2018 Programming thevictorchen 11,846 Views Text Search for a Column NameIt may be slower because it does a free text searches in functions, stored procedures, comments, views, triggers. It may find more results than you were expecting (i.e. if... Finish Reading
SSMS vs .NET Application: Very Different Execution Times 4/23/2018 Programming thevictorchen 12,263 Views When it comes to simple SQL queries, I never notice any performance difference in execution time when comparing stored procedures executed in SQL Server Management Studio (SSMS) and the actual .NET C#... Finish Reading