1d
comment Sql Server Standard 2014: Reindex job locked by other transactions
The thing is simple, if something is accessing the table that is being rebuilt it may be blocked. That is why people normally schedule index related job on weekends
1d
answered Sql Server Standard 2014: Reindex job locked by other transactions
Dec
9
revised Does enabling LPIM work even if the memory pressure is coming from SQL Server itself
added tag and formatting
Dec
9
comment Does enabling LPIM work even if the memory pressure is coming from SQL Server itself
Can you add output of select @@version in the question. Also add the output of select * from sys.dm_os_process_memory
Nov
29
comment IndexOptimize is successful, but sys.dm_db_index_physical_stats still shows huge fragmentation
Please read What Can Cause Index to be Still Fragmented After Rebuild
Nov
27
revised Can I change Fill Factor option for our database server?
added information
Nov
27
revised Can I change Fill Factor option for our database server?
tag, grammar and spelling
Nov
27
revised Full backup of Simple recovery model - how much log is backed up if there is an open transaction
added 158 characters in body
Nov
27
comment MS SQL Server Copy Database Wizard vs Backup / Restore Script
At any given day I would prefer backup restore as compared to copy database wizard. The latter has so many issues
Nov
27
revised How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED\$HKv2
deleted 6 characters in body; edited tags
Nov
21
reviewed Approve SQL Server 2017 Distributed Availability Groups
Nov
21
revised SQL Server 2017 Distributed Availability Groups
tags and spelling
Nov
20
revised Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database
changed heading
Nov
20
reviewed Edit Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database
Nov
20
revised Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database
added tag and grammar.
Nov
20
comment What does “sample_ms” and “num_of_reads” means in “sys.dm_io_virtual_file_stats”. what is the interval time of stats
The values you are comparing are not of same datatype, the one returned by first query is datetime while other one returns integer, see BOL. You should cast/convert to similar datatype and then compare. Just an observation
Nov
19
comment How does DBCC CHECKDB use tempdb?
All you need to read is Checkdb From Every Angle
Nov
14
comment Sql Server AG assigning wrong listener
I believe you did something wrong, cant say from the screenshots
Nov
14
comment Sql Server AG assigning wrong listener
Ok try connecting with AGName;port_no and see if that works.
Nov
14
comment Sql Server AG assigning wrong listener
Seems strange, are you giving port no while connecting via SSMS ?