New answers tagged

0

I've tried all suggestions with no result until now:- Try setting the RAM manually in MS SQL Server Management Studio -> Right Click the SQL Server in Object Explorer -> Properties -> Memory. I set my min memory to 1000 MB and the max to 2000 MB and saw an immediate improvement. (The max by default was set to something silly like 2147483647 MB. Isn'...


3

in my ad-hoc SSMS query window, does it matter? In this context no, it doesn't matter. But not using SELECT * is a good habit to get into anyway, to reduce the temptation to lazily copy such queries into code destined for production. For the avoidance of doubt: while it is perfectly acceptable for quick inspection/diagnostics via SSMS or similar tools, for ...


1

Well, other than the fact that the top query will return 1000 rows while the bottom will return only 1 (I assume that's not your question), no, I wouldn't expect to see a performance or query plan difference between the two in most normal circumstances, especially for ad-hoc SSMS queries like you describe. The clear exception is when you don't actually need ...


-1

In my case, I accidentally connected to the WRONG server, obviously I couldn't find the backup file there.... :facepalm: In my defense, the 2 server hostnames differ only by a single letter, it's a mistake that's bound to happen. Reminder to self, connect using "." or "localhost" instead of full server hostname, since you're are already ...


0

Apparently there is a native procedure to fix this, upwards from SQL Server 2017. I found the below code from a site I no longer remember, which fixed the issue for me, at least for now: USE db_name IF EXISTS (SELECT * FROM sys.database_query_store_options WHERE actual_state=3) BEGIN BEGIN TRY ALTER DATABASE [db_name] SET QUERY_STORE = OFF EXEC dbo....


0

Not seeing the SQL Server Agent icon in SSMS' Object Explorer tree on a non-express edition SQL server where you are not a member of sysadmin, but are a member of at least one of the SQL Server Agent Fixed Database Roles can also be because you login using a windows login that is allowed in through a windows group only: no entry exists in master.sys....


4

Unfortunately not. This information comes from the sys.dm_os_ring_buffers DMV, where it uses the RING_BUFFER_SCHEDULER_MONITOR record type. This information is produced every minute, and that is not customizable. I.e., it isn't the reports "fault", it is the information that is lacking in the first place. Below is the query that this report is ...


Top 50 recent answers are included