@ConcernedOfTunbridgeWells I see it more as dedicating a Saturday night to meeting a load of awesome people & having a good time. Definitely no giving up involved
So...I had a question closed yesterday as being a typo (Which it isn't), I believe it's actually due to a constraint. How do I view what the action of a constraint is, in MSSQL management studio 2014?
I have a query I wrote to move a single entry from an archive table to an active table.
If I leave the isNew field out of the query, the row gets inserted again into the archive table (duplicated, essentially). If I add the isNew field into the query, it moves it to the active table.
@JohnP It feels to me like a trigger like @JoshDarnell said. I can't think of anything else. Unless there's a separate job running to move the data between those tables
@JohnP Anyway, that should show you the actual objects being accessed in your query. You could compare it to the one that works (where you include the bit column) and see what's different.
@JohnP That plan shows one row being read from a table in a database, and then inserted into a table of the same name in a different database. AKA that looks like the "working" plan, is that right?
@TomV I don't see anything but the system views folder under the view folder for the configdel table.
@George.Palacios @JoshDarnell - Oddly, when I run the query to do the insert/select, I get a message of (1 row(s) affected) twice. So I'm assuming the system is telling me that it inserted it then immediately deleted/moved it.
Ok, more info. I took out the insert of the "isNew" field, ran the query and immediately ran a select * from the destination table. It showed up, then disappeared on a subsequent select *.
So the query isn't failing, there is something else working
@JohnP ...is this some kind of queue? Is Service Broker being used (anything under the database level Service Broker folder, especially under "Queues" or "Services")?
@JohnP If you expand the SQL Server Agent node in SSMS, double-click "Job Activity Monitor", then sort by "Last Run", you should see jobs that completed recently. You can also look at "Next Run" to see if it's scheduled to run every, like, 2 seconds or whatever.
Gotcha. Well your best bet then is to either use tracing / profiling / extended events to try and track this down yourself, or ask the developer / vendor what process deletes rows from that config table.
I have a VPS that I using solely to build a web api on. I've got a huge database with quite a few tables with anything between five hundred thousand and 500 million records in each one.
What is the fastest database system to use to index these so that I can search through the records in a few se...