14,016 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 11 months
seen 2 days ago

Oracle DBA, Unix admin.

Available for employment! ;)


Nov
16
comment When using underscores, should they be reserved to junction tables?
CamelCase? Not when using a RDBMS. Everything should be uppercase, I agree with @a_horse_with_no_name on that. Case sensitivity shouldn't come into it.
Nov
12
comment Data are not saved to database - Auto creating new datafile in oracle
Oracle doesn't create data files automatically? Sure you didn't have a script doing this for you?
Nov
12
comment Paging via Number of Result Record vs COUNT(*)
@cgoddard Oracle didn't have LIMIT before 12c came out (you had to use a subquery and rownum), so that probably explains the lack of it :)
Nov
12
reviewed No Action Needed Access 2010 After Insert data macro to update another table
Nov
12
reviewed No Action Needed Does SQL Server require SSLv3?
Nov
12
reviewed No Action Needed SQL Backup tuning large databases
Nov
12
reviewed No Action Needed Select statement for selecting every week's log record
Nov
12
reviewed Close SQL Server Dba backup related
Nov
12
reviewed Close Foreign Key Error
Nov
12
reviewed Close How to insert values into Bridge Table in star schema?
Nov
12
reviewed Close SQL Delete duplicate rows based on column
Nov
12
reviewed Close Impact of Service Broker on Server Performance
Nov
12
reviewed Close SQL Server edition support
Nov
12
reviewed Close Getting Time Duration
Nov
12
comment Get latest status of an item in the database
Which RDBMS are you using?
Nov
12
comment Get latest status of an item in the database
You've also assumed which RDBMS the OP is using. MySQL doesn't support row_number(), for example.
Nov
7
reviewed Approve How can I help SQL Server recognize my indexed view column is NOT NULL-able?
Nov
6
reviewed Close What does a high level overview of the logic backing database queries look like?
Nov
6
reviewed Close Time Series data for controllers connected to other devices
Nov
6
reviewed Close Composite Foreign key to single primary key