Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 3
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Apr
29
accepted INFORMATION_SCHEMA Pattern
Apr
22
comment INFORMATION_SCHEMA Pattern
That is the type of pattern that I was looking for. And I am familiar with it from a programming point of view, I am curious if there is a database specific term though.
Apr
22
comment INFORMATION_SCHEMA Pattern
@AaronBertrand No, it is not.
Apr
21
asked INFORMATION_SCHEMA Pattern
Jul
28
awarded  Notable Question
May
14
awarded  Popular Question
Jan
10
asked SQL Server : Transactional Replication Filter By Computed Column
Sep
4
accepted SQL Server: Log Shipping Read Only
Sep
4
comment SQL Server: Log Shipping Read Only
Thanks for the info. I guess what this boils down to is the fact that log shipping is designed for backup purposes - not reporting. So (although it can be used to reduce the reporting load on the primary database) it is not truly designed for this. One of the big issues we are running into is the fact that the transaction indices and the reporting indices we require are very different and we do not want to add the reporting indices to the primary database (due to size,performance,etc).
Aug
31
asked SQL Server: Log Shipping Read Only
Aug
21
awarded  Scholar
Aug
21
accepted SQL Server : Transactional Replication Computed Column
Aug
20
awarded  Student
Aug
20
asked SQL Server : Transactional Replication Computed Column