ninesided

ninesided has asked 50 questions and find answers to 74 problems.

Stats

About

SOreadytohelp

ninesided questions

How do I check whether a savepoint has been established before issuing a rollback?
Is there some way of recycling a Crystal Reports dataset?
What is the best way to model user defined hierarchical relationships in a database?
What release management solutions are worth investigating? [closed]
What are the advantages of explicit Join Transitive Closure in SQL?
How do you programatically identify a stored procedure's dependencies?
Speed of SELECT vs. SET in T-SQL
What's the best way of doing dos2unix on a 500k line file, in Windows? [closed]
How do I make my Java application identify itself to Oracle on connection?
Best use of indices on temporary tables in T-SQL

ninesided answers

Weird many to many and one to many relationship
Multiple database transactions on a single connection
Query to find all the tables with date columns in it
Is there an equivalent to typedef in Transact-SQL?
How to design SQL tables when column data arrives in multiple types/margins of error?
Get Common Rows Within The Same Table
Using flickr to get photos of a specific location and put together a model
What is the best strategy for retainment of large data sets?
Database cleanup after Junit tests
Oracle's OUTER JOIN (+) on string - Migration PostgreSQL