User RayofCommand - Database Administrators Stack Exchange

RayofCommand

Member for 8 years, 9 months
Last seen more than a week ago

i-dont-have-one.now
Berlin, Germany

20 Questions

Score Activity Newest Views

14 votes

3 answers

6k views

Backup internals - What happens when a backup job is running - in terms of locking and performance overhead in SQL Server?

asked Jun 18, 2015 at 14:38

12 votes

4 answers

48k views

Find all IP's or users who access a specific SQL Server

asked Mar 2, 2016 at 8:24

7 votes

1 answer

2k views

How does SQL Server calculate the initial size of a (compressed) backup?

asked Dec 2, 2015 at 13:06

6 votes

2 answers

22k views

Keeping default max memory 2147483647 MB value in SQL Server, a bad practice?

asked Nov 3, 2014 at 11:48

5 votes

3 answers

10k views

SQL Server 2012 Standard Edition using more than 64GB of memory, why and how?

asked Dec 4, 2014 at 16:16

5 votes

1 answer

13k views

Mirror / replicate only 1 table of a database

asked Feb 13, 2015 at 11:26

5 votes

1 answer

1k views

Why is a max degree of parallelism 1 recommended and used for Sharepoint in SQL Server?

asked Oct 6, 2015 at 14:49

4 votes

3 answers

2k views

Find values which occur in every row for every distinct value in other column of the same table

asked Feb 8, 2017 at 20:21

3 votes

1 answer

252 views

Divide, round and replace in one select statement - tranformation from bytes to GB in SQL Server

asked Aug 31, 2020 at 11:53

3 votes

1 answer

2k views

Domain Admin on AWS lacking user rights to edit the top 200 using the Management Studio interface

asked Jul 23, 2015 at 8:11

3 votes

3 answers

8k views

Understanding Disk Partition Alignment for Windows Server 2012 and SQL Server 2014

asked Oct 8, 2015 at 12:25

2 votes

0 answers

1k views

How can I have long waits on Tracewrite, when I haven't run Profiler?

asked Nov 13, 2015 at 11:23

2 votes

1 answer

470 views

Having Sharepoint on a different Collation than the system Databases?

asked Oct 7, 2015 at 12:11

2 votes

2 answers

774 views

When to prefere a truncate over a batch-delete?

asked Jul 16, 2015 at 10:04

2 votes

2 answers

1k views

migrate db's - best way to mirror or replicate a full database

asked May 20, 2015 at 14:16

1 vote

1 answer

16k views

Understanding pagefile.sys % Usage performance monitor (perfmon) counter correctly

asked Jun 20, 2014 at 11:18

1 vote

1 answer

238 views

SQL Licensing on Azure, Standard D4 Windows 2012 Server 8 core, is it 1 phsysical core?

asked Mar 10, 2015 at 10:48

1 vote

3 answers

2k views

Restore multiple databases quickly - practicing disaster recovery

asked Mar 11, 2016 at 15:40

1 vote

1 answer

236 views

When I have 6 cores and they do a table scan and merge afterwards, does every core scan the whole table?

asked Jan 16, 2017 at 9:48

0 votes

2 answers

110 views

Finding the longest entries for a given column (nvarchar(100))

asked Jul 23, 2015 at 13:55