| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | Jul 5 '12 at 21:57 | |
| stats | profile views | 1 |
|
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? |