Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
Needed to update one column in table A with data from table B (huge table).
Created awesome update query with join between the two tables.
A few hours later realized all data in table A is already being imported from table B in a query executed earlier in the process... -
I always forget it's a bad idea to run queries in an "edit table" view in SSMS. Just blew up my table cause it decided to add an unwanted cross join in my update statement.
Ran it in a fresh query window and it worked fine.
Top Tags
Weekly Rant
View