51 reputation
1
bio website
location
age
visits member for 1 year, 11 months
seen Nov 4 '13 at 22:07

Jul
5
comment Need to add a Table Level Constraint to prevent bad data - Constraint is not working
Thanks. I think we will hold off on this for now.
Jul
5
comment Need to add a Table Level Constraint to prevent bad data - Constraint is not working
It's not really a check to see which one should win. Its a check that says fail the insert/update if there is already a record for that claim that has LastAssigned=1. Does that make sense?
Jul
5
asked Need to add a Table Level Constraint to prevent bad data - Constraint is not working
May
25
comment How to handle reporting of an extreme amount of databases in SQL Server 2005?
Interesting idea. My concern would be restoring the dbs over 20gbs every night. And how long that would take. And if the restore for some reason does fail, which would be great to know for testing purposes, would not be so good for our customers who would now not be able to get to their reports.
May
24
comment How to handle reporting of an extreme amount of databases in SQL Server 2005?
No we do not have Analysis services at this point. We are using reporting services with stored procs stored in the oltp customer databases.
May
24
awarded  Student
May
24
asked How to handle reporting of an extreme amount of databases in SQL Server 2005?