Open Package Manager Console from Visual Studio and run the following commands. Reinstall all packages for all projects within the solution: Update-Package -reinstall Reinstall all packages for one project: Update-Package -reinstall -Project ProjectName
Author Archives: pandrei
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 SQL Server database files to a new folder location
ALTER DATABASE my SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE my SET OFFLINE; ALTER DATABASE my MODIFY FILE ( Name = my_Data, Filename = ‘D:DATAmy.MDF’ ); Move the file to the new location. ALTER DATABASE my SET ONLINE; ALTER DATABASE my SET MULTI_USER;
Moving all non-clustered indexes to another filegroup in SQL Server
EXEC MoveIndexToFileGroup @DBName = ”, @SchemaName = ”, @ObjectNameList = ”, @IndexName = ”, @FileGroupName = ”;
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, […]