Information

  You can create a folder using the Command Prompt with: Step 1: Press Window + R to open "Run" Command Step 2: Type cmd in the run window to open command prompt Step 3: in the Command prompt, Go To Directory in which you wants to create folder, using Cd.. Command Step 3: Use the Command   mkdir .well-known

 --Possible bad Indexes (writes > reads) SELECT  OBJECT_NAME(s.object_id) AS 'Table Name',sca.name  , i.name AS 'Index Name', 'DROP INDEX ' + i.name + ' ON ' + sca.name + '.' + OBJECT_NAME(s.object_id)  ,         i.index_id, user_updates AS 'Total Writes',         user_seeks + user_scans + user_lookups AS 'Total Reads',         user_updates - ( user_seeks + user_scans + user_lookups ) AS 'Difference' FROM    sys.dm_db_index_usage_stats AS s WITH ( NOLOCK )         INNER JOIN sys.indexes AS i WITH ( NOLOCK ) ON s.object_id = i.object_id                                                        AND i.index_id = s.index_id INNER JOIN sys.tables AS t ON s.object_id = t.object_id INNER JOIN sys.schemas As sca on t.schema_id = sca.schema_...

  Query to get the 'drop query for Stats' SELECT distinct 'DROP STATISTICS ' + sca.name + '.' + t.name + '.' + s.name FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id INNER JOIN sys.columns AS c ON sc.object_id = c.object_id AND c.column_id = sc.column_id INNER JOIN sys.tables AS t ON s.object_id = t.object_id INNER JOIN sys.schemas As sca on t.schema_id = sca.schema_id where s.name like '_dta_stat_%' Query to get the 'drop query for Index' SELECT distinct 'DROP INDEX ' + s.name + ' ON ' + sca.name + '.' + t.name FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id INNER JOIN sys.columns AS c ON sc.object_id = c.object_id AND c.column_id = sc.column_id INNER JOIN sys.tables AS t ON s.object_id = t.object_id INNER JOIN sys.schemas As sca on...

  You can shrink the log with the following Statements: USE [MyDatabase] GO ALTER DATABASE [MyDatabase] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([MyDatabase_log], 1 ) ALTER DATABASE [MyDatabase] SET RECOVERY FULL WITH NO_WAIT GO This snippet can be found on various sites in the net, but be aware that it's not a good practice to kill the log like this because of recovery. After doing this, you can only recover your database to the last full or full+incremental backup.

From your Shopify admin, go to Online Store > Themes.   Find the theme that you want to edit, and then click Actions > Edit languages .  In the Filter translations box, type "powered" .  In the Powered by Shopify box , use the space bar on your keyboard to type a single space. You can repeat these steps for the Powered by Shopify HTML box, which appears on your store's " Opening soon " page if your store is password-protected.  Click Save .

 Implement Caching to Static files in the asp.net core When you create a new ASP.NET Core project from the default template, you will find the StaticFileMiddleware is added early in the middleware pipeline, with a call to AddStaticFiles() in Startup.Configure(): Please replace the app.UseStaticFiles() from the below code: public void Configure ( IApplicationBuilder app ) { // logging and exception handler removed for clarity app . UseStaticFiles ( ) ; app . UseMvc ( routes = > { routes . MapRoute ( name : "default" , template : "{controller=Home}/{action=Index}/{id?}" ) ; } ) ; } to using Microsoft . Net . Http . Headers ; app . UseStaticFiles ( new StaticFileOptions { OnPrepareResponse = ctx = > { const int durationInSeconds = 60 * 60 * 24 * 14 ; ctx . Context . Response . Headers [ HeaderNames . CacheControl ] = "public,max-age=...