Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

Dec
15
awarded Popular Question
Dec
10
comment You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1
The SQL error message suggests something is wrong with your SQL string. Write out the $insert variable and verify it.
Dec
5
awarded insert
Nov
29
comment Streaming video from SQL Server 2008 to an HTML 5 video player
@user2909756: Sometimes it makes sense to store files SQL Server. Say high value content that you want to back up along with your other customer data. For example, PDF documents that you like to retain as evidence of a commercial transaction.
Nov
24
awarded Enlightened
Nov
24
awarded Nice Answer
Nov
11
awarded Guru
Nov
10
comment How to identify and display difference between values in two rows of a table
@bummi: Didn't see that, and lag() is only available in 2012 and higher
Nov
10
comment How to identify and display difference between values in two rows of a table
Not sure if difference equals subtraction in this context. And how does your query filter the two latest rows with the same CID?
Nov
10
answered How to identify and display difference between values in two rows of a table
Nov
10
revised How to identify and display difference between values in two rows of a table
edited tags
Nov
9
comment Checking if HyperThreading is enabled or not?
If you have a Xeon processor with 4 cores, it will show as one physical id and four processors. So you can have multiple processors per physical id without hyperhtreading.
Nov
5
comment how to do dead reckoning on column of table, postgresql
+1 This seems to work nicely But how does over () decide the order of rows? Might it not for example label the row with y is not null as number 2, counting it double and omitting another row?
Nov
5
answered how to do dead reckoning on column of table, postgresql
Nov
5
comment how to do dead reckoning on column of table, postgresql
Tables are unordered sets. Is there an id column, or how else do you determine the order of rows?`
Nov
5
answered Optimize table and sql query in such a manner that obtaining data between 2 timestamps becomes fast
Nov
4
answered How to prevent autovacuum for table in Postgres
Nov
4
awarded Copy Editor
Nov
4
revised How can I transform a list into a csv?
edited title
Nov
4
answered How can I transform a list into a csv?
1 2 3 4 5