SQL Check Index Fragmentation
Thanks to Ola Hallengren, here is a simple scrip to report the fragmentation level of you database’s index One thing to note, if you don’t see any results…
Category
MS SQL
6 articles in this category
SQL Index Maintenance Script
Small simple scrip to automate SQL Index maintenance. Of course, the best scripts to accomplish this is Ola Hallengren’s SQL Server Maintenance Solution, that you can find here…
How to move the SQL tempDB database files
Open SSMS (If you don’t know what is SSMS, you shouldn’t be doing this…) Paste and execute this query, modifying it to your needs USE master GO ALTER…
How to fix orphaned SQL Server users
Make sure to run all listed commands from the database you are fixing, not from Master. List the orphaned users in the database EXEC sp_change_users_login 'Report' To assign/repair…
Disk Partition Alignment Best Practices for SQL Server
Disk partition alignment is very important for SQL to perform as best as possible on the current hardware. Make sure that your partitions are aligned ! Thanks to…
Microsoft SQL Server Firewall Configuration Script
Once you have you Microsoft SQL Server installed, you will need to open some port in the firewall if you intend to access it from another server/computer. Copy…