AngryHacker
  • Member for 9 years, 7 months
  • Last seen more than a month ago
3 answers
26 votes
19k views
1 bookmarks
Does the partition key also have to be part of the primary key?
2 answers
24 votes
26k views
9 bookmarks
How badly do SQL Compilations impact the performance of SQL Server?
2 answers
17 votes
999 views
4 bookmarks
Does firing off an indefinite WAITFOR increase the log file size?
1 answers
16 votes
22k views
Is ASYNC_NETWORK_IO wait type anything to worry about?
2 answers
15 votes
75k views
5 bookmarks
Quick look at how much RAM is allocated to SQL Server?
1 answers
11 votes
10k views
6 bookmarks
How to improve Procedure Cache Hit Ratio?
3 answers
7 votes
3k views
2 bookmarks
Performance impact of waiting on a service broker message
1 answers
7 votes
2k views
2 bookmarks
What does it mean to have many rows for a SPID in sp_who2
2 answers
5 votes
1k views
2 bookmarks
What are options for super volatile tables?
1 answers
5 votes
2k views
Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?
2 answers
5 votes
179 views
Mechanics of partitioning
4 answers
4 votes
4k views
SSMS 2016 takes forever to bring up context menu for an index
1 answers
4 votes
5k views
Trouble setting up mirroring on SQL Server 2016
1 answers
4 votes
794 views
Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?
1 answers
4 votes
128 views
What is a good auto-generated key for a federated database?
2 answers
3 votes
118 views
Is it normal to share CPUs on a VM of SQL Server?
2 answers
3 votes
925 views
What is the cheapest way to mirror/replicate data to multiple servers on SQL Server?
1 answers
3 votes
2k views
Why am I getting Table scan on a partitioned table query?
1 answers
2 votes
2k views
1 bookmarks
Is it possible to do an in-place upgrade of SQL Server 2005 Standard to SQL 2012 Enterprise?
1 answers
1 votes
397 views
How does one export/import registered servers with passwords?
1 answers
1 votes
156 views
Enable Toolbox window in SQL Server Management Studio
0 answers
1 votes
723 views
Capturing table changes with CDC and In Memory tables
2 answers
1 votes
132 views
Does RAM taken up Shared Memory connection counts against Max Server Memory?
1 answers
1 votes
125 views
Where does it make sense to store Indexes for partitioned tables?
1 answers
1 votes
221 views
Hard Drive Configuration for my setup
1 answers
0 votes
45 views
1 bookmarks
Is there a way to customize SQL Server Performance Dashboard?
1 answers
0 votes
57 views
Why is the built-in distance function so much slower than my custom one?
0 answers
0 votes
31 views
How to troubleshoot slow connection issues from SSMS?
1 answers
0 votes
66 views
Why are execution plans wildly different when selecting 1000 rows vs 2000?
2 answers
0 votes
2k views
How to move all non-unique and non-clustered indexes to a different filegroup?