T-SQL to Change Fill Factor For All Indexes in a Database

I recently needed to change the fill factor for an entire database.  The database used uniqueidentifiers as primary keys for most of the tables. USE [YourDbName] GO — Show Fragmentation sample on YourTable Index. SELECT avg_fragmentation_in_percent, avg_fragment_size_in_pages, fragment_count, avg_page_space_used_in_percent FROM…

Group Policy Object for Internet Explorer to Turn Off Compatibility View for local Intranet Sites.

I recently needed to disable compatibility view for intranet sites for all domain users and found that using Group Policy was the easiest solution. Group Policy: Policy: Turn on Internet Explorer Standards Mode for local intranet  (Enabled this disables compatibility…

%d bloggers like this: