User 8kb

57 votes

2 answers

73k views

What is the purpose of the database 'owner'?

asked May 31, 2012 at 6:01

25 votes

3 answers

8k views

Should I stop transaction log backups during a full backup?

asked Aug 4, 2011 at 23:35

23 votes

3 answers

6k views

How often to backup the master database?

asked Aug 9, 2011 at 0:30

18 votes

2 answers

6k views

Why is table variable forcing an index scan while temp table uses seek and bookmark lookup?

asked Jul 28, 2015 at 18:03

14 votes

2 answers

12k views

ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?

asked Dec 14, 2012 at 21:39

13 votes

1 answer

3k views

How does SQL Server's optimizer estimate the number of rows in a joined table?

asked Apr 2, 2015 at 16:46

9 votes

2 answers

3k views

How does SQL Server choose an index key for a foreign key reference?

asked Jun 29, 2012 at 0:06

9 votes

3 answers

2k views

Is there a performance benefit to placing transaction log files on a separate drive?

asked Mar 29, 2012 at 20:27

8 votes

4 answers

6k views

How do you roll up header-level values on a fact table with line-item granularity?

asked Aug 24, 2012 at 3:55

7 votes

1 answer

4k views

How do query notifications detect changes in the query result?

asked Mar 9, 2012 at 5:25

5 votes

3 answers

919 views

Can this method for unit testing a stored procedure be improved?

asked Sep 1, 2011 at 4:57

4 votes

4 answers

5k views

Should I convert empty varchar values to NULL?

asked Jul 20, 2011 at 16:56

4 votes

2 answers

829 views

Does adherence to the DRY principle justify dynamic SQL?

asked Jul 20, 2011 at 22:30

4 votes

1 answer

1k views

How to break out of error loop in transactional replication?

asked Aug 1, 2012 at 5:04

3 votes

1 answer

2k views

Does surrogate key assignment for a fact table require that the source data has natural keys?

asked Aug 29, 2012 at 16:45

3 votes

1 answer

3k views

Data archival strategy that handles schema changes?

asked Oct 25, 2012 at 5:31

3 votes

2 answers

164 views

With the advent of integrated source control, do stored procedure changes still need comments?

asked Jan 11, 2013 at 18:04

2 votes

2 answers

4k views

Should numeric identifiers like serial numbers be stored as integers?

asked May 31, 2013 at 22:16

2 votes

0 answers

240 views

How to gracefully handle a source database restore from backup in a data warehouse

asked Jun 21, 2013 at 20:13

2 votes

1 answer

289 views

Where can I find information on shredding xml with .nodes?

asked Aug 31, 2011 at 15:38

2 votes

2 answers

721 views

Data warehouse: using day number in Epoch in a date dimension

asked Feb 16, 2012 at 22:18

2 votes

3 answers

2k views

ETL: extraction strategy for 200 source databases

asked Apr 30, 2012 at 5:15

1 vote

2 answers

971 views

Reason for using hexadecimal in NCHAR()?

asked Jun 26, 2013 at 20:15

Stack Exchange Network

23 Questions

What is the purpose of the database 'owner'?

Should I stop transaction log backups during a full backup?

How often to backup the master database?

Why is table variable forcing an index scan while temp table uses seek and bookmark lookup?

ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?

How does SQL Server's optimizer estimate the number of rows in a joined table?

How does SQL Server choose an index key for a foreign key reference?

Is there a performance benefit to placing transaction log files on a separate drive?

How do you roll up header-level values on a fact table with line-item granularity?

How do query notifications detect changes in the query result?

Can this method for unit testing a stored procedure be improved?

Should I convert empty varchar values to NULL?

Does adherence to the DRY principle justify dynamic SQL?

How to break out of error loop in transactional replication?

Does surrogate key assignment for a fact table require that the source data has natural keys?

Data archival strategy that handles schema changes?

With the advent of integrated source control, do stored procedure changes still need comments?

Should numeric identifiers like serial numbers be stored as integers?

How to gracefully handle a source database restore from backup in a data warehouse

Where can I find information on shredding xml with .nodes?

Data warehouse: using day number in Epoch in a date dimension

ETL: extraction strategy for 200 source databases

Reason for using hexadecimal in NCHAR()?