Skip to main content
user2368632's user avatar
user2368632's user avatar
user2368632's user avatar
user2368632
  • Member for 7 years, 6 months
  • Last seen more than a month ago
6 votes
1 answer
221 views

How do pages get updated checksum when switching page verification mode from torn page to checksum?

6 votes
1 answer
865 views

Windows OS level scheduled disk defragment tasks and SQL data volumes

6 votes
1 answer
291 views

Can a full DBCC CHECKDB operation be safely offloaded to an AG secondary server?

4 votes
1 answer
4k views

What does exchangevent indicate in SQL deadlock graph?

3 votes
1 answer
2k views

Query agent jobs for a given notification operator name

3 votes
1 answer
490 views

How to dispose of large tables with the least impact to log shipping?

3 votes
2 answers
2k views

How to identify the top disk space consuming tables by file?

3 votes
2 answers
428 views

Identify all queries that target a given table?

3 votes
1 answer
1k views

How to convert a query hash to uint64?

2 votes
1 answer
146 views

How to resolve linenumber in deadlock graph XML to line number displayed in SSMS sproc definition?

2 votes
2 answers
2k views

Explode a date range

2 votes
1 answer
3k views

Steps to apply windows updates to sql failover cluster?

2 votes
1 answer
196 views

How to BCP export three related tables in a transaction consistent manner?

2 votes
2 answers
482 views

How to parse XHTML node value with TSQL?

2 votes
1 answer
1k views

How to deal with SQL Server Full Text Log Files?

2 votes
1 answer
391 views

Effect on msdb transaction log of running sp_delete_backuphistory for first time?

1 vote
1 answer
707 views

Any potential cons associated with enabling backup checksums when performing backups?

1 vote
1 answer
83 views

How to track down app name for query in query plan cache?

1 vote
1 answer
460 views

SQL Log Shipping - What is the date time format used by transaction log file name?

1 vote
1 answer
1k views

Find ownership for a given temp table?

1 vote
2 answers
2k views

DBCC CheckDB space requirements?

1 vote
2 answers
955 views

How to fix error recording sp_whoisactive results to table?

1 vote
1 answer
75 views

Will large transaction log file slow db recovery?

1 vote
1 answer
160 views

Do DB permissions flow from primary server to secondary server in SQL log shipping?

1 vote
1 answer
359 views

How to avoid implicit conversion when using XQuery value() method in TSQL?

1 vote
2 answers
131 views

How to size SQL Server VM so that it is comparable to bare metal primary SQL server?

1 vote
1 answer
69 views

How to detect which indexes have checksums and which ones don't?

1 vote
3 answers
550 views

Search plan cache for all query plans using a given index?

1 vote
2 answers
5k views

Where to download bcp command line package for SQL Server 2019?

1 vote
1 answer
383 views

How to filter extended event session by sp execution time (seconds)?