Stack Exchange

Nick Chammas

Gwangju, South Korea

linkedin.com/in/nchammas

Age: 26

Notable posts:

I am a Database Developer and Administrator. My specialty is database design and development, and in my spare time at work I like to develop highly specialized visualizations (generally using Processing).

top accounts reputation activity favorites subscriptions
Top Questions
39 votes

You quench your thirst. What do you do with your hunger?

word-choice single-word-requests analogy asked Feb 16 '12 at 23:02
english.stackexchange.com

23 votes

Why should I use Visual Studio 2010 over SSMS for my database development?

tools ssms visual-studio visual-studio-2010 asked Nov 4 '11 at 21:52
dba.stackexchange.com

19 votes

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

sql-server sql-server-2008 database-design aggregate indexed-view asked Sep 10 '11 at 0:59
dba.stackexchange.com

17 votes

Designing a platform: one database or multiple databases?

database-design deployment asked Aug 10 '11 at 23:16
dba.stackexchange.com

15 votes

Does the order of columns in a table's definition matter?

sql-server sql-server-2008 database-design asked Jun 1 '12 at 22:39
dba.stackexchange.com

14 votes

My edit was rejected for incorrect (and seemingly random) reasons. How do I justify and resubmit it without starting a little edit fight?

discussion suggested-edits asked Nov 1 '11 at 22:41
meta.stackoverflow.com

14 votes

Does Stack Exchange follow the 1% rule?

discussion statistics participation asked Apr 29 '12 at 0:24
meta.stackoverflow.com

12 votes

When should I rebuild indexes?

index maintenance asked Aug 3 '11 at 18:43
dba.stackexchange.com

10 votes

Why does SQL Server “Compute Scalar” when I SELECT a persisted computed column?

sql-server sql-server-2008 execution-plan asked Jun 1 '12 at 20:54
dba.stackexchange.com

7 votes

How can I have SQL Server email me the error details when a job fails?

sql-server monitoring asked Aug 17 '11 at 16:18
dba.stackexchange.com

1 2

Top Answers
61
Should developers be able to query production databases?
dba.stackexchange.com

59
Why use both TRUNCATE and DROP?
dba.stackexchange.com

29
Is table aliasing a bad practice?
dba.stackexchange.com

20
Is nested view a good database design?
dba.stackexchange.com

16
Passing array parameters to a stored procedure
dba.stackexchange.com

15
Why does 10^37 / 1 throw an arithmetic overflow error?
dba.stackexchange.com

14
SQL Server schema intact but every record from every table is gone
dba.stackexchange.com

14
Why does “SELECT POWER(10.0, 38.0);” throw an arithmetic overflow error?
dba.stackexchange.com

12
Optimization: Moving variable declarations to the top of your procedure
dba.stackexchange.com

12
Is there a way to make a column's nullability depend on another column's nullability?
stackoverflow.com

10
How do I map an IS-A relationship into a database?
dba.stackexchange.com

10
Does an IOT guarantee order in a select?
dba.stackexchange.com

10
How to wait for 2 seconds
stackoverflow.com

9
Why does = NULL not work in Oracle?
dba.stackexchange.com

9
How do I force one record to have a true value for a boolean column, and all others a false value?
dba.stackexchange.com

8
How to know when/if I have too many indexes?
dba.stackexchange.com

8
Why is SSMS inserting new rows at the top of a table not the bottom?
dba.stackexchange.com

8
What reason is there to create a physical table for a report output?
dba.stackexchange.com

7
What is the default order of records for a SELECT statement in MySQL?
dba.stackexchange.com

7
Best way to design this mileage table?
dba.stackexchange.com

7
Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
dba.stackexchange.com

7
Does the PCI standard forbid the use of Windows Authentication?
dba.stackexchange.com

7
Splitting Tables in MySQL. Good practice?
dba.stackexchange.com

7
Is it better to populate variables using SET or SELECT?
dba.stackexchange.com

6
When should I rebuild indexes?
dba.stackexchange.com

6
How do I copy my SQL Azure database to a local SQL Server instance?
dba.stackexchange.com

6
Does it make sense to use SQL Server's bracket notation in hand written code?
dba.stackexchange.com

5
How to design a database for storing a sorted list?
dba.stackexchange.com

5
What is SQL Server “Denali”? What's new?
dba.stackexchange.com

5
Multiple operations using WITH
dba.stackexchange.com

1 2