12,395 reputation
2754
bio website maps.google.co.uk/…
location London, United Kingdom
age
visits member for 3 years, 7 months
seen 43 mins 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.


Jan
22
awarded  sql-server-2008
Jan
20
answered Datawarehouse bad practice?
Jan
15
comment SQL table up to date from TM1 cube
IIRC the utility you want is called TurboIntegrator or something like that. However, this question should be trivially answered with a little google-fu.
Jan
15
revised SQL table up to date from TM1 cube
edited tags
Jan
14
comment Free universe tool monitoring all database
Shopping list questions are off-topic for dba.se as they are primarily opinion based and do not necessarily have a definitive correct answer. See the FAQ
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 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