Reputation
793
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 13 33
Impact
~142k people reached

Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
7
comment Query intermittently fails with “The multi-part identifier could not be bound”
I'm trying to keep it open to multiple rows, eventually I do have some other tables I need to catch data from. As for the 4 part names, I used to be running this via the live server to send to the dev server (the links aren't on the dev server). Must have forgot I don't need them anymore
Jun
7
revised Query intermittently fails with “The multi-part identifier could not be bound”
added 161 characters in body
Jun
7
comment Query intermittently fails with “The multi-part identifier could not be bound”
@JNK The result's always going to technically be a Cartesian, but it's always one row to one row due to the database design. It's more of a config file than a table...
Jun
7
asked Query intermittently fails with “The multi-part identifier could not be bound”
Jun
7
comment Tools for Identifying Needed Indexes
Is there a query/table you're having poor performance on? As JNK implied you should really only add indexes when you know what you're doing (and test it regardless). Unless you have reason to believe a table needs an index (huge table, slow queries, an obvious clustered index) you shouldn't just try and add them
Jun
1
comment What is a database?
@Shark "in a computer" is how the term is used, generally. Hence "generally" in the entry.
Jun
1
revised What is a database?
clarified body and title
Jun
1
suggested approved edit on What is a database?
Jun
1
comment What is a database?
A miserable little pile of pages. But enough talk; have at you!
May
31
comment sqlcmd slow against SQL Server 2008 R2
I'm not supposed to be using 3.5 million individual one line text files?
May
16
revised Combine column from multiple rows into single row
added 173 characters in body
May
16
comment Combine column from multiple rows into single row
Yep, this works like a charm. @MarlonRibunal SQL Fiddle's really shaping up!
May
16
accepted Combine column from multiple rows into single row
May
15
asked Combine column from multiple rows into single row
May
14
revised Normalization and Breaking down tables for InnoDB
Removed fluff from title
May
14
suggested approved edit on Normalization and Breaking down tables for InnoDB
Apr
26
awarded  Nice Question
Apr
20
comment Identifying rows which don't match a master row
This solution was particularly excellent as I can use a variable as the table name, so I make one change and fetch totally different tables.