15,086 reputation
12553
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 3 years, 2 months
seen 6 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


15h
comment Query that was working on MySQL is not working on PostgreSQL
What's the data type of location_id? Why is an integer in quotes?
20h
reviewed Approve VACUUM FULL fails with 'ERROR: Check free disk space'
20h
reviewed Leave Closed Guidance in creating a database for parks division attendance data
20h
reviewed No Action Needed Get the latest record and count them with time interval
20h
reviewed No Action Needed SQL Query challenge
21h
reviewed Close sql query for hierarchal search
1d
reviewed Reviewed how many database tables is too much?
1d
reviewed No Action Needed Can mutli-threading java client cause high CPU utilization of SQL Server 2008?
2d
comment optimisation for 4million + records
Impossible to help you without a query explain, and list of current indexes.
2d
reviewed Close How to Insert geom line in geom geometry column?
2d
reviewed Close Can I setup database triggers to run on a defined secondary set of servers only?
2d
reviewed Close master-slave vs masterless architecture
2d
comment can we create a user defined groups with different users and different schemas in oracle11 g
They're called roles in Oracle. Read the documentation. docs.oracle.com/cd/B19306_01/network.102/b14266/admusers.htm
Mar
27
reviewed No Action Needed Access denied to user@localhost
Mar
27
reviewed No Action Needed PostgreSQL pg_upgrade --link mode performance issue after upgrade
Mar
27
reviewed No Action Needed Unable to get the latest value added to Mysql table based on posted time
Mar
27
reviewed Close Retrieve user Permissions on a database
Mar
27
reviewed Close What will be the Better database design for following table?
Mar
27
reviewed Close Can anyone convert this SQL into Rational Algebra Format
Mar
26
reviewed No Action Needed SQL Server execution plan using a view, but no view is inside the stored procedure