New answers tagged insert
Your options are: Use PDO, which properly supports binary parameters; or Use pg_escape_bytea with string substitution into the query text. See http://stackoverflow.com/q/17121791/398670 .
We had a problem with AMD chipset where they would drop into power saving mode, reducing their clock speed by 50%. Worth a look.
I guess you could (ab)use MERGE for this. First create a (temporary) table: CREATE TABLE tempIDs ( PersonId INT, FinancialInstitutionId INT ) ; Then MERGE into Person (instead of INSERT), so you can use columns of the tables involved in the OUTPUT clause: MERGE INTO Person USING FinancialInstitution AS fi ON 1 = 0 WHEN NOT MATCHED THEN INSERT ...
You are asking SQL Server to perform 19.5 Billion string manipulations (300,000,000 rows X 65 columns), all in one giant transaction. That is assuming vbep_Full is a regular table with simple column definitions (not a view with joins to other tables and/or with computed comlumns). If your CPU is not maxed out, you could try breaking the work into multiple ...
GETDATE() is not guaranteed to be unique, no. Especially if it is a datetime, where milliseconds are rounded up or down, and of course when not all data is coming from the same user, you are almost guaranteed to have collisions. Of course, a clustered index does not need to be unique, since SQL Server will make it so if it isn't (but only when it needs to). ...
Sounds like your statistics are getting out of date, then eventually SQL's auto update statistics will kick in and update the stats, proper execution plans are being generated, then everything starts running faster again. If you have installed Service Pack 1 for SQL Server 2008 R2 then you can turn on Trace Flag 2371 which will change the algorithm which is ...
Top 50 recent answers are included