Inverted text or white text on a black background when printing – Windows 10

This issue is caused by a recent update to the generic printer driver that is installed on your computer. To resolve this issue, please delete the existing printer driver, and reinstall the printer driver using the following steps: 1. Delete the existing printer driver: How to delete the printer driver a. Click  → (All apps) → […]

Use Google Fonts Locally

Retrieve the Google Fonts CSS Go to the Google Fonts website and add your chosen fonts to a collection. Click the Use Button Scroll down the page to the link to the Google Fonts CSS file. Copy this link to a text editor From the text editor, copy the content of the href tag and […]

List all Objects and Indexes per Filegroup / Partition

— List all Objects and Indexes — per Filegroup / Partition and Allocation Type — including the allocated data size SELECT DS.name AS DataSpaceName ,AU.type_desc AS AllocationDesc ,AU.total_pages / 128 AS TotalSizeMB ,AU.used_pages / 128 AS UsedSizeMB ,AU.data_pages / 128 AS DataSizeMB ,SCH.name AS SchemaName ,OBJ.type_desc AS ObjectType ,OBJ.name AS ObjectName ,IDX.type_desc AS IndexType ,IDX.name […]

Move Tables To Filegroup

1. Move all tables, indexes and heaps, from all schemas into the filegroup named SECONDARY: EXEC dbo.sp_MoveTablesToFileGroup @SchemaFilter = ‘%’, — chooses schemas using the LIKE operator @TableFilter = ‘%’, — chooses tables using the LIKE operator @DataFileGroup = ‘SECONDARY’, — The name of the filegroup to move index and in-row data to. @ClusteredIndexes = […]

Gradually Deleting Data in SQL Server

If you have a situation where you have a very large table in SQL Server, where you need to periodically delete tens of millions of rows of data, there are several ways to do it. If you have a maintenance window (or your database is not required to be available 24 x 7 x 365), […]

Rebuild Indexes

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance Rebuilding Indexes using the SSMS Database Maintenance Wizard Rebuild or Reorganize: SQL Server Index Maintenance SQL Server Maintenance Plan Best Practices Index Fragmentation Recommended SQL Server Maintenance Plan

Enable NTFS Write on Mac OS X Mavericks

Easiest way is to use Spotlight just hit Cmd + Space and write Terminal and here we go… The other way is in your Finder Applications > Utilities > Terminal. (Those who use iTerm2, I bet they know how to open it :D) Before we start on, MAKE SURE that your USB stick, external HDD, […]