AngryHacker's user avatar
AngryHacker's user avatar
AngryHacker's user avatar
AngryHacker
  • Member for 11 years, 8 months
  • Last seen more than a month ago
  • United States
27 votes
3 answers
25k views

Does the partition key also have to be part of the primary key?

25 votes
2 answers
27k views

How badly do SQL Compilations impact the performance of SQL Server?

17 votes
2 answers
83k views

Quick look at how much RAM is allocated to SQL Server?

17 votes
2 answers
1k views

Does firing off an indefinite WAITFOR increase the log file size?

16 votes
1 answer
23k views

Is ASYNC_NETWORK_IO wait type anything to worry about?

11 votes
1 answer
10k views

How to improve Procedure Cache Hit Ratio?

7 votes
3 answers
4k views

Performance impact of waiting on a service broker message

7 votes
1 answer
3k views

What does it mean to have many rows for a SPID in sp_who2

5 votes
4 answers
5k views

SSMS 2016 takes forever to bring up context menu for an index

5 votes
2 answers
183 views

Mechanics of partitioning

5 votes
2 answers
1k views

What are options for super volatile tables?

5 votes
1 answer
2k views

Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?

4 votes
1 answer
871 views

Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?

4 votes
1 answer
5k views

Trouble setting up mirroring on SQL Server 2016

4 votes
1 answer
137 views

What is a good auto-generated key for a federated database?

3 votes
1 answer
2k views

Why am I getting Table scan on a partitioned table query?

3 votes
2 answers
1k views

What is the cheapest way to mirror/replicate data to multiple servers on SQL Server?

3 votes
2 answers
137 views

Is it normal to share CPUs on a VM of SQL Server?

2 votes
1 answer
2k views

Is it possible to do an in-place upgrade of SQL Server 2005 Standard to SQL 2012 Enterprise?

1 vote
1 answer
225 views

Hard Drive Configuration for my setup

1 vote
1 answer
136 views

Where does it make sense to store Indexes for partitioned tables?

1 vote
2 answers
148 views

Does RAM taken up Shared Memory connection counts against Max Server Memory?

1 vote
1 answer
1k views

Enable Toolbox window in SQL Server Management Studio

1 vote
0 answers
852 views

Capturing table changes with CDC and In Memory tables

1 vote
1 answer
734 views

How does one export/import registered servers with passwords?

0 votes
1 answer
198 views

Why are execution plans wildly different when selecting 1000 rows vs 2000?

0 votes
1 answer
154 views

Is there a way to customize SQL Server Performance Dashboard?

0 votes
0 answers
32 views

How to troubleshoot slow connection issues from SSMS? [duplicate]

0 votes
1 answer
93 views

Why is the built-in distance function so much slower than my custom one?

0 votes
2 answers
2k views

How to move all non-unique and non-clustered indexes to a different filegroup?