762 reputation
1720
bio website
location
age
visits member for 3 years, 7 months
seen Oct 21 at 15:27

Jun
27
accepted Reason for using hexadecimal in NCHAR()?
Jun
21
accepted Should numeric identifiers like serial numbers be stored as integers?
Jun
2
accepted How to break out of error loop in transactional replication?
Jun
2
accepted Data archival strategy that handles schema changes?
Jan
12
accepted With the advent of integrated source control, do stored procedure changes still need comments?
Dec
14
accepted ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Aug
29
accepted Does surrogate key assignment for a fact table require that the source data has natural keys?
Jun
29
accepted How does SQL Server choose an index key for a foreign key reference?
May
31
accepted What is the purpose of the database 'owner'?
May
2
accepted ETL: extraction strategy for 200 source databases
Apr
2
accepted Is there a performance benefit to placing transaction log files on a separate drive?
Mar
29
accepted How do query notifications detect changes in the query result?
Feb
20
accepted Data warehouse: using day number in Epoch in a date dimension
Sep
8
accepted Can this method for unit testing a stored procedure be improved?
Aug
31
accepted Where can I find information on shredding xml with .nodes?
Aug
10
accepted How often to backup the master database?
Aug
5
accepted Should I stop transaction log backups during a full backup?
Jul
21
accepted Does adherence to the DRY principle justify dynamic SQL?
Jul
21
accepted Should I convert empty varchar values to NULL?