Found this on a search engine site – handy – full article here: https://www.searchenginejournal.com/google-search-operators-commands/215331/ Advanced Google Search Operators Cache Using the cache operator, you can find out what the most recent cache of a specified webpage is. This is useful for identifying when a page was last crawled. Example use: cache:websitename.com Allintext This operator will…
20180824-00:00:00:000 — SELECT CONVERT(VARCHAR,@date,112) + ‘-‘ + CONVERT(VARCHAR,@date,114) 20180824-203947843 — SELECT CONVERT(VARCHAR,@date,112) + ‘-‘ + REPLACE(CONVERT(VARCHAR,@date,114),’:’,”) 08/24/2018 101 SELECT CONVERT(VARCHAR,@date,101) 2018.08.24 102 SELECT CONVERT(VARCHAR,@date,102) 24/08/2018 103 SELECT CONVERT(VARCHAR,@date,103) 24.08.2018 104 SELECT CONVERT(VARCHAR,@date,104) 24-08-2018 105 SELECT CONVERT(VARCHAR,@date,105) 24 Aug 2018 106 SELECT CONVERT(VARCHAR,@date,106) Aug 24, 2018 107 SELECT CONVERT(VARCHAR,@date,107) 10:00:00 108 SELECT CONVERT(VARCHAR,@date,108) Aug 24 2018…
Part_Master Key Value not Found – CLR was disabled If you run into an error like this when you’ve just installed SQL Server and MAX is could be the CLR was not enabled. Verify CLR is enable by running the following server Configuration script. sp_configure @configname=clr_enabled, @configvalue=1 GO RECONFIGURE GO
Symbol What it is How it is read How it is used Sample expression + Addition sign … plus … Sum of a few values 3 + 5 = 8 Logical OR symbol … or … Logical disjunction ¬(A + B) = ¬A * ¬B * Multiplication sign … times … Product of two values…
Subject: Set Compatibility Level on All DBs /* Update All DBs Compatibility Level */ /* Reference 2017 = 140 Azure SQL Database = 130 2016 = 130 2014 = 120 2012 = 110 2008R2 = 100 2008 = 100 2005 = 90 2000 = 80 */ DECLARE @SQL VARCHAR(max) = ”, @CL int =
Subject: Server Rename SQL Instance Rename –For Default Instance sp_dropserver <old_name>; GO sp_addserver <new_name>, local; GO –Restart the instance of SQL Server. –/*For a renamed computer that hosts a named instance of SQL Server, run the following procedures:*/ sp_dropserver <old_name\instancename>; GO sp_addserver <new_name\instancename>, local; GO –Restart the instance of SQL Server
Subject: MAX PDF Documents have References in the Registry and in the ExaxctRMNET.ini Registry: [HKEY_CURRENT_USER\Software\ExactRM] ExactRMNet.ini is the windows folder
Subject: Move ODBC from one workstation to another Transfer DSN files from Computer A to Computer B: 1. On Computer A, open the Registry Editor by typing "regedit" in the Windows search box under the Start menu and selecting regedit.exe 2. Navigate to the following registry key : · For User DSN data sources: HKEY_CURRENT_USER…
Subject: SSRS and Chrome Links and Fixes Chrome Chrome Extension for SSRS >> Solves Rendering Problems https://chrome.google.com/webstore/category/extensions?hl=en-US Solves CSS Issues https://chrome.google.com/webstore/detail/sql-reporting-viewer-fix/ealmmhekjbgnbfllfpbpplccpeoplidp?hl=en
Subject: Knowledge Sync Apps will not run Likely it is these 2 files causing troubles. STOP THE KNOWLEDGESYNC WINDOWS SERVICE Move MSCOMCTL.OCX and COMDLG32.OCXC:\WINDOWS\syswow64 regsvr32 C:\WINDOWS\syswow64\ MSCOMCTL.OCX 6/6/2012 regsvr32 C:\WINDOWS\syswow64\ COMDLG32.OCX 5/7/1999 START THE KNOWLEDGSYNC WINDOWS SERVICE.