Perhaps the best option is to keep the data online and in the database, but on a seperate read-only filegroups located on cheap drives. Those filegroups don't even need to...

If your tables and relationships are normalized, you don't use cursors, you leverage views and functions appropriately to reduce duplication without compromising performance, use standard naming conventions, and handle transactions...

There actually are methods to capture object access events for the purpose of maintaining usage data. We could do it with a SQL Profiler trace, filter on the appropriate events,...

Practically all database related breaches can be prevented by setting up user accounts with least privilege. Create a role that grants exec permission to only those stored procedures that the...

The problem with metrics is that most company's simply don't have an official standard. Ask ten different managers (in the same department) to examine a piece of code, and you'll...

For years I've been drinking about two cups of coffee a day with no concerns, but not because some guest on a morning TV news show suggested it's good for...

I guess it depends on the conext of the situation, but...

What I like are the realestate websites where you can see actual floor plans or recorded video allowing a virtual tour. A picture is worth a 1,000 data items.

The problem is that 3rd party websites that aggregate listings from multiple sources can't be too choosy about their data, because they have no control over the data entry etiquette...

Regarding different types of database automation, I like referential integrity and check constaints, because it automatically rejects bad data at the point of insertion. Otherwise, the developer or DBA has...

Participating in forums like SSC is for database professionals what weightlifting and practice drills are for professional fire fighters. If you're fighting fires every day, then something is seriously wrong,...

Or a technical recruiter.

:rolleyes:

lcasamen (2/8/2011)

---

Thanks for the quick replies! I don't need to worry about gaps in sequences - Oracle loses values on rollback too, and I just need matching functionality. Long term...

Regarding job descriptions with too many technical requirements and resumes full of bogus experience, in many cases it's the result of a 3rd party recruiter acting as an intermediary and...

The forthcoming version of SQL Server, codenamed "Denali" will have a sequence type object that functions similar to Oracle's sequence. However, just like an identity, it can also result in...