Copyright
Related Posts
- Groundhog Day
January 22, 2022
Groundhog Day… A few years ago, we needed an application. Although there are hundreds of applications available on the internet, and everybody use this kind of application, and there are a lot of free open-source available. Well… We decided to create our version. … after months of development, hours and hours of...
- Indexing Facts
January 19, 2022
Indexing is the fast way to be faster The problem is, though … how do you choose the right indexes? How do you choose the right index keys? It’s very easy to choose the wrong indexes, in this case bad performance. FILLFACTOR and PAD_INDEX FILLFACTOR and PAD_INDEX are only used when the index is being built or rebuilt....
- Disk Runs Out of Space
September 15, 2021
When there is no more space Compress folders to Save Storage Space 1 2Invoke-WmiMethod -Path "Win32_Directory.Name='C:\Test'" -Name compress Command line 1echo Uninstall all previous versions of components 2DISM.exe /online /Cleanup-Image /StartComponentCleanup 3 4echo Remove files needed for uninstallation of service...
- Diagram Guide September 1, 2021
- Find All CLR on SQL Server
August 10, 2021
Find all CLRs on all databases can be hard work, this code help to find these CLRs. Select all CLRs on a database: 1-- Select all CLRs on a database 2SELECT distinct 3 DB_NAME() AS DatabaseName, 4 udf.type AS Type, 5 udf.name AS Name, 6 udf.object_id AS ID, 7 udf.create_date AS CreateDate, 8 udf.modify_date AS...
Comments