Andy

Broward County, FL

Age: 25

Literature -> Computer Science -> Chemistry -> Linguistics student. Don't ask.
Currently a research analyst in compliance for a large corporation.

I am a big fan of chocolate milk.

Nov
24
awarded Popular Question
Nov
13
comment Is there a word (or phrase) that describe a series of mishaps/misfortunes in one's life?
"Life" is how I tend to describe it.
Nov
12
comment Creating a Persistent Local Table in SQL Server 2012
In response to part 2 of my question, SSMS 2012 can easily handle a list of 45,000 integers in an IN clause, but apparently only if the list is broken up vertically instead of a one-line list. The list can be very easily created using substitution expressions in vim.
Nov
11
awarded Autobiographer
Nov
11
revised Creating a Persistent Local Table in SQL Server 2012
Addendum to clarify
Nov
11
asked Creating a Persistent Local Table in SQL Server 2012
Nov
7
awarded Enlightened
Nov
7
awarded Nice Answer
Nov
6
awarded Teacher
Nov
6
answered meaning of "vague that up"
Nov
5
awarded Autobiographer
Nov
5
answered What are the differences in these phrases?
Nov
5
awarded Supporter
Nov
5
awarded Autobiographer
Oct
30
awarded Supporter
Oct
29
awarded Benefactor
Oct
29
comment Complex joins with counts not dependent on all tables
While this does not solve my problem, which turns out to be caused by a faulty dataset as well, it does answer the question.
Oct
29
accepted Complex joins with counts not dependent on all tables
Oct
28
comment Complex joins with counts not dependent on all tables
My original query produced a result from a 119 column, 2.7M row dataset in 150s on a slow test server. Is this consistent with what you'd expect from such a misstep? Genuine curiosity, as I'd expect a cartesian product to take much longer to generate. Perhaps 2.7M rows is a small set, I don't have any frame of reference.
Oct
28
comment Complex joins with counts not dependent on all tables
@AaronBertrand thank you for bringing that to my attention! All of my knowledge of SQL is self-taught and has come from workplace necessity. Pre-acquisition, it was my company's policy to use NOLOCK for anything that does not explicitly alter the database. I'm going to read up on this some more and see if it should be brought to anyone's attention.
1 2 3 4 5