ConcernedOfTunbridgeWells

10,392 reputation

1949

bio	website	maps.google.co.uk/…
	location	London, United Kingdom
	age
visits	member for	1 year, 11 months
	seen	11 hours ago
stats	profile views	504

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.

	10,392 reputation	bio	website	maps.google.co.uk/…	visits	member for	1 year, 11 months
1949 badges		location	London, United Kingdom		seen	11 hours ago

summary answers questions tags badges favorites bounties reputation activity

158 Answers

newest activity votes

How does optimistic locking actually enforce re-read/update?

Choosing the right algorithm in HashBytes function

Why can't RDBM's cluster the way NoSQL does?

Using SQL Server 2012 for Business Intelligence Features Only, No Database Engine

How to handle dimension hierarchies that re-join?

SSAS Drillthough Limit

Perl vs Ksh for Unix Database Administration

I was interrupted while transferring a very large table. How can I pick it up from where it stopped?

Understanding Oracle's ALL_TAB_COLUMNS

What are the pros/cons of splitting date and time into separate fields vs. using the datetime data type and storing the date in a single field?

Can I optimize for the zIIP processor?

Database structure, relational or data warehouse?

What are the arguments in favor of using ELT process over ETL?

What is the “Data partitioned, Shared-Nothing, Parallel Database” solution for PostgreSQL ?

Scriptable command line access to SQL-Server from linux

encryption of SSRS subscription emails and attachments

SSIS ETL Question/Option

Few Questions about SSAS Cubes

Write Access Client App for SQL Server 2005 Backend

SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?

Advice on choosing a really fast DBMS

ETL: extraction strategy for 200 source databases

Performing aggregations and calculations: SQL (CTE) vs MDX

Teradata: How to design table to be normalized with many foreign key columns?

As a DBA, how would I go about transitioning from Oracle to SQL Server?

Is a year-to-date dimension the same as a time dimension?

What type of datastore should I use for high volume time series data?

Data type for currency 'type' column, e.g. usd, cat, etc.

Why is 'LOAD DATA INFILE' faster than normal INSERT statements?

ERwin Data Modeler Support