12,166 reputation
2753
bio website maps.google.co.uk/…
location London, United Kingdom
age
visits member for 3 years, 5 months
seen 1 hour 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.


Oct
22
awarded  Taxonomist
Sep
24
awarded  Autobiographer
Sep
1
comment How to architect an analytical BI platform?
I doubt you'd find any objective case studies on this sort of kit. It starts at 6 digits and goes up from there, so independents like AnandTech are never going to buy up a batch of machines for comparison. The majority of literature will come from the vendors and should be taken with a grain of salt.
Aug
31
revised How to architect an analytical BI platform?
added 40 characters in body
Aug
31
comment How to architect an analytical BI platform?
There is a question hidden in here, asking whether OP is likely to need a different DBMS platform to support ETL for the system. @sfactor - you might try re-phrasing the question to make this a bit more clear.
Aug
31
answered How to architect an analytical BI platform?
Aug
20
comment Stored Procedure null parameter within where clause
You can also inline this sort of thing with and isnull (@Parameter3, Table1.ID2) = Table1.ID2, although the query optimiser won't get much more joy from it.
Aug
18
comment How do tablespaces differ in DB2 from databases in MySQL or SQL Server?
The question was closed because it was poorly worded and seemed to contain some incorrect assumptions. Unfortunately the moderation process has to be fairly ruthless about this sort of stuff or the forums would be overrun with drivel and rendered useless. If you fix up your basic research and clarify the question then ping the mods on The Heap you can get it re-opened.
Aug
10
comment How do tablespaces differ in DB2 from databases in MySQL or SQL Server?
That's not strictly correct. In SQL Server speak, tablespaces are called filegroups. A SQL Server database is something like a schema in Oracle or DB2, but is more autonomous. It has its own permissions, data dictionary, configuration and schema namespace. A database is more like a mini instance than an Oracle/DB2 schema but does not require a whole separate process. You can also run multiple SQL Server instances if you feel so inclined.
Jul
29
reviewed Edit suggested edit on Checking whether two tables have identical content in PostgreSQL
Jul
29
revised Checking whether two tables have identical content in PostgreSQL
Edited sentence of spelling
Jun
26
comment What is a good/healthy mysql query execution time?
Take a look at the query plans and then estimate the I/O needed to satisfy each query. For a small number of queries this shouldn't be too hard. Then (under load) look at the disk buffer cache hit rate and tune the DBMS accordingly if necessary. On a modern server you should be able to get buffer cache hit rate percentages in the high 90's. Apply that to your reads. Make an estimate of your write traffic. That should give you a back-of-fag-packet IOPS figure.
Jun
26
comment What is a good/healthy mysql query execution time?
The question is somewhat vague. Take a look at the answer below for some suggestions as to where to start.
Jun
26
answered What is a good/healthy mysql query execution time?
Jun
10
awarded  Yearling
May
5
comment Database design for handling 1 billion rows and counting
Are you inserting the data row-by-row or using batched bulk inserts?
Apr
17
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.