ConcernedOfTunbridgeWells

less info
11,686 reputation
2552
bio website maps.google.co.uk/…
location London, United Kingdom
age
visits member for 2 years, 10 months
seen 13 hours ago

Data warehouse contractor in London. Mostly I work with SQL Server on Insurance clients. I've proposed a business intelligence site on Area 51, which has now been merged into dba.stackexchange.com.


13h
revised A rollback on a production server that's been running too long
deleted 6 characters in body
Apr
8
comment Is Oracle more demanding environment for a DBA than SQL Server?
@gbn - they let me do Oracle DBA work at one point.
Apr
5
comment Import 10 Billion Rows, Daily
in that case you might want to pre-process the field, parse out the data you want and punt the fluff. This could be done off-line before loading it into the database.
Apr
5
comment Import 10 Billion Rows, Daily
You might also want to run multiple bulk insert tasks in parallel. Scalzo's The Oracle DBA guide to data warehousing and star schemas discusses a technique for doing this on Oracle and its bulk load tool (SQL*Loader). You could do something similar with a .net wrapper that can spawn multiple processes.
Apr
5
comment Import 10 Billion Rows, Daily
The varchars would only be that big if they were free text. I can't imagine anyone keying 10 billion free text fields into anything on a daily basis, so they're much more likely to be alphabetic or alphanumeric codes, and probably only a few bytes long each.
Mar
8
awarded  Nice Answer
Mar
6
comment PostgreSQL designing tool
See This reply from a vendor representative for a good example of how a vendor can contribute an answer of this type.
Mar
3
awarded  Good Answer
Jan
29
comment How recording of every change of a row in a database is generaly stored?
For 1000 tables you write a utlity that reads the definitions from the system data dictionary and generates the triggers and table definitions. I've done it on a system with 560 tables and it works just fine.
Jan
19
reviewed Approve suggested edit on Can't connect to local Postgres databases
Dec
21
awarded  Necromancer
Dec
1
reviewed Approve suggested edit on Does MySQL cache queries?
Nov
28
awarded  Good Answer
Nov
26
reviewed Approve suggested edit on DDL trigger AFTER ALTER ON SCHEMA behavior
Nov
25
reviewed Approve suggested edit on How to set up simple database replication using WAMP server?
Oct
31
reviewed Approve suggested edit on How do I discover the Oracle Express workspace name?
Oct
31
reviewed Reject suggested edit on Unable to determine the replication service template?
Oct
22
reviewed Approve suggested edit on How to find index organized table
Sep
27
comment Production (20GB+) Database running slowly and timing out
@Lord Relix - Page IO latch wait times (the time a process within SQL Server is held up waiting for I/O to complete) is indicative of an I/O bound process. This could be a hardware problem or a query optimisation problem where the query optimiser has generated a wildly suboptimal plan for some reason. Take a look in the DMVs for the queries with the most I/O waits. This may give you a clue which queries are causing the problem.
Sep
17
reviewed Approve suggested edit on how auto_increment work in mysql