Stack Exchange

Nick Chammas

North Providence, RI

http://www.linkedin.com/in/nchammas

Notable posts:

  • Debunking a persistent SQL Server myth about TRUNCATE.
  • Debunking another SQL Server myth about variable declarations causing proc recompiles.
  • Understanding how certain SQL Server functions dynamically cast their output.
  • Using a recursive CTE to find the first ancestor in a hierarchy to satisfy certain conditions.
top accounts reputation activity subscriptions
Top Questions
79 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, 2011 at 0:59
dba.stackexchange.com

69 votes

When should I rebuild indexes?

sql-server index-maintenance asked Aug 3, 2011 at 18:43
dba.stackexchange.com

66 votes

How do you kill Futures once they have started?

python multithreading concurrent.futures asked Mar 20, 2015 at 23:42
stackoverflow.com

66 votes

What's the correct way to clean up after an interrupted event loop?

python python-3.4 python-asyncio asked Jun 10, 2015 at 19:30
stackoverflow.com

64 votes

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

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

42 votes

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

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

41 votes

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

sql-server sql-server-2008 database-design database-internals asked Jun 1, 2012 at 22:39
dba.stackexchange.com

38 votes

Did something about `namedtuple` change in 3.5.1?

python typeerror python-3.5 namedtuple asked Dec 8, 2015 at 21:35
stackoverflow.com

31 votes

Designing a platform: one database or multiple databases?

database-design deployment asked Aug 10, 2011 at 23:16
dba.stackexchange.com

21 votes

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

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

1 2 3 4

Top Answers
501
How to wait for 2 seconds?
stackoverflow.com

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

142
Should developers be able to query production databases?
dba.stackexchange.com

127
Write to multiple outputs by key Spark - one Spark job
stackoverflow.com

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

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

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

41
How to query JSON data column using Spark DataFrames?
stackoverflow.com

34
How to save a DataFrame as compressed (gzipped) CSV?
stackoverflow.com

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

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

27
How to read multiple gzipped files from S3 into a single RDD?
stackoverflow.com

27
Spark SQL replacement for MySQL's GROUP_CONCAT aggregate function
stackoverflow.com

24
What are the differences between slices and partitions of RDDs?
stackoverflow.com

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

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

22
Spark: Repartition strategy after reading text file
stackoverflow.com

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

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

20
What are the files generated by Spark when using "saveAsTextFile"?
stackoverflow.com

19
How to fully utilize all Spark nodes in cluster?
stackoverflow.com

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

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

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

17
How do I find my current SCN?
dba.stackexchange.com

17
Multiple operations using WITH
dba.stackexchange.com

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

16
DataFrame equality in Apache Spark
stackoverflow.com

16
Partitioning a large skewed dataset in S3 with Spark's partitionBy method
stackoverflow.com

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

1 2