797 reputation
1920
bio website
location
age
visits member for 3 years, 9 months
seen 9 hours ago

Jun
26
revised Reason for using hexadecimal in NCHAR()?
added 2 characters in body
Jan
11
revised With the advent of integrated source control, do stored procedure changes still need comments?
edited tags
Aug
31
revised Commonly Used Acronyms by Database Administrators
Added MDX - Multidimensional Expressions
Aug
24
revised How do you roll up header-level values on a fact table with line-item granularity?
added 141 characters in body
Aug
21
revised Commonly Used Acronyms by Database Administrators
Added DRI - Declarative Referential Integrity
Aug
12
revised Is there a performance benefit to placing transaction log files on a separate drive?
deleted 2 characters in body
Jul
23
revised SQL Server has encountered 1 occurrence(s) of cachestore flush
added 4 characters in body
Jun
29
revised How does SQL Server choose an index key for a foreign key reference?
deleted 36 characters in body
Jun
16
revised How to efficiently check EXISTS on multiple columns?
deleted 8 characters in body
May
31
revised What is the purpose of the database 'owner'?
deleted 1 characters in body
Mar
29
revised How do query notifications detect changes in the query result?
added 7 characters in body
Mar
9
revised Can this method for unit testing a stored procedure be improved?
added 3 characters in body
Feb
17
revised Data warehouse: using day number in Epoch in a date dimension
edited title
Feb
16
revised Data warehouse: using day number in Epoch in a date dimension
added 165 characters in body; edited title
Sep
1
revised Can this method for unit testing a stored procedure be improved?
edited title
Aug
5
revised Should I stop transaction log backups during a full backup?
added 2 characters in body