Tasks Check Database Integrity Shrink Database Reorganize Index Rebuild Index Update Statistics Clean Up History Execute SQL Server Agent Job Back Up Database (Full) Back Up Database (Differential) Back Up Database (Transaction Log) Maintenance Cleanup Task
A synonym is a database object that serves the following purposes: Provides an alternative name for another database object, referred to as the base object, that can exist on a local or remote server. Provides a layer of abstraction that protects a client application from changes made to the name or location of the base... » read more
Note: sp_spaceused is the fastest way to get a list of table size of the database. sp_spaceused Note: This query is the most detailed. It breaks out the Used space to Data Space and Index Space. ReservedSpace = DataSpace + IndexSize + UnusedSpace Total Space Note: Total Space includes both Used Space (Data + Index)... » read more
Restoring database to original from full backup file. Note: After restore completed, need to re-map user permissions to that database. Time 100 GB = 1 hr
Problem: User can not connect to SQL Server from a remote computer via SSMS. Ping returns unreachable. When user remote desktop on to server and use SSMS from the server, the user is able to connect to SQL Server. Note: Make sure SQL Server Instance is running on the server. If multiple instances installed, make... » read more
View SQL Server Logs SSMS -> Server -> Management -> SQL Server Logs Error Logs View the error logs if SQL Server is unable to start. C:\Program Files\Microsoft SQL Server\MSSQLx.MSSQLSERVER\MSSQL\Log Sources: https://docs.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver15
After you have installed SQL Server Reporting Services 2017, you will need to configure SSRS before you can use it. Go to Reporting Services Configuration Manger to configure SSRS. Reporting Services Configuration Manager Configure the Web Service URL tab and hit Apply to create directory in IIS. Configure the Web Portal URL tab and hit... » read more
Installing Note Requires at least Windows Server 2012 or above. Developer edition has all the features of the Enterprise edition. Standard edition do not have certain features. If you want to install Machine Learning Server, you might have to do an offline install. Otherwise do not select the Machine Learning Server feature from both the... » read more
Grant Stored Procedure to Role Grant Function to Role Grant Type to Role Grant Table to Role Grant View to Role
Get Data File Information from Backup File Drop Database Restore Database