792 reputation
1920
bio website
location
age
visits member for 3 years, 9 months
seen Dec 13 at 0:54

Jun
26
asked Reason for using hexadecimal in NCHAR()?
Jun
21
asked How to gracefully handle a source database restore from backup in a data warehouse
May
31
asked Should numeric identifiers like serial numbers be stored as integers?
Jan
11
asked With the advent of integrated source control, do stored procedure changes still need comments?
Dec
28
answered SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express edition
Dec
14
asked ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Oct
25
asked Data archival strategy that handles schema changes?
Aug
29
asked Does surrogate key assignment for a fact table require that the source data has natural keys?
Aug
24
asked How do you roll up header-level values on a fact table with line-item granularity?
Aug
2
answered How to break out of error loop in transactional replication?
Aug
1
asked How to break out of error loop in transactional replication?
Jul
23
answered SQL Server has encountered 1 occurrence(s) of cachestore flush
Jul
11
answered Reorganize Indexes T-SQL
Jun
29
asked How does SQL Server choose an index key for a foreign key reference?
Jun
16
answered How to efficiently check EXISTS on multiple columns?
May
31
asked What is the purpose of the database 'owner'?
May
13
answered How to split tables without affecting all stored procedures
Apr
30
asked ETL: extraction strategy for 200 source databases
Mar
29
asked Is there a performance benefit to placing transaction log files on a separate drive?
Mar
9
asked How do query notifications detect changes in the query result?