onedaywhen

United Kingdom

none

Age: 42

.NET SQL.

top accounts reputation activity favorites subscriptions

Does pair programming work when there is a skills impedance mismatch?

language-agnostic pair-programming asked Apr 24 '09 at 10:58

stackoverflow.com

14 votes

No indexes on small tables?

sql sql-server indexing tuning asked Oct 31 '08 at 8:21

stackoverflow.com

10 votes

Meaning of 'SET' in error message 'Null value is eliminated by an aggregate or other SET operation'

sql-server asked Jan 19 '12 at 14:34

dba.stackexchange.com

7 votes

Do these database design styles (or anti-pattern) have names?

sql design-patterns database-design anti-patterns asked Jun 5 '09 at 9:20

stackoverflow.com

7 votes

Should a SQL VIEW always be in 1NF?

sql normalization asked Jun 26 '09 at 13:14

stackoverflow.com

7 votes

Conversion failed when converting the varchar value to int

sql sql-server sql-server-2008 asked May 4 '10 at 10:19

stackoverflow.com

5 votes

VB6 authored ocx on a .NET WinForm?

.net winforms vb6 ocx asked Nov 4 '09 at 8:30

stackoverflow.com

5 votes

MS-Access or MDB or Access-Database-Engine or MS-Jet-ACE?

discussion stackoverflow tags asked Dec 17 '09 at 10:36

meta.stackoverflow.com

Top Answers

121

UPDATE from SELECT using SQL Server

stackoverflow.com

Foreign key constraint may cause cycles or multiple cascade paths?

stackoverflow.com

Storing money in a decimal column - what precision and scale?

stackoverflow.com

How to create a unique index on a NULL column?

stackoverflow.com

Database, Table and Column Naming Conventions?

stackoverflow.com

SQL Case Statement Syntax?

stackoverflow.com

Is it better to use ADO or DAO in Access 2007?

stackoverflow.com

One table or many?

stackoverflow.com

Access 2007 triggers and procedures equivalents?

stackoverflow.com

Is object clearing/array deallocation really necessary in VB6/VBA (Pros/Cons?)

stackoverflow.com

Can't implement a class in VB6

stackoverflow.com

Multiple constructors in VB6?

stackoverflow.com

Why don't DBMS's support ASSERTION

stackoverflow.com

Does it make sense to use SQL Server's bracket notation in hand written code?

dba.stackexchange.com

Why is there no PRODUCT aggregate function in SQL?

stackoverflow.com

How to check if a string is a uniqueidentifier?

stackoverflow.com

SQL View - add default values if null?

stackoverflow.com

Difference between a theta join, equijoin and natural join

stackoverflow.com

Foreign Key naming scheme

stackoverflow.com

What does “Shift:=” mean in this VB6 code?

stackoverflow.com

Why use an auto-incrementing primary key when other unique fields exist?

stackoverflow.com

Simulate a left join without using “left join”

stackoverflow.com

Why is my Access database not up-to-date when I read it from another process?

stackoverflow.com

Microsoft Jet wildcards: asterisk or percentage sign?

stackoverflow.com

Running multiple SQL statements in the one operation

stackoverflow.com

sql primary key integer/varchar

stackoverflow.com

How to implement historical versioning?

stackoverflow.com

SQL SERVER Foreign Keys and Indexes

stackoverflow.com

?? operator in sql

stackoverflow.com

What SQL databases support subqueries in CHECK constraints?

stackoverflow.com