SQL-Server

T-SQL-Commands

T-SQL: Shrink incremental

First off you don’t ever shrink a database file unless you known it won’t need the space back again. (There’s some caveats to that statement but it mostly holds true) If that’s the space the file has consumed generally that’s…

Read MoreT-SQL: Shrink incremental
T-SQL-Commands

SQL server: Slow SSMS

If you are using SSMS 17 or 18, you have maybe noticed that the SSMS startup can be very very very very slow, which is annoying for everyone. There are 2 workaround, which could resolve this issue: Open  Internet Explorer: Options…

Read MoreSQL server: Slow SSMS