Information
Showing posts with label
Microsoft SQL Server Management Studio
.
Show all posts
Showing posts with label
Microsoft SQL Server Management Studio
.
Show all posts
Friday, December 3, 2021
SQL Server - Query for Possible bad Indexes
›
--Possible bad Indexes (writes > reads) SELECT OBJECT_NAME(s.object_id) AS 'Table Name',sca.name , i.name AS 'Index Name...
Monday, November 22, 2021
SQL Server - Drop indexes and stats
›
Query to get the 'drop query for Stats' SELECT distinct 'DROP STATISTICS ' + sca.name + '.' + t.name + '....
SQL Server - Deleting the contents from log file
›
You can shrink the log with the following Statements: USE [MyDatabase] GO ALTER DATABASE [MyDatabase] SET RECOVERY SIMPLE WITH NO_WAIT ...
Friday, July 5, 2019
Sql-Server the Select permission was denied on the object 'types', Error 229
›
Please check that you didn't check the following DB role: 1. db_denydatareader 2. db_denydatawriter Please uncheck both of them...
Thursday, March 14, 2019
Ms Sql Server - The Visual Studio Component is out of date. Please restart Visual Studio. (Mscorlib)
›
SSMS Error: "The Visual Studio Component is out of date. Please restart Visual Studio. (Mscorlib)" When you are trying to open ...
›
Home
View web version
