Things to remember when deleting a large number of records from a database table. Consider using TRUNCATE instead of DELETE if truncating the table (removing all records from the table) is ok. Remove records in batches. Make sure there is enough space for the log files. If database is simple, truncate log after every run.... » read more
Create a macro and open the following application… C:\Windows\explorer.exe and set the parameter to the folder location C:\\folder01 Sources:
For Existing Table For New Table Definition
Using GOTO instead sql query statement.
Simple restore database to same server on same disk configuration.
Key Action F5 Execute Ctrl + F Find Ctrl + H Find and Replace Ctrl + F4 Close Query Crtl + K + C Comment Crtl + K + U Uncomment Crtl + Shift + V Cycle Through Clipboard
Key Action F11 Full Screen F12 Console Ctrl + F5 Clear Cache and Reload Page Ctrl + Shift + T Reopen Last Closed Tab Ctrl + Shift + Delete Clear Browsing Data Ctrl and + Zoom In Ctrl and – Zoom Out Ctrl + D Bookmark Current Page Sources: https://www.google.com/chrome/tips/
Key Action F5 Build Crtl + K + C Comment Line Crtl + K + U Uncomment Line Crtl + M + O Collapse All Crtl + Scroll Up Zoom In Ctrl + Scroll Down Zoom Out Printable Sheet Click to get our printable keyboard shortcut cheatsheet for Visual Studio Sources: https://docs.microsoft.com/en-us/visualstudio/ide/default-keyboard-shortcuts-in-visual-studio?view=vs-2019
Open up the new SQL Server installation -> Maintenance -> Edition Upgrade SQL Server 2019 Standard Edition -> SQL Server 2019 Developer Edition Not supported. Have to uninstall SQL Server 2019 Standard Edition and then reinstall SQL Server Developer Edition. Rule “SQL Server 2019 edition upgrade” failed. The selected SQL Server instance does not meet... » read more
There are many limitations to Always On for Standard Edition, and they are all documented here. Basically, you get to use a single availability database with a single secondary replica, with no read access on the secondary replica. Issue: Unable to setup readable secondary databases on SQL Server 2019 Standard Edition Fix: Upgrade from Standard... » read more