d-_-b's user avatar
d-_-b's user avatar
d-_-b's user avatar
d-_-b
  • Member for 7 years, 5 months
  • Last seen more than a month ago
14 votes
2 answers
11k views

SQL Server tempdb on RAM Disk?

6 votes
2 answers
1k views

SQL Prove memory pressure - high Buffer Cache Hit Ratio, but low Page Life Expectancy

5 votes
2 answers
1k views

'Row Chaining/Overflow' in SQL Server when adding column to table?

4 votes
1 answer
2k views

Deadlock during Delete on Clustered Index

3 votes
2 answers
3k views

log_reuse_wait_desc says ACTIVE TRANSACTION but DBCC OPENTRAN reports nothing

3 votes
1 answer
3k views

SQL Parallel Stored Procedure execution using CLR - Performance

3 votes
2 answers
626 views

SQL Backup/Restore and Disaster Recovery solutions with VMware

3 votes
1 answer
812 views

sql server deadlock error - Shared (S) and Intent-Exclusive (IX) locks under Serializable isolation

2 votes
0 answers
485 views

SQL Reporting Services (SSRS) - Blocked process on ReportServer, SP CheckSessionLock [duplicate]

2 votes
1 answer
642 views

Ideal MAXDOP & CPUs - how to trace for parallel queries?

2 votes
2 answers
2k views

Reclaim disk space from large database's primary filegroup after truncating tables (other than shrink)

2 votes
1 answer
1k views

SQL Deadlock graph - Find exact statement holding the lock and the time it started [closed]

2 votes
1 answer
182 views

SQL 2008/R2 Extended Events - Row Count [closed]

1 vote
0 answers
731 views

SQL TempDB PCI-E NVMe card - 4K or 64K

1 vote
2 answers
1k views

SQL Server Virtualization best practices - NUMA, HT, Cores vs Speed

1 vote
1 answer
1k views

sql org chart hierarchical table to xml json

0 votes
1 answer
70 views

SQL Performance - One counter to rule them all - identify CPU/MEM/DISK/NET pressure [closed]

0 votes
0 answers
65 views

Index usage stats

0 votes
0 answers
187 views

SQL InMemory Natively Compiled SP - unsupported constructs

0 votes
2 answers
3k views

Turn off ANSI_WARNINGS for heterogenous queries

0 votes
1 answer
84 views

SQL Server - Find Memory ALLOCATED vs. Memory ACTUALLY USED

-3 votes
1 answer
52 views

Sum and Running Sum, Distinct and Running Distinct