Nick Chammas

less info
meta site favicon meta user | stack exchange network profile network profile
5,920 reputation
22763
bio website linkedin.com/in/nchammas
location Gwangju, South Korea
age 26
visits member for 1 year, 9 months
seen 23 hours ago
stats profile views 605

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).


60 Answers

newest activity votes
61
Should developers be able to query production databases?
60
Why use both TRUNCATE and DROP?
29
Is table aliasing a bad practice?
20
Is nested view a good database design?
16
Passing array parameters to a stored procedure
15
Why does 10^37 / 1 throw an arithmetic overflow error?
14
Why does “SELECT POWER(10.0, 38.0);” throw an arithmetic overflow error?
14
SQL Server schema intact but every record from every table is gone
12
Optimization: Moving variable declarations to the top of your procedure
10
Does an IOT guarantee order in a select?
10
How do I map an IS-A relationship into a database?
9
How do I force one record to have a true value for a boolean column, and all others a false value?
9
Why does = NULL not work in Oracle?
8
What reason is there to create a physical table for a report output?
8
Why is SSMS inserting new rows at the top of a table not the bottom?
8
How to know when/if I have too many indexes?
7
Is it better to populate variables using SET or SELECT?
7
Splitting Tables in MySQL. Good practice?
7
Does the PCI standard forbid the use of Windows Authentication?
7
Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
7
Best way to design this mileage table?
7
What is the default order of records for a SELECT statement in MySQL?
6
Does it make sense to use SQL Server's bracket notation in hand written code?
6
How do I copy my SQL Azure database to a local SQL Server instance?
6
When should I rebuild indexes?
5
Remove sub-string from WHERE clause
5
Save Connections in SSMS?
5
What is SQL Server “Denali”? What's new?
5
Multiple operations using WITH
5
What is SQL Server “Denali”? What's new?
1 2