RayofCommand
  • Member for 7 years, 7 months
  • Last seen more than a week ago
3 answers
14 votes
5k views
1 bookmarks
Backup internals - What happens when a backup job is running - in terms of locking and performance overhead in SQL Server?
4 answers
11 votes
43k views
4 bookmarks
Find all IP's or users who access a specific SQL Server
1 answers
7 votes
1k views
1 bookmarks
How does SQL Server calculate the initial size of a (compressed) backup?
2 answers
6 votes
21k views
Keeping default max memory 2147483647 MB value in SQL Server, a bad practice?
3 answers
5 votes
9k views
SQL Server 2012 Standard Edition using more than 64GB of memory, why and how?
1 answers
5 votes
12k views
Mirror / replicate only 1 table of a database
1 answers
5 votes
1k views
Why is a max degree of parallelism 1 recommended and used for Sharepoint in SQL Server?
3 answers
4 votes
1k views
Find values which occur in every row for every distinct value in other column of the same table
1 answers
3 votes
250 views
Divide, round and replace in one select statement - tranformation from bytes to GB in SQL Server
1 answers
3 votes
1k views
Domain Admin on AWS lacking user rights to edit the top 200 using the Management Studio interface
3 answers
3 votes
8k views
1 bookmarks
Understanding Disk Partition Alignment for Windows Server 2012 and SQL Server 2014
0 answers
2 votes
1k views
How can I have long waits on Tracewrite, when I haven't run Profiler?
1 answers
2 votes
446 views
Having Sharepoint on a different Collation than the system Databases?
2 answers
2 votes
604 views
When to prefere a truncate over a batch-delete?
2 answers
2 votes
1k views
2 bookmarks
migrate db's - best way to mirror or replicate a full database
1 answers
1 votes
16k views
Understanding pagefile.sys % Usage performance monitor (perfmon) counter correctly
1 answers
1 votes
238 views
SQL Licensing on Azure, Standard D4 Windows 2012 Server 8 core, is it 1 phsysical core?
3 answers
1 votes
2k views
Restore multiple databases quickly - practicing disaster recovery
1 answers
1 votes
204 views
When I have 6 cores and they do a table scan and merge afterwards, does every core scan the whole table?
2 answers
0 votes
85 views
Finding the longest entries for a given column (nvarchar(100))